Go Back   Access World Forums > Members List

 
D_C_W is on a distinguished road

D_C_W D_C_W is offline

Registered User

Visitor Messages

Showing Visitor Messages 1 to 1 of 1
  1. D_C_W
    05-09-2009 11:53 AM
    D_C_W
    Help needed with validation script.

    I have made a form and subform over a table named calendar. The table fields are:

    CalendarID AutoNumber
    Date Date/Time
    Time Date/Time
    Contact Text
    Event Type Text
    Place Text
    Date Alert Date/Time
    Event Due Past Due Yes/No

    I want to prohibit a Date and Time conflict (i.e.) Event1 dated 05-18-09 at 08:00AM and (new record) Event2 dated 05-18-09 at 08:00AM. It is important for a validation script to stop the action and have a message box to exist in vba in the Before_Update sub.

    Thanks D_C_W

Statistics

Total Posts
Visitor Messages
Total Thanks
General Information
  • Last Activity: 05-10-2009 04:13 PM
  • Join Date: 05-09-2009
  • Referrals: 0



All times are GMT -8. The time now is 09:10 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World