Join TSR now and get all your revision questions answeredSign up now

Double Booking codes Watch

    • Thread Starter
    Offline

    0
    ReputationRep:
    where do i put the following codes please tell me
    If (Combo1.Text = "Morning") And ((Weekday(Text3.Text) = 2) Or (Weekday(Text3.Text) = 4)) Then MsgBox ("Error! This slot is allocated to: Play Group")
    If (Combo1.Text = "Morning") And ((Weekday(Text3.Text) = 2) Or (Weekday(Text3.Text) = 4)) Then Text3.Text = ""

    If (Combo1.Text = "Evening") And (Weekday(Text3.Text) = 3) Then MsgBox ("Error! This slot is allocated to: Guides & Brownies")
    If (Combo1.Text = "Evening") And (Weekday(Text3.Text) = 3) Then Text3.Text = ""

    If (Combo1.Text = "Evening") And (Weekday(Text3.Text) = 5) Then MsgBox ("Error! This slot is allocated to: Clubs & Scouts")
    If (Combo1.Text = "Evening") And (Weekday(Text3.Text) = 5) Then Text3.Text = ""

    where do i put these
    thanks in advacne
    • TSR Group Staff
    Offline

    3
    ReputationRep:
    That's VB code, which should go in the appropriate event, I'm guessing a submit button. Just double click it in design view and it'll take you to the relevant part of the code.
 
 
 
Poll
Is GoT overrated?

The Student Room, Get Revising and Marked by Teachers are trading names of The Student Room Group Ltd.

Register Number: 04666380 (England and Wales), VAT No. 806 8067 22 Registered Office: International House, Queens Road, Brighton, BN1 3XE

Quick reply
Reputation gems: You get these gems as you gain rep from other members for making good contributions and giving helpful advice.