Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

access runtime

ResolvedVersion 2003

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

Access tip:

Create calculated fields that work out your age

You can uset eh year function to work out the year from NOW function and then subtract it with your date of birth type field

Age=Year(Now( ))-Year([DoB])

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.