Fixed it, You were right I didn't have the "match" field on the form. Thank you very much for your help. One last question. As you know I'm learning Access slowly, How do I go into Debug when the program is running. Once again Thanks very much and kind regards Dave
Thanks for your idea, I did exactly as you said and on entering the button the program processed all the records. The only thing was that my table called “STD Master Update” didn’t update in the new “occur” field with yes. Any Ideas? Many Thanks…….Dave
Hi Could someone please help me. I have the following data structure (this example is a small selection of data and there will be several thousands of records within the database)
"id" "badge" "Date" "Match"
35 "01444" 16/02/2004 "yes"
36 "01444" 17/02/2004
37 "01444" 29/03/2004 "yes"
38...
Thanks Mute101 for your expert help. I am new to programming in access and until now used only the basics, could help me one more time. Sorry for being thick, but I presume I was to place your code in the General Declarations (was this correct)then somehow call the sendemail command
many thanks...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.