Search results

I'm sorry, but I'm still a little new to this...where exactly am I putting this code?? I'm not sure how to get it to work with the table instead of the form. Thanks for your help.

Ok, I have been running myself in circles trying to figure this out, and am hoping there is a not-too-complicated answer. (I'm not exactly an Access guru yet!) Here is what I would like to happen: When the database is started, or the switchboard opens, an automatic check runs that checks a...

Sorry, I have no idea...I'd put that out as a new post! I actually just realized that this still won't totally work...the only way to run the check is if I flip through every record. I need it to run the check on all records automatically, pretty much when the database opens. I think I need...

Yes that worked! Thanks so much Topher!

Thanks for your help! It sort of worked...but not completely. I put this code in the AfterUpdate of the date field and OnActivate for the form: If dteAvailable <= Date Then ctrStaffStatus.Value = "Available" Essentially, when the form opens, I want it to check the date in date field (which...

I am trying to get a date to change the value in a combo box, and am having some trouble. Essentially, if the date entered in the field is equal to the current date, I want the combo box to display 'Available'. I've tried a bunch of different ways, and can't get it to work everytime. Any...