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

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
access

ResolvedVersion 2003

Natalie has attended:
Excel Advanced course
Access Intermediate course

Access

What is a conditional macro?

RE: Access

Hi Natalie,

Thank you for your question.

A conditional macro runs a set of instructions when a certain condition is met.

E.g. If you had a set of sales figures, you could say that if the sales figure > 200, then show a Message box saying "Well Done". The condition being the field > 200 and the action being creating a message box. Then you can attach the macro to the Sales Value field and tell it to run when that field has been updated or run it on the current values in that field.

I hope this answers your question.

Regards

Simon

Access tip:

Hiding Multiple Table columns

If you want to hide non-adjacent Access table columns. In Datasheet view, open the table that contains the columns you want to hide.

On the Format menu, click Unhide Columns.
In the Unhide Columns dialog box, clear the check box next to the name of each column you want to hide.
Click Close.

This method makes having to use the Hide Columns command repeatedly unnecessary

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.