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

    Parameter Query With Combo Box Problem

    Hey PHV, It looks like I stand corrected. Your idea of using the query in the form seemed to work just fine. I'm still not sure why the query wasn't working as intended, but I can forget about that now and use your method. Thanks a lot for your help! Jamie
  2. jamieharrop

    Parameter Query With Combo Box Problem

    Surely that will just open the standard text box query though, rather than using the value in the combo as the selection? For what it's worth, I've just setup a new, very basic database to try and do this in a clean environment with no other forms, tables etc to get in the way, and I'm getting...
  3. jamieharrop

    Parameter Query With Combo Box Problem

    The simple answer to that is, I'm not sure how. My knowledge of Access is very basic. The tutorial I followed to do this seems to show exactly what I'm trying to achieve, but despite following every step perfectly, it isn't working. (I'm assuming there's some naming problem that's causing the...
  4. jamieharrop

    Parameter Query With Combo Box Problem

    Hello, I've been following the tutorial at http://www.fontstuff.com/access/acctut08.htm to create a parameter query that calls a form containing a combo box. However, when running the query, the form doesn't appear, and all I get is a normal text query box containing the criteria code. Here...
  5. jamieharrop

    Access Reports Help

    Thanks for the response, PHV. However, I'm still not sure what the solution is. I'm not seeing the month function anywhere, and I'm not sure what the one parameter needs to be to create the correct query. Hope that makes sense. Jamie
  6. jamieharrop

    Access Reports Help

    I have managed to find one way of doing it, but it's quite cumbersome. I've setup a query for each month of the year. By splitting the date of birth in to three fields, and then using the criteria "=11" (for November) in the November query, I've been able to get the results I want. However...
  7. jamieharrop

    Access Reports Help

    Morning all, I'm currently setting up a customer management database. I've setup a table with all the fields and I've setup a form to populate those fields. One of the table fields is "Date of Birth" I'm trying to produce a report that will display all the customers with upcoming birthdays...

Part and Inventory Search

Back
Top