Search results

Quick question how do you get the combo query to requery from the command button, I have the following code to make the subform requery Forms![FrmSearchWard]![FrmSearchWardSubform].Requery

Hi Shutzy, I think I know what the problem is!! The subform Requery works ok. When the command button is pressed the subform is then refreshed with the correct data apart from the student name field. The student name field is a combo box, sometimes it works ok and sometimes the student names...

Hi folk, I have a problem that is driving me mad!!! 1. I have a main form containing class list & date 2. The subform contains a list of students 3. The main form has 2 text boxes and a command button, the user selects class and enters the date, this information is then passed into the...

Hi Folks, quick question how do you make the navigation controls on the main form control the subform i.e. navigating through the records or creating a new record???

Yes – but I need to have at least 6 conditional formatting options and using conditional formatting function I can only have 3.

Hi Folks, I’m using Access 2007, I’m trying to change the colour of a field [Other] in a form to red if the field contains the following string ”Yes” I’m using the following code but it’s not working any help would be much appreciated. Private Sub Other_AfterUpdate() If Me.Other = "Yes"...

Massive THANK YOU, I will study the code really

Still no joy, the times are not the same, I have attached the database any help would be much appreciated, I'm losing the plot here?

Yes, but I would like to run a query to display the the old time format 00.00 next to the new format 00:00, so I can check the data i.e. so the query would look some like tthis Old Format New format 00.00 00:00 22.04...

I'm trying to run the syntax in a select query, RegTime:CDate("20.30") 20:30:00 but no joy?

My time field format is 20.31 would the following syntax work? cdate(left([Fieldname], 1,2 & ":" & Mid([Fieldname], 4, 2)?

Is CDate not for changing a field to a date field?

Hi Folks, need some help here, I am using Access 2007. How do you change the following format 20.30 to a time format like 20:30! If I try to change the format within the table design option Date/Time I end up losing some data i.e. all the times starting at 17:00 onward seems to be...

Hi Starbuck, Firstly let me thank you for your patients, I will try to be a better student! J I understand your comments regarding corrupting the database. What I’m trying to achieve is something similar to Database_mod3.mdb. Under the CarerAvailability_Label I would...

Hi StarGrabber, I have tried to modify the database but I have totally failed, nothing seems to work any moreL I have created a new form called FrmCarerNew The carer combo box when changed will change all the carer’s names to the same name. The client combo box will not retain or allow me...

Hi StarGrabber, Thank you; I like your new design of the database, however I quite like having the carer details at the top and the client details at the bottom. The reason for this, it’s a lot easy to work with the carer details at the top and the client details at the bottom. i.e. I can...

Hi StarGrabber, thank you again, I don’t understand the code 100% but I can follow it to some extent. I just have one small matter! The FrmRota works great but if I select a carer from the dropdown list, the form will display all their shifts/clients. So if the carer has worked for, let’s...

Just a thought!!! Would it be possible to remove the carer from the dropdown list from the FrmRota when they have been allocated a shift? And then have them remitted back on to the dropdown list the next day? This would minimise mistakes.

Hi StarGrabber, thanks you, your idea worked great, could you please help me with the following problem! If I allocate a shift to a carer i.e. Joe Smith, date 14/03/2013 1700 – 1800hrs – would it be possible to include some sort of validation to make sure that this carer is not already booked...

Hi StarGrabber, I need your help again, every time I open up the database I am presented with a message box asking me for the Formulare!FrmRota!CboCarerId Could you please stop this, I would like to open the frmRota and use the navigation menu to find the carer or add a new record. Thank...