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 VBA Training and help » Microsoft Access 2003 VBA

	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:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

Microsoft Access 2003 VBA

Resolved · High Priority · Version 2003

ReplyFri 8 Jan 2010, 13:47Delegate Mike said...

Microsoft Access 2003 VBA

how can I use VBA to create separate Outlook messages from a range of records in a table?

For upcoming training course dates see: Pricing & availability

ReplyMon 11 Jan 2010, 14:47Trainer Stephen said...

RE: Microsoft Access 2003 VBA

Hi Mike

Thanks for your question

As promised I will adapt and upload the required code within the next few days

Hope all is well and that you are encountering few if any problems

Regards

Stephen

Mon 18 Jan 2010: Automatically marked as resolved.

Access articles

· Don't Do It By The Book, Access Your Important Contacts In An Easy To Use Database
· Discover The Easy Way To Create And Modify A Table In Access 2010
· Want To Get Started With Macros In Microsoft Access?
· How to Find a Third-Party Venue for Microsoft Access Training
· When To Use Access, When To Use Excel

Please browse our web site to find out more about
access/courses and other Microsoft training courses.

Access tip:

Closing form after a certain time period

To make a form close automatically after a certain time period, you need to assign the close function to a macro.

Save the macro and ope up the form in design view. open the Properties sheet.

In the TimerInterval property enter the length of time you want the form open for. This should be in milliseconds, so for instance if you want the form open for 5 seconds enter 5000, for an minute enter 60000.

You now need to attach your macro (to execute the Close action) to the OnTimer event property of the form.

View all Access hints and tips

Hello
I wanted to find out how to print a report by the task finish date. The idea being that I could print a report for "all tasks with a finish date of next week" - and then I would spend the week beforehand following up with everyone and ma..

» Forum post: Print report by finish date

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