Search results

Reply Yes, you're correct. I created the report in design view and I am working on getting the code into the button. Thanks very much for your help. Hopefully I'll have it going in a little while.

Reply I tried to make it a report first, but it said I chose too many fields. So I made it a form and it took all of the fields. Is there any other way to get all of the fields into the report?

Button Please excuse my ignorance here. Does that go in the code for the button itself? Here is what the button has now. Private Sub printer_Click() On Error GoTo Err_printer_Click Dim stDocName As String Dim MyForm As Form stDocName = "PrintNCMR" Set MyForm =...

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

Thanks!!! Thanks everybody, I knew it would be something easy. I just couldn't figure it out.

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

I used this code I used this code and have not experienced any problems. I also couldn't tell you anything about this code except for it did not cause me any problems. Good luck

Not sure what's wrong The way I understand what was said was that I create a new query based off of the query that contains the average. Then I use the group by and sorting properties in the query. I still cannot get it to limit for each part number group. I'm not sure what I am doing wrong...

Thanks, I'll give it a try. Thanks for your help. I will give that a try.

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

Thank you Thanks for helping out those of us who are "database impared". That was too easy.

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

Thanks Thanks, I thought that was what I needed to do, but wanted to know before I spent the time. Thanks for the help.

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

OK, I understand that part. I now understand what you have done to populate the other fields. My problem now is that I want to have the part number be selected on the form using a dropdown (as it does in example) and populate the other text boxes (as it does in your example). The problem is...

Wher do I put it? Do I use the code builder or use an expression? Also, how do I know what the columns # is? Is the column number something in the text fields properties in the form? Thanks for your help!

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

thanks!!!! thanks for the help guys!!!