Search results

I'm storing in Date/Time. I'd just like users to type the data as MM/DD/YYYY hh:nn.

What would removing the format achieve? I understand the concept that Access saves dates & times as integers. I just want to restrict users into entering the date & time in that format. Should I just do that with an input mask?

If I wanted to make a custom date & time field that had a short date + short time, would I format it as mm/dd/yyyy;hh:mm?

All of the fields are saved/stored as Date/Time.

To ease data entry, I have times and dates entered in separate fields. For example, I have received_date & received_time(24 hour) concatenated into received. I'd like to validate the concatenated field received against another concatenated date/time field.

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'm looking at the relationship now. I do not have two personnel tables; one table is showing both relationships. Should I remove a relationship and add a second table and link it that way? When doing so, create the relationship with the primary key and not the name?

It is, but no user is going to know what the primary key is. There are hundreds of employees in the table.

I do have an ID field, but it's just a random number and not something people would know to query by.

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 spoke too soon. It is still doing it, it only seemed to not because I was using a test record in which I was both the requester and assigned person. Is there a way to force access to display the contact information based on "Assigned" instead of "requester"? I don't even have the requester...

Got it, thanks! For some reason the queries I was writing were not working properly. I have two fields linked to the same field in a table (a table of employees links to the requester and assigned field). Originally the queries would open contact information for the requester, not the assigned...

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

The subform does not refresh. The subform should refresh and stop displaying projects that are no longer open. The record source for the subform is a query named "open." This query filters out projects that have a "null" completed date.

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

The one last item of cleanup I cannot figure out is refreshing the list of open reports after the update form is closed. I tried adding Forms!Nav_Form!Pending_Working.Requery to the on close event of the form, but it doesn't requery the form. Do you happen to know my latest VBA mistake?

Yes, and that's what did it. Seriously, thank you so much. I've wanted to try to do this for months and your help made it totally painless. I really appreciate it!

I added this code to a new button on click event: Dim strInput As String strInput = InputBox("Report_Number") DoCmd.OpenForm "Update_Form", , , "UFReportNumber = '" & strInput & "'" When I click the button I get this prompt capture.png (which is what I want). After entering a valid report number...

Would I put that code into a box? Basically want I want to do is use that same update form, but instead of finding a value from the box that is double clicked the user types the value in. Right now that is done from the query "update_request_bynumber" and the form "Update Request." I want to...