Search results

Great, thanks thats exactly what I needed. A prompt will help my users remember to note this on their fax orders.

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...

it only seems to work if i remove the Me.Refresh for the onchange event for interviewtime. but i need this to remove the times already taken, otherwise the form has to be closed, then reopened for used times to dissapear. Is there anything i could use instead?

Here we go SELECT IAG_Times.[Time ID], IAG_Times.Times FROM IAG_Times WHERE (((IAG_Times.[Time ID]) Not In (SELECT IAG_Interview_Date.InterviewTime FROM IAG_Interview_Date WHERE [InterviewDate] = Forms![IAG_Bookings_Not_Called_Yet]![IAG_Interview_Date]![InterviewDate]))) ORDER BY IAG_Times.Times;

Ive spent the week trying to add finishing touches to the form, but for some reason the "InterviewTime" field has stopped showing any times at all now (only after i enter a date) which is pretty much going to force me to start again from scratch. Ive checked all the coding relating to the times...

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...

Yes, its working perfectly. I just need the list of times to refresh when i move to the next record in the main form - Just so that the list of times refreshes to reflect the times unavailable. Once i selet a new record in the main form id like to use similar to this code...

iagdate is actually on the subform too. if it asks me to enter a parameter, if i enter something like 10:00 for example, i am still then able to choose from the available times.

sry not replied due to time off work. Ok managed to get the standaloe form working using JANR's example, Not In (SELECT tblBooking.IAGTime FROM tblBooking WHERE [IAGDate] = [Forms]![frmBooking]![IAGDate]) Now what do i do if [frmBooking] was a subform in [IAG_Call_List]? As for some...

Yes, ive set up the combo box to use the times listed in a seperate table simply called "Assesment_Times_List", which records the data to the "Assesment Time" field in the table "Learner_Assesments" By record source, I can find "Row Source" for the combo box, but no "record source".

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...

That never occured to me tbh, i also found out how to stop double bookings. Now at the moment it works but would require the user to keep trying different times until they find one that works. I have the default value show the last time inputted so at least it reduces the problem for now.

I managed to get the table set up with a field called 'times' listing all the times we schedule interviews. But thats about all i could manage since i havent used access in over a year, i can only remember a very little. ps. how do you go about setting the row source as code since it only...

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...

Hi, i replaced the dlookup but seems to bring up '#error'. Perhaps i should mentioned that it is a date/time field with an input mask 00:00 & validation rule to allow only times between 09:30 & 15:00. ps also usingd access 2003

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...

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...

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...