Search results

Hi, I have a database that works but I want to make it easier to use. Right now the user must enter their information into the form, click save, click print, (a different form based on a query opens), enter the form # to print and click OK. The first form is to make data entry easier and the...

I have a report based on a query and it calculates the average monthly supplier rating based on certain criteria such as quality, on time delivery etc. The problem that I am having is that I want to be able to take a monthly average rating of the individual suppliers ratings. I can get it to...

Hello, I am trying to use some conditional expressions in a report. I am trying to "count" the "no" responses for things like "On Time Delivery" so that I can compare that to the # of shipments and determine an "Accuracy %". I have attached a .jpg that shows the fields from the query and what I...

Hello, I am sure this is quite simple, however I cannot figure it out. I have a query that shows tblPartNumber and tblAverage. The average is calculated in the query by taking the total minutes to assemble the parts, divided by the number of parts completed. What I am trying to do is run a query...

Hello, I have searched the forums and found plenty of information about eliminating duplicate values. What I would like to be able to do is run a query and have it show me only the records that have the field "serial number" that contain the same number. That is, I want to be able to query and...

Hello, I find myself trying to create a new database after a few years of not working with access. What I want to be able to do is take information from table tblPartInformation, and have it populate text fields on a form that will store the information in a table or query called...

I know there are many different ways to autopopulate fields on a form. What I am trying to do is have one form that captures part # and 10 individual dimensions to be checked. The second form I have, I want to be able to select the part # in a dropdown (that shows me the part # of all records...

I have a database that keeps track of inspection records. What I want to be able to do is open the form Inspection, and select a part # in a dropdown. When I do that I want it to fill in all of the critical item/dimension boxes on that same form for that part number that I selected above. I...

I have a query that I want to show only records that do not have a value in the DateClosed field. I'm not sure which expression I need to use. Any help is greatly appreciated.

I have a form that I want to make all fields required so that the user cannot leave that form until all fields are filled out. I have the Required property in the table set to yes, and this works fine if I go to the form from the database window. However, If I go to the form from the main...

I have a database that tracks customer survey responses. All questions are rated on a 1 (worst) to 5 (best) scale. The problem that I have is that my report keeps the neutral (3) responses and uses them to perform it's calculations. For example: If I have 25 returned surveys each having...

I have two tables that I need to join in a query. The join I have now duplicates the info for lot #. The tables are as follows; TipBreakage - Lot#(Primary Key), DateReceived, Part# and Process Information - Lot #, TipBlank#, BulkPart # (Primary Keys), Quantity Received Engraving. All I want...

I keep seeing people saying that in Access XP there is a way to turn off the mouse wheel. How is that done? I see the new option for "On Mouse Wheel", but what code or macro will disable it? Any help would be greatly appreciated.

In my forms I have dropdowns that when you use the mouse wheel to try and scroll down, it changes what record you are viewing. The "Cycle" propoerty worked for the "Tab" key, but what stops the mouse wheel from changing records.