Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

access

ResolvedVersion 2003

Steve has attended:
Access Intermediate course

Access 2003

What is a conditional macro

RE: Access 2003

Hi Steve,

Thank you for your question.

A Conditional Macro is a set of actions that will run if a particuar condition is met.

E.g. If the Qty ordered field is less than 5, then display an error message box saying the minimum order is 5 or more. You then attach the macro to the qty ordered field on a data entry form.

I hope this answers your question.

Regards

Simon

Access tip:

Related tables

When you have related tables such as Customers and their Orders, the Customer table is the Primary table.

Open the Customers table in datasheet view and go to the Home Tab and Records group. Click on the More option and choose Subdatasheet and then click on Subdatasheet again. Now choose the related table (Orders) and click ok.

Now you can click the + symbol by each company to show the related orders.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.