Search results

Hello, I have a form that contains 2 multi select listboxes. The form opens a report filtered based on selections from the listboxes. I am trying to use a function by Duane Hookum that I found online but I am getting an error message: 2491: The action or method is invalid because the form or...

Hello, I have a combo box on my form that is populated based on the value of 2 other combo boxes on the form. It has 2 columns, the Key field which is set to 0" width, and the MachName field which is set to 1" width. My problem is that when the key field (column 1) is set to 0" width...

Hello, I have a query that obtains some of its criteria from a popup form. If the criteria fields on the form are left blank, all records are returned for that field. It worked fine until I added criteria for the date range: (((tblQDetail.QD_ProdDte) Between...

Hello, I need to capture the date that a calculated field in my query equals 100%. Then, once the field equals 100%, I want the results to show up in my query for 1 day after the date that the file reached 100%. This is my calculated filed: PercentCompIns...

Hello, I am trying to export data from a filtered Access form to Excel by clicking on a command button. I found a function written by Bob Larson to export data from a filtered Access form to Excel, but I am getting an error 438, "Object doesn't support this property or method." My form's name...

Hello, I am trying to multiply 152 by .94 in a calculated field in my query to get the total cost. The query returns $142.76 but the correct answer is $142.88. I have read that it is a rounding issue but I can't understand how to correct it. Any help would be appreciated. Thank you

Hello, I have the code below attached to 2 buttons on my databases Main Menu to disable/enable the bypass key. I also have a text box on the Main Menu named txtBypass that displays “True” or “False” depending on if the bypass is enabled or not. I recently converted this database from Access...

Hello, I have a form which includes fields for a Machine Name (cboMachID), Activity ID (cboActID) and Total Items Processed (TtlItems). I need to write a vba statement for the forms before update event that checks the following: If Activity ID = “P” and Machine ID is not equal to (“F-123-D” or...

I have a popup form that prompts for start and end dates before running a report. When the user enters the dates and clicks "OK" the report is displayed correctly. My problem is that once the user closes the report and runs the report again, the popup displayed has the same dates in the input...

I have created a search form which displays results in a continuous form format. I want users to be able to sort the results by multiple fields, remove the sort, then if desired, sort again on different fields. I have both text boxes and list boxes on the form. Can anyone give me an example...

I have created a search form based on code from Allen Browne (see attached) that works very well, however, I need to add a couple of list boxes to the form. I want the user to be able to select multiple values from the list. Can someone give me an example of adding 2 list boxes to the attached...

Hello, I am having a problem with a data entry form. The form is for entering data from employee production logs. In the main form I want to capture the employee name, date, work arrival time and work departure time. I then want to move to the subform to capture detail from the log. Each record...