Recent content by tim1234

  1. T

    Button to update/save, select record and print

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

    Button to update/save, select record and print

    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?
  3. T

    Button to update/save, select record and print

    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 =...
  4. T

    Button to update/save, select record and print

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

    Problems with taking average of a calculated number

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

    Using Expressions in Reports

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

    Using Expressions in Reports

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

    Disable Mouse Wheel in Access 2002 (XP)

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

    Returning Select Records in Query

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

    Returning Select Records in Query

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

    Returning Select Records in Query

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

    Locating multiple entries in query

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

    Locating multiple entries in 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...
  14. T

    OK, I think my problem is in my tables

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

    OK, I think my problem is in my tables

    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...
Back
Top Bottom