Recent content by Paul1100

Thank you it works now

now i get a run time error 3137 missing semicolon ; at end of sql statement new code below: DoCmd.RunSQL "INSERT INTO[OverRide Table]([ProductID],[EmployeeNumber],[Date])Values([Forms]![OverRide Table].[ProductID],[Forms]![OverRide Table].[EmployeeNumber],[Forms]![OverRide Table].[Date & Time])...

Your are exactly right pbaldy i do have two records in the AuthorizedUsertoOverride table however i am not sure where to insert the values option into my statement? does the Values replace Select or is this and totally new added parameter?

Hi, I have a problem when i run this form and it completes ok but it tells me that 2 lines will be appended to my table!! both lines are identical the data is correct but don't know why i get two? my code for Access 97 follows: DoCmd.RunSQL "INSERT INTO[OverRide...

ChrisO that is it such a small change can a big difference

ok i think you want the whole database but i can't upload it my company has some kinda of firewall thing that errors me out. but you are right the empID is numeric and the security code is text

Okay i tried it again an this time i get an error 438 object does not support this property or method! Here is the revised code: Answer = DLookup("[Security Code]", "AuthorizedUsertoOverRide", "[Security Code] = '" & [Forms].[OverRide Table].[Security Code] & "' And [EmployeeNumber]= " &...

oops I'm sorry and thanks for being so understanding here is the revised code Answer = DLookup("[Security Code]", "AuthorizedUsertoOverRide", [Security Code] = '" & [Forms].[OverRide Table].[Security Code] & '" And [EmployeeNumber]= " & [Forms].[OverRide Table].[EmployeeNumber])

Pbaldy i don't understand your statement "did I miss:"

Pbaldy the compile error states expected expression and if i hit ok it goes to the ' after security code =

Bob i tried your suggestion and i get an error 438 object does not support this property or method

i'm sorry yes this does have 2 set of criteria and i tried what you said but a get a compile error now

Hi all, I hope someone can help me i have the following code and keep getting an error when running but i can seem to fine the right combinations to make it work. I'm a novice and am lost please help!! Dim Answer As Variant Dim Count As Variant Answer = DLookup("[Security Code]"...

All, I am have been trying to figure out a way to link data from one form to the other with no joy i am a novice at best. My situation is I have a form called Run Query and it get four lines of data updated when the user enters a serial number it also has an OverRide button that should ask for...

Thank you for your response but i also notice that in my code i had not ended my first if statement so i did by moving the end sub command before i started the second if and all seems to work now. thanks, Paul