Search results

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!

How large (number of records) do you expect tblSample to have? I ask because the number of fields in this table and the "attachments" field are concerning. Have you put your db into place yet?

I need a way to delete a folder along with subfolders and files associated with a record via command on a form: The path is stored in a text field "txtDocuments". For example: "C:\Users\Watson\Desktop\FY15\1505\1505-010" So, I would want the code to pull the folder location from the...

Perfect. Thanks!

I have a subForm set to continuous forms. I need a field called txtStatusDetails required (cannot be null) if the field txtDutyStatus = "Not Available" Here's what I have so far:

This worked perfectly for me: Thank you EVERYONE!