Search results

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

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!

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

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

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

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:

Is it possible to limit a subform to 3 records?

I have a Form 01 that has staff names and the primary key StaffID. From this form, I want to open Form 02 to add a new record linked by the StaffID. How do I automatically populate the PK (StaffID) in Form 01 as the FK (StaffID) in Form 02?

I have a db tracking vacation times for staff. One of the fields tracks a members vacation start and end dates. I need a way to pull a report to see who is on vacation based on Date() (today). Is this possible? For example: A record for John Doe has him start vacation 08/19/2014 and end...

Field B is a combo with the options of : 100% Availability, 75% Availability, 50% Availability, 25% Availability, OR Not Available If I choose "Present" in Field A, I want the "Not Available" value to disappear as an option. Any ideas?

I need the following to display a zero if a null value is returned: SELECT tdsIndivData.dsReportID, Count(tdsIndivData.StaffID) AS CountOfStaffID FROM tdsReportData INNER JOIN tdsIndivData ON tdsReportData.dsReportID = tdsIndivData.dsReportID WHERE (((tdsIndivData.Availability)="75%...

I have a form used to track attendance of employees: I want to update a value in Field B to a default value if a specific criteria is selected in Field A. How? I cannot seem to find a answer... Specifically: If the combo box value "Not Present" is selected from Field A, I want to value in...

I cannot get this to work: DELETE tdsReportData.dsReportID, tdsReportData.dsReportDate, tdsIndivData.StaffID FROM tdsReportData LEFT JOIN tdsIndivData ON tdsReportData.dsReportID = tdsIndivData.dsReportID WHERE (((tdsIndivData.StaffID) Is Null)); Please help! I'm sure it's something fairly...

How to populate the parent form's PK to multiple records in a child subform set to a default view continuous form? In other words, how to auto populate the primary key to multiple records displayed the subform? HELP!

I have a form that supervisors use to input employee accountability for each day. Once supervisor completes the input, a command button is selected and records are appended to an archive table and then deleted from the "live" table. End of the month, reports pull from the archive table to...

Greetings everyone! Like many, I'm here for help. I've been tagged by my supervisors to create a database for our department. Along the way I've come to love Access and am very eager to become proficient. Looking forward to meeting some new friends! Watson