Search results for query: *

I am working on coding an update query in a form that will update a table which tracks our raw material receiving and issue. Can someone look over this newby's code and point me in the right direction? I have a form [frmMaterialIssue] with two subforms. [subform1] shows material available after...

Actually here is what I ended up with. It works fine for this application and I have added matching up [Location] with [Inspection Type] in the main form. Thanks for your input and I will try it out as soon as I can. Always looking for different ways to accomplish these tasks...

I have set up some code in the "on click" sub for saving a record on form [frmInspection]. This form has a subform [frmFAInvUpdate] which is linked to the main form control [WorkOrder]. When a record is entered the subform shows all records in tblFAInventory which have the same work order#. The...

I have not had any success assembling the right queries to show the data I need for this report. Can you help me format a query or set of queries that will assemble the data in the format I need for a report like this. The information I am using is detailed below. Table: tblNCMRDATA Fields...

I tried that: Between [Start Date] And [End Date] and I still get the following error: "The Microsoft Jet database engine does not recognize '[Start Date]' as a valid field name or expression." Am I using the wrong expression?

I have built a report on a summary query built on a crosstab query to get the information formatted as I need. The report is exactly the way I want it. However I can't seem to find the way to apply a date filter so that I can input the date range to see only the records from that date range in...

Just write a macro and attach it to the command button.