98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum 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
Resolved · 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
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Using the Quick Access Toolbar in Access 2010The Quick Access Toolbar is included in virtually every Office product, including Outlook 2010, Word 2010, Excel 2010, and PowerPoint 2010. |