Search results

hello. Does anyone know what code would have been used to highlight the times when there are activities on the attached schedule? I can use the conditional formatting to highlight the start time. but if an event goes on longer than one timeslot I do not know how to extend it to represent a...

Hello I have a database on a shared network drive. If you try to open the db (when another user already has the db open) from the route "my computer" then selecting the drive then selecting the db the message "Microsoft Access can't find the database file 'M:\blah blah blah' Make sure you have...

Please Help! I am trying to set the on click properties of the button “Save & Close” so that one of two things happens. a) If all related records in the subform (Edit Record) have a date in the Date Completed field then a message box pops up. b) If all related records in the subform have not...

Hi I am trying to write some code for after update on a form. I have created a serparate query (Query2) which differs from the one that the form is based on (Query1) and I want to use this to create an if statement. I don't know how to write this in VBA. In simple terms it would read. If...

Hi I am creating a work request database, where people log jobs and members of our team are assigned to them and then fill in when they have completed the work. To fill in the date of completion, I have a form which pulls up the details of the work, then a sub form which displays a list of...