Recent content by Kate123

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

Yes, that is what I meant in my email, when I open it through access it is fine. It is just that most people here navigate through "my computer" etc and are some are not too computer savy to remember that it is an access programme!

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

Thank you. I am having trouble putting that into code. The record source for the sub form is a query called "Edit Record". I wrote Dim LTotal As Long LTotal = DCount("Edit Record", "Date Completed", [Not IsDate([Date Completed])]) If LTotal > 0 Then Close If LTotal = 0 Then MsgBox...

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

That does not work. It does not recognise: If Query2!Expr1 > 0 Then

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

I do not understand how I can write VBA to count number of records that have a date filled in. nor how to compare that to the overall count. Sorry to be stupid!

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