Recent content by napjones

Good morning, I have searched for this for about 2 days and couldnt find anything. I am trying to write a function for the double click event of about 15 labels on my form. What I want to do is when the user double clicks the label I want it to pass the labels name to the function so that it...

I have an attendance table that keeps track of absences and tardies. What I want to do is create a report that counts the number of absences and tardies within a specific date range. I can get it to total up the number of absences and tardies if I leave the date field out of the query, but...

It is working fine now, I don't know what happened. It was still doing it when I left last night, but when I came in this morning, it was working fine. Now I can't get this security wizard to work right.

I have a form that has scroll enabled, but when it loads no scroll bars are visible, I can use the scroll bars on the access window to scroll the form. When I click maximize, the scroll bars appears, when I shrink it again they go away. When I click the design button, and then go back to the...

I have written the code for an SQL statement to count the number of active employees in a table, I now need this information stored in a variable so I can then put it in a label for a report like form. I have no idea how to do this please help

I took out the where, but it seems to still be giving me problems with the "AND" It works, if I take out the second parameter.

I keep getting this error "Syntax error (missing operator) in query expression 'WHERE [Section] = Administration AND [Sub_Section] = None;" DoCmd.OpenForm "Attendance", acNormal, "", "WHERE [Section] = " & strSection & " AND [Sub_Section] = " & strSubsection & ";", acEdit, acNormal The code...