Neal has attended:
Access Advanced course
Access Run-time
I have created marcos to 'send email' and 'save data to as excel to a specific folder'. When the Run-time user opens the database and click the button on the switchboard the marco errors.
Why?
Any suggestions?
Thanks
RE: Access Run-time
Hi Neal
Thank you for your question
Having researched the problem, it seems that you need to write error handling code in VBA when working with code in Access Runtime. As a consequence Microsoft do not recommend using macros in Access Runtime.
Ideally you should replace your macros with VBA modules
You might find the following link useful
http://msdn.microsoft.com/en-us/library/aa164462 (office.10).aspx
Regards
Stephen