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

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

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

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

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

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

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

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

Hello, I need to generate a report based on a form and sub-form. The main form lists company name, etc., and the sub-form lists specific contact information consecutively. Is there a way to have the report show only the last entry made on the sub-form for each company? Thanks very much for...

Hello, This is my last "omit comma" question I promise...but would anyone know how to omit the comma if the city field is blank, in the label wizard as it returns an =Trim expression. I tried adding the following but it did not work: =Trim([City] & ", " & [State] & " " & [Zip]) &...

Hello, I was trying to format addresses for a report, but am having difficulty on one part. I need to be able to omit the comma between "city" and "state" if there is no "city" listed as happens sometimes with the foreign addresses. I tried the following but it did not work...

Hello, I have been trying to adapt a form from the Northwind db (Customer Phone List) that enables you to pull up customer information and phone numbers via the command buttons on the bottom (a to z). I have it working except for one error message which I am lost on how to correct. If there...

Hello, I have a notes field on a report that only has information for certain records. Is there a way to hide the label "Notes" if the corresponding text box is empty or null. Thank you very much for your help, it is much appreciated.

Hello, I created a pop-up form linked to a main form using the main form's AID_# (primary key). I was wondering how and if I could fill the AID_# field on the pop-up form so that I don't mistakenly type the wrong number entering it manually. The AID_# on the pop-up form is the first field in...

Hello, Would there be a way to "select" a check box in a form (have the checkmark appear in the box) via the keyboard rather than using the mouse? Thank you very much for your help, it is much appreciated.

Hello, I used an expression in a query to join the first name and last name fields separated by a comma and then the title...as follows: Name: [First Name] & " " & [Last Name] & ", " & [Title] However, how do I get it to omit the comma if there is no title for a particular person. Thank you...

Would there be a solution to this...when I set up my form I made three address fields, Add 1, Add 2, Add 3, then City, etc., each being a separate field. If the address is long, I use all 3 fields. If a short address it may only use Field 1...then I tab to city, etc. When I produce labels, it...