 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / March 2007Duplicate Records Using Access 2000
I have a database for people to book on to courses that we run. One of the tables is course Instances eg Course name Course Date Course Time etc. I would like to create a Macro that I can add to a button that willl check to see if the course already exists in the table is there a query I can create that will check the table if the course already exists I will ge an error message but if the course does not exist I will move on to add the next record Hope this makes sense. Thanks in advance for any help you may be able to give.  SignatureRegards Clair Another way to approach this, rather than having the user enter all the info and THEN be told the course already exists, would be to use a combo box to list all the available courses. Let the user select the one desired or, using the NotInList event, prompt them to enter a new one. JOPO (just one person's opinion) SignatureRegards Jeff Boyce Microsoft Office/Access MVP http://mvp.support.microsoft.com/ Microsoft IT Academy Program Mentor http://microsoftitacademy.com/ Microsoft Registered Partner https://partner.microsoft.com/ > I have a database for people to book on to courses that we run. One of the > tables is course Instances eg Course name Course Date Course Time etc. I [quoted text clipped - 5 lines] > > Thanks in advance for any help you may be able to give. Dear JOPO Thanks for your reply. I am a bit of a novice at this but I am not trying to pick a course from a list I just want to add new courses and to avoid adding the same course on the same day at the same time based on the date and time. PS I think I can use your advice somewher else on the database. SignatureRegards Clair > Another way to approach this, rather than having the user enter all the info > and THEN be told the course already exists, would be to use a combo box to [quoted text clipped - 17 lines] > > > > Thanks in advance for any help you may be able to give. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.