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!

Search results for query: *

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

    TopValue Property in a Query Question...

    Hey there, any help would be appreciated. I have some queries that update different date fields. I have this one query that ultimately I would like the user to input the bottom number of records to have it update the date field. Basically say we have like 4000 employees and each of these...
  17. hathman23

    Query Search Criteria for Multiple Columns!!

    Hello there, I am very new to Access but hopefully you all can help me out. I have a pretty simple database to enter information from an application form. In the application form the person can select three different job positions they are interested in. I have put three fields into the table...
  18. hathman23

    E-mail notification when table has been updated

    Thanks alot for your response but I guess my question is directed directly at the data access page. When the user inputs the information into the data access page I would like the information to go into the table and also be notified that the table was updated or just have the information sent...
  19. hathman23

    E-mail notification when table has been updated

    Hello all, I am sort of new using Microsoft Access and Databases but know some various programming information. I currently have a data access page that goes into a table. I simply want an email sent to me when someone enters information into the data access page or updates the table whatever...

Part and Inventory Search

Back
Top