Access Run-time

The UK's most regular instructor-led training courses.
Training information: 'ms access+course' · Microsoft access courses · Microsoft Access Training uk
See also · microsoft access training · access vba courses · access database course

Resolved · Medium Priority · Version 2003

Access Run-time

Neal has attended:
Access Advanced course

by - delegate Neal [4 posts] (2008 Aug 18 Mon, 15:31) Reply

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

Version	Date	Location	Places available	Book	Next place rate:
Access VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 4 Thu + 5 Fri	Southwark	7	book now	£345	£399
2003	2009 Jan 8 Thu + 9 Fri	Southwark	6	book now	£450	£485
2003	2009 Feb 5 Thu + 6 Fri	Southwark	8	book now	£275	£399
2003	2009 Mar 5 Thu + 6 Fri	Southwark	7	book now	£345	£399
2003	2009 Apr 8 Wed + 9 Thu	Southwark	8	book now	£275	£399
2003	2009 May 7 Thu + 8 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 12 Access VBA course dates. Bookings currently available until 5th November 2009.

RE: Access Run-time

by - trainer Stephen gold contributer [369 posts] (2008 Aug 19 Tue, 13:01) Reply

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

· Learn about Subqueries in Access Courses
· Why Do I Need To Use Access?
· Microsoft Access Cheat Sheet: Tips and Shortcuts
· 3 Reasons to Switch from Excel to MS Access - You'll be Glad You Did!
· MS Access Top Tips: Takeaways From Microsoft Access Advanced Training

Please browse our web site to find out more about
'ms access+course' and other Microsoft training courses.

Access tip:

Convert A Form Into A Report

If there is a form that you want to to save as a report:

1. Open that form in Design View
2. Select File and Save As
3. In the Save As Dialog box Select Report

The system creates a report based on the form.

View all Access hints and tips