Recent content by WatsonDyar

Hi again Minty- Any idea why this isn't working? Same type of issue. sqlPresent = "SELECT mtAttendStatus.mbrProgramID, Count(mtAttendStatus.mbrAttendReportID) AS PresentCount " _ & "FROM mtAttendStatus " _ & "WHERE ((mtAttendStatus.Status)='Present') AND...

That did the trick. Thank you Minty! I was losing my mind on that one....

Hello All! Having problems with the following: strRole is declared and defined. Stepping through the code shows that the variable is working correctly. I just cannot get the following statement to work with the recordset. sqlCount = "SELECT mtProgram.mbrProgramID, mtProgram.Role...

Here's the situation: I have a field on a form that looks up "roster numbers" from another table that holds pre-populated numbers (A-01, A02...through A50; B01, B02, etc). I need to assign each student a number. How to I limit the query within the lookup field to ONLY display available...

CJ_London/linq- I apologize for the delayed response. Thank you both for the assistance. What I meant was preventing a user to enter data into a subform until data from the parent form was validated.

I'm sure this ain't a tough one....but I'm lost. I have a form with subforms. I don't want the subforms to index a new record until the parent for is validated. Thank you in advance!

Thank you! So simple....

I have the following function that validates on on form before update & unload: Public Function Valid() As Boolean On Error GoTo Err_Handler Dim strPrompt As String Dim strWhere As String If Me.Dirty Then If IsNull(Me.txtLastName) Then strPrompt = "Last name...

Mark- You're gonna want to strangle my neck: This entire time I was only missing an underscore: =Nz(DLookUp("StudentCount","lq_MRTT_StudentCount", "Class _ID = " & [Class_ID]),0) Thank you for the help- greatly appreciate it!!!

Thank you Mark....This didn't work either. I think I may have a solution though. I'll post it soon.

1. No, I just left the MRTT off in the first post so no issue there. 2. StudentCount is the field from lq_MRTT_StudentCount that is counting the number of students (Student_ID). NOW I've gotten it to stop prompting me for parameters but still getting the #Error on the report...

Well, first it is prompting me to enter parameters for StudentCount (which is what I have the count of Student_ID label as within the query)...the the #Error displays in the field. Thank you!

I have a report with continuous class records. I want it to list the number of students current registered for that class. The query lq_StudentCount is a totals query with the Class_ID (from the Class table) and Student_ID (from the Students table). The Class_ID is grouped, the Student_ID is...

Got it to work. Thank you Jiri!!!

Thank you Jiri. Question: If the path to the folder I want to delete is stored within a field associated with that record (in my case txtDocuments), how do use VBA to refer to it? Use the Dir function? Thanks again!