Search results

Hello, I have created a Find Dialog Box that shows a list of Work Order numbers and when you enter a different WO number, it should take you to that record on the form. Sometimes it gives an error Record Not in List, even though it is. In that case, if I select any other record in the list it...

Thank you very much for your help. I will definitely look into this article. Best regards, Lily

Hello, We have a table that lists main components by part number, tblMainComponents. In a separate table we have parts required to repair the component, tblParts. We have a query that returns the parts needed for repair based on major component selected. Is there a way to create a query...

Thanks again to you both for your help. It is greatly appreciated. I ended up putting this in the After Update event for field Work_OrderSub: Private Sub Work_OrderSub_AfterUpdate() Dim s As String s = Me.Work_OrderMain & "" Me.Work_OrderMain = Left([Work_OrderSub], 7) End Sub It is...

Thank you very much for your reply. May I check with you where to put that expression? Would it be correct to put it in the AfterUpdate of the work order sub field? Thanks again!

Hello, I wanted to ask if it is possible to copy data from one field on a form to another field on the same form, and then modify the data automatically so users do not have to enter the information. Our parts that are ordered are copied from reservations placed in SAP. We copy the parts...

Thanks very much for your help. I will give it a try.

Hello, I have a question on number of records displaying in datasheet view on a form. Is there a way to limit the number of records showing on open. I have a command button on a Navigation form that opens a frmEnterPartsOrder using a Macro. I have set the Macro to OpenForm, View Datasheet...

Thank you very much for your reply. It worked great! I would not have thought of that solution, but now that you've explained it it makes perfect sense. Best regards, Lisa

Hello, I would like to create a query to show only the Work Orders that all parts ordered have been received. For the Work Order, each part ordered has a "complete" yes/no checkbox. If I use that field in the criteria of the query, it does return only parts that are "complete." However, it...

Thank you for your reply, it is greatly appreciated. Makes perfect sense about the query, I hadn't thought of that. Best regards, Lily

Hello, I wanted to ask for advice on the database I set up to track parts for an Overhaul Shop that are sent out for Vendor Services. I created two tables: tblVendor and tblVendorServiceRequests From those two tables I created multiple queries and forms based on what criteria I need to view...

Thank you for your reply. I will try to post a copy. Best regards, Lily

Hello, I have created a report that is set to calculate the difference between parts ordered and parts received for various Work Orders and then list a sub total for each part number that has an outstanding balance due. All "Qty_Ord" fields have numbers, but "Qty_Rec" fields are many times...

Rich, Thank you!! It works beautifully. I did not realize and had not changed the two text boxes so that they were named "txtJobDate" and "txtWeekEnding". Did as you suggested, renamed them both, and it worked like a charm. Thanks a million. Best regards, Lily

Rich, Thanks very much for your help. I did put this into my After Update event of the job date text box, however, if I go to my form and type in a date it returns a "compile error, syntax error" message. My first field is Job Date and second field is W/E. I typed in Me.txtWeekEnding =...

Hello, Would appreciate any advice on a date function question. Using Access 97, I need to enter timeslips, beginning with job date (could be any day of the week). Week runs Sunday to Saturday. Is there a way to have Access auto-fill the field week ending based on the date I enter under job...

Hello everyone. Would there be a reason why my Mail Merge to Word loses the sort order that I have specified in the query it is based on? I am using Access '97 and use Tools, "Merge it with Word". It brings the data in fine, but loses the sort order if I have it set to sort by "Company Name"...

Hello, I created a "find record" command button using the Wizard and set it to put focus on a particular field that I need to search. Was wondering how to get the message box to close without having to click the "X" in the upper right or hitting the escape key, but to simply get it to close...

Hello, Was wondering if it is possible to move from a field in a subform...to the same field of the subform in the next record? I tried DoCmd.GoToRecord , , acNext which takes me to the next "new" record of the same subform. But actually need to move to the same field of the subform on the...