The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Access Run-time

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Access Run-time

Resolved · Medium Priority · Version 2003

ReplyMon 18 Aug 2008, 15:31Delegate Neal said...

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

For upcoming training course dates see: Pricing & availability

ReplyTue 19 Aug 2008, 13:01Trainer Stephen said...

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 articles

· MS Access can promote teamwork
· So You Want To Create Forms In Access 2007?
· Access Corruption Avoidance Tip #3: Stay Connected
· How To Understand Access As A Relational Database
· Up The Professionalism Of Access Files Thanks To Digital Signatures

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

Access tip:

Hide Access Tables

One method of stopping your Access tables appearing in Database window, is to rename the table(s) with the prefix usys.

This converts the table into a system object, which cannot be viewed in the Database window.

You can show system objects in the Database window by the following:

Step 1: On the Tools menu, click Options.
Step 2: Click the View tab.
Under Show, select the System Objects check box.
Click OK.

View all Access hints and tips

How do change if functions in relation to dates?

for example how do i highlight late payments in a spreadsheet using the 'IF' function.

» Forum post: Functions

Rate this page:

Currently 2.15/5
1
2
3
4
5

2.2/5 (213 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions