Conditional macros

Resolved · Low Priority · Version 2007

Wed 23 Dec 2009, 15:48 Delegate Peter said...

Peter has attended:
Excel VBA Advanced course
Access Advanced course
Access VBA course
Access Advanced course

Conditional macros

why didnt teh conditional macro work in the exercise was ist something to do with the SetValue action being hidden?

Tue 29 Dec 2009, 07:47 Trainer Richard said...

RE: conditional macros

Hello Peter,

Thank you for your question regarding conditional macros.

We are running a skeleton staff over the festive period, so we will do our best to answer your question shortly.

Regards,

Richard
Microsoft Office Specialist Trainer

Fri 1 Jan 2010, 11:27 Trainer Simon said...

RE: conditional macros

Hi Peter,

Happy new year.

Please find attached the Access database with the conditional macro we discussed at the end of the course.

I have attached the macro to the On Current event of the form and the After Update event of the Discontinued checkbox.

When you create a new macro you have to click the Conditions and Show All Actions buttons to ensure SetValue is available.

Regards

Simon

Attached files...

Sales.mdb

Training courses

	98.7 % recommend us
	More live stats...

Training information:

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