Search results

  1. S

    Pop up prompt to enter data

    I've got a yes/no field called 'SchoolPickup' whereby the user enters 'yes' or 'no' depending on whether a customer has decided to pick their items up from school or not. The problem is, I would rather a pop up prompt asking yes or no was displayed once id entered the name of the school in the...
  2. S

    Refer to Parent form

    what i would like to do is set a checkbox on my parent form (Called IAG_Calls) to 'True' if the 'InterviewTime' Field on my subform (Called IAG_Interview_Date) is updated (in the after update event) I cant seem to remember what the code is for this. something like this for the after update but...
  3. S

    Basic Booking Calendar

    In the image below i have a form for setting up peoples assesments in access 2003, that has the "InterviewDate" & "InterviewTime". Interview Date is just a default value of the previous entry. "InterviewTime" is a combo box that displays all the times from a lookup table. What ive been trying...
  4. S

    Displaying available dates/times

    I have a table that shows dates & times for interviews, and have just created a form for it as well. What i want to do is, when it comes to entering date & time for the interview is have a combo box or something similar pop up to list all the available times on the date specified in the date...
  5. S

    Updating fields in subform with previous data

    I want my date & time fields in my subform to automatically input values after i click a check box on my main form. The values i want it to input would be the data from the date & time fields in the previous record. Is there an AfterUpdate event i can use on the "Called Back?" check box that...
  6. S

    Blocking duplicate Booking Dates

    I have set up a form which lists the shedule of clients to be telephoned. Once they have been phoned, (after learning whether they are eligable) i then book them in for a 1 to 1 interview in the subform. The subform already copys all of the details (ie name, telephone number) from the main...
  7. S

    convert Date to Day

    I have a table with a 'Date' field & 'Day' field. The 'Date' field will always be the current date so the default value is Date(), but i have spent all morning trying to figure how to get the current day displayed in the 'Day' field. In access 2003 is there a similar function like Date() that...
Back
Top Bottom