Search results

Is there a way to validate data between concatenated fields? I'd like a concatenated date/time field to validate as ">=" another concatenated date/time field in an entry form.

I have a personnel table of employees. That table includes name, phone, email, etc. That table has two relationships with table "request_information." The name field in personnel is linked to both "assigned" and "requester." I'm attempting to make a query that pulls the name and contact...

I have this code working for Field1 (Last, First names): Dim strInput As String strInput = InputBox("Enter Last, First") DoCmd.OpenReport "FAX", acViewReport, , "Field1 = '" & strInput & "'" I need a second field "Report_Number_Subjects" filtered as well. This field is in a subreport of...

I have a button that opens a message box with an "on click" event: Dim strInput As String strInput = InputBox("Enter Report Number") DoCmd.OpenForm "Update_Form", , , "Report_Number = '" & strInput & "' The user inputs a report number and clicks okay to open "Update_Form" filtered by said...

I need a navigation subform to refresh when an update form is closed. The subform lists open projects and it does not update if a project is closed out from the update form unless F5 is keyed. The navigation form is "Nav_Form" and the subform is "Pending_Working." I've added...

I have three split datasheet forms in which users can double click a request number to open an update form (each split form is a filter for different tables). Each split form has a related update form. The source of the update form is a query. (Three split forms, three update forms, three update...

I request help in creating a macro that: Close a form opened as a dialog window. Open a subform/control in a navigation form. The navigation form is open behind the dialog window. Objects are named: NS_Request_Info (dialog window). New_Request_All is the subform/control I want to open after...

An update form opens with the attached query. The form opens with empty fields if report_number has a "true" research_request. I want this to happen, but I'm worried this will confuse users. Is there a way to stop the query from running if research_request is true?