Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by hathman23

  1. hathman23

    Report Listing Output by Date (may be simple) Please Help...

    Hello there, I essentially have a daily production database. The employees will input thier daily production hours and their daily production numbers of items actually produced. The quieries and tables and such calculate items per hour and things like that. What I really need is a daily...
  2. hathman23

    Multiple Fields Displayed in One Field

    I guess I am completely retarted, I opened up the report and click build event. My fields were actually called category 1, category 2 and so on. So to me your description indicates that the only thing I had to change was the unbound text box where the results would go. I changed the unbound...
  3. hathman23

    Multiple Fields Displayed in One Field

    That sounds great, could you give me a little direction on how to do that, specifically the looping thing.
  4. hathman23

    Multiple Fields Displayed in One Field

    Hello all, hope you can help. I currently have a table that has several category checkmarks, category 1, category 2, category 3, etc. It makes it a pain when I want to display a report of individuals with categories displayed because all the categories are always displayed. I hope you all can...
  5. hathman23

    Pulling information from one table with criteria & create new record.

    Hello all. Here is my situation if you can help me. I currently have a table called employees and a table called surplusletter. I have created a query/form/code that does the following. Each employee has a certain score. The query when run asks for the number of bottom scores you want to update...
  6. hathman23

    Pulling information from one table with criteria & create new record.

    Hello all. Here is my situation if you can help me. I currently have a table called employees and a table called surplusletter. I have created a query/form/code that does the following. Each employee has a certain score. The query when run asks for the number of bottom scores you want to update...
  7. hathman23

    Pulling information from one table with criteria & create new record.

    Hello all. Here is my situation if you can help me. I currently have a table called employees and a table called surplusletter. I have created a query/form/code that does the following. Each employee has a certain score. The query when run asks for the number of bottom scores you want to update...
  8. hathman23

    TopValue Property in a Query Question...

    You are AWESOME it worked perfectly. Exactly what I wanted. Thank you so very very much.
  9. hathman23

    TopValue Property in a Query Question...

    I very much appreciate your patience, and obviously that worked more but this time I got a compile error: sub or function not defined. The private sub was highlighted yellow The Mid$(dbQueryDefs was highlighted blue
  10. hathman23

    TopValue Property in a Query Question...

    Private Sub Command0_Click() Dim db As DAO.database Set db = CurrentDb db.QueryDefs("surplusdate").SQL = "Select TOP " & _ InputBox("Enter # of letters to be sent this month: ", "Parameter Prompt") & _ Mid$(dbQueryDefs("surplusdate").SQL...
  11. hathman23

    TopValue Property in a Query Question...

    surplus letter is a table, the query runs fine I get the run error when I click on the button on the form? where was I supposed to put that code, I created a button on the form and on the onclick event for that button (in the form) I put that code in the code section.
  12. hathman23

    TopValue Property in a Query Question...

    Ok, I put the Vb code you posted on an onclick event on a control box on a form, is that where I am supposed to put it. Here is the SQL view coding: SELECT TOP 100 SurplusLetter.[Date Sent], Employee.[Total Score] FROM Employee INNER JOIN SurplusLetter ON Employee.SSN=SurplusLetter.SSN ORDER BY...
  13. hathman23

    TopValue Property in a Query Question...

    Thanks again, I think I got it in the right place and everything but when I ran it it gave me a compile error and said invalid outside procedure. The name of the stored query is "SurplusDate". Thanks for the help so far, you have been awesome.
  14. hathman23

    TopValue Property in a Query Question...

    not a problem, truthfully it is a very very simple query SELECT TOP 100 SurplusLetter.[Date Sent], Employee.[Total Score] FROM Employee INNER JOIN SurplusLetter ON Employee.SSN = SurplusLetter.SSN ORDER BY Employee.[Total Score] Like I said all I want it to do is ask how many of the bottom...
  15. hathman23

    TopValue Property in a Query Question...

    Thank you very much, but I am confused where to put this code and the address fields are not fields in this table or query, I just want to be able to indicate with individuals we sent letters to by saying I sent letters to the bottom 50 or what no. Thanks for the help so far. Jeremy
See more

Part and Inventory Search

Back
Top