Forum Replies Created

Viewing 10 posts - 1 through 10 (of 10 total)

  • RE: problems with return parameter of store procedure

    You might consider using a user defined function rather than a stored procedure.

  • RE: Duplicate rows in Access

    Katrina,

    I created two tables in a SQL Server database and linked to them from Access through an ODBC connection.  The tables are Table1 and Software.

    I inserted the following data into...

  • RE: A senior moment?

    99.0/2.0 = 99.0/2 = 99/2.0 = 49.500000

    Highest precision seems to dictate the result data type.

     

  • RE: A senior moment?

    try select 99.0/2.0

     

  • RE: Access and Triggers

    As you probably have already determined, MSAccess only provides events for Forms and Controls.  If your AutoNumber (aka Identity) field is incrementing, not random, then after you insert the record,...

  • RE: xp_sendmail poor performance

    Yes, I tried sending the same e-mail through Outlook and it did not exhibit the same behavior.

    I have since developed my own extended procedure to send an e-mail. It...

  • RE: Using "Like" or Wildcard

    Does this get you what you want?

    SELECT LEDef_ActiveInd, LEDef_Cd

    FROM LEDef_PK

    WHERE (LEDef_ActiveInd = 1) OR

    ...

  • RE: Bi-directional replication

    quote:


    I Think it is doable,have you tested it?


    Not yet. Thought I'd consult the...

  • RE: Bi-directional replication

    quote:


    I Think it is doable,have you tested it?


    Not yet. Thought I'd consult the...

  • RE: Bi-directional replication

    quote:


    Can you elaborate on this a bit, describe the database data to me. I think you may be wanting to use updating...

Viewing 10 posts - 1 through 10 (of 10 total)