Quick Links ▼

Bookmark page

Printable version

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

Forum home » Delegate support and help forum » Microsoft Access Training and help » Access

	98.1 % recommend us
	More live stats...

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

Training information:

Access

Resolved · Medium Priority · Version 2003

Reply Fri 21 Nov 2008, 15:00Delegate Andy said...

Andy has attended:
Access Advanced course

Access

Can I create a macro that updates multiple querys at the same time

For upcoming training course dates see: Pricing & availability

Reply Fri 21 Nov 2008, 16:44Trainer Carlos said...

RE: Access

Hi Andy

You can use the Open Query command in a macro to open a Query. Soyou can open multiple qeries this way.

If you mean that you want to change the criteria values in a qury every time you run it then you need to use Parameter Queries.

In the relevant query you replace the criteria value with a statement enclosed in square brackets. eg:

Replace Criteria

= 12/02/2008

With Statement

= [Please Enter Search date]

When you run the query you always get asked to enter a new search date.

Hope this helps

Carlos

Fri 28 Nov 2008: Automatically marked as resolved.

Access articles

· Take an Access Course to Learn About Relational Databases
· Insert A Real-Time Clock In An Access Form
· Microsoft Access Courses
· Practice Microsoft Access Database Decorum To Reap The Rewards
· How Does The Startup Work When Access 2010 Launches The Northwind Database

Please browse our web site to find out more about
microsoft+access+training 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