Search results

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...

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...

Hi, I am trying to run vba code when i enter data on a field in a form. i would like to do a dlookup and followed it by running an append query depending on the outcome of the dlookup. I not sure how to do this if i am in the wrong area please tell me my code is below: Private Sub...

HI, all i am new to this and have never done any type of social networking before. I am and engineer with a contract manfacturer and am working on my first ms access project. Hope to here from you guys soon. Paul