Macros enabled on set times

Resolved · Low Priority · Version 2007

Wed 24 Mar 2010, 16:06 Delegate Shane said...

Shane has attended:
Access Introduction course
Access Intermediate course
Access Advanced course

Macros enabled on set times

How do we create macros enabling reports to be run on set times particularly weekly reports?

Thu 25 Mar 2010, 19:46 Trainer Simon said...

RE: Macros enabled on set times

Hi Shane,

Thank you for your question.

I am not aware of a way of achieving this in the front end. However I did find this link which may help.

http://www.eggheadcafe.com/software/aspnet/35869163/access-macro.aspx

Tomorrow I will speak to my colleague and see if he has any ideas apart from vba code.

I hope this helps.

Regards

Simon

Thu 1 Apr 2010: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Random sampling

Data is th key to a good database, therefore checking is essential.

A good way of checking data is by random sampling. You can do this in a query, by typing the follow:
1) In the Field box create a RandonID field eg. Randon Id: Rnd(fieldname])

2) sort the field
3)Right click and chage the properties for To value to be the number of randon records you want to see.

4) Change the set to Show row for Randon ID to be False, add all the other fields you want to see and the run the query.

View all Access hints and tips