vba code validation rules

Forum home » Delegate support and help forum » Microsoft Access Training and help » Vba code for validation rules to prevent users from selecting th

Vba code for validation rules to prevent users from selecting th

resolvedResolved · Urgent Priority · Version 2007

Astley has attended:
Access Advanced course

Vba code for validation rules to prevent users from selecting th

Hi, I am developing an Access 2007 database and would like to write code for a validation for two combo boxes on a form. One combo box has a drop down list of starting times and the other combo box has a list of ending times. I entered a validation rule and text message on a form, but whenever I selct a time a pop up message keeps displaing and prevent the user from making a selection, so they have to close down the database and re-open it, as you can imagine this can be frustrating for the user to do. What I would like to do is prevent the user from selecting either an end time that is earlier than a start time, and a start time that is later than an end time. Is this possible to do? If so, how can this be done? If you have any examples that would be very helpful. Thanks for your solutions. I look forward to your response.


Astley

RE: vba code for validation rules to prevent users from selectin

Hi Astley

I am sorry that we have not been able to get back to you as soon as we would have liked. We will be in touch shortly to progress your question.

Thank you for your patience.

Kind regards,

Andrew


 

Access tip:

Using the Quick Access Toolbar in Access 2010

The Quick Access Toolbar is included in virtually every Office product, including Outlook 2010, Word 2010, Excel 2010, and PowerPoint 2010.

You will find the Quick Access Toolbar in the top-left side of the window. To begin, click the Customize button (it's the little black arrow at the end of the toolbar).

Simply click the commands you want to include.

Virtually any command can be added to the Quick Access Toolbar. Click the More Commands option and a new window will open from where you can browse the commands including those not on the ribbon.

View all Access hints and tips


Server loaded in 0.08 secs.