Conditional macros

The UK's most regular instructor-led training courses.
Training information: access course · Access training · Microsoft Access Training
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version 2007

5 posts

ReplyWed 23 Dec 2009, 15:48Delegate 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?

Version	Date	Location	Places available	Book	Next place rate (£)
Access Advanced 1 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2003	Fri 19 Mar 2010	Bloomsbury	4		£235	£240
2007	Wed 24 Mar 2010	Bloomsbury	5		£240	£245
2003	Tue 6 Apr 2010	Southwark	9		£203	£208
2007	Thu 13 May 2010	Bloomsbury	7		£188	£193
2003	Tue 18 May 2010	Bloomsbury	9		£182	£187
2003	Fri 2 Jul 2010	Bloomsbury	7		£85	£90
Full Schedule: See all 11 Access Advanced course dates. Bookings currently available until 14th December 2010.

834 posts

ReplyTue 29 Dec 2009, 07:47Trainer 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

648 posts

ReplyFri 1 Jan 2010, 11:27Trainer 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

· Bring Access Up To Speed
· Learn about Subqueries in Access Courses
· Quick Microsoft Access Course: Creating an Inventory Control Database in 8 Simple Steps
· Making The Transition To Access - Why You Might Need It
· Use Microsoft Access to manage your work/life balance

Please browse our web site to find out more about
access course and other Microsoft training courses.

Access tip:

Combo box for finding records

You can use a combo box in a form to look up a record. If you place the comb box in the Form header, by then selcting they a field type from the drop down loist, you will see the record for it

View all Access hints and tips