Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Check for existing records
Message
From
23/08/2001 11:07:48
 
 
To
All
General information
Forum:
Microsoft Office
Category:
Access
Title:
Check for existing records
Miscellaneous
Thread ID:
00547990
Message ID:
00547990
Views:
33
I am new to msaccess and have started building an app using wizards. I am now at a point where I need to add some coding and am not sure where to start. I currently have the user to fill in values (one of which is a unique tracking #) in a form and when they click a command button the values of the form are appended to a table. What I would like to do is check the table to see if that tracking number has been entered yet. If it has, I want to prompt the user "Record exists: Do you wish to overwrite Y/N" Yes will overwrite the values in the record; No will do nothing. If the tracking number has NOT been entered yet the existing code will add it to the table. Any help would be appreciated.
Here's to alcohol...the cause of ... and solution to ... all of life's problems - - Homer J. Simpson
Reply
Map
View

Click here to load this message in the networking platform