Results 1 to 10 of 10
  1. #1
    Join Date
    Jan 2006
    Posts
    7

    Unanswered: Parameter drop down list...

    I know there are guides but i have used them and still cant get it to work, so can someone please help me, i have created a category form, and a query, but when i create the code in the query it doesnt seem to work, can someone please either explain it to me, or see where i am going wrong

    http://s49.yousendit.com/d.aspx?id=2...I3G7EYV8SALCBA

  2. #2
    Join Date
    Jun 2003
    Location
    USA
    Posts
    1,032
    It looks to me like the combo box on your query-by-form form is giving the numeric category ID while tblBook and the query based upon it actually uses the longer category description.

    And here's something I put together that may give you some ideas about making time periods and other criteria dynamic.

    The free downloadable sample database at www.Bullschmidt.com/Access uses the query-by-form concept so that on the invoices dialog one can optionally choose a rep, a customer, and perhaps a date range, click on a button that says "Input," and then have the invoice form open up showing all the invoices that match the criteria.
    J. Paul Schmidt, Freelance Web and Database Developer
    www.Bullschmidt.com
    Access Database Sample, Web Database Sample, ASP Design Tips

  3. #3
    Join Date
    Jan 2006
    Posts
    7
    i havent got access at home but will try it at college thanx

  4. #4
    Join Date
    Jan 2006
    Posts
    7
    trying it at the moment but not sure exactly what i need to change

  5. #5
    Join Date
    Jun 2003
    Location
    USA
    Posts
    1,032
    I wrote:
    It looks to me like the combo box on your query-by-form form is giving the numeric category ID while tblBook and the query based upon it actually uses the longer category description.
    And this still does need to be corrected (as currently it's sort of like mixing apples and oranges)...
    J. Paul Schmidt, Freelance Web and Database Developer
    www.Bullschmidt.com
    Access Database Sample, Web Database Sample, ASP Design Tips

  6. #6
    Join Date
    Jan 2006
    Posts
    7
    ok thanx, how would i go about correcting this...?

  7. #7
    Join Date
    Jun 2003
    Location
    USA
    Posts
    1,032
    I'd suggest having tblBook store the category ID instead of the category name...
    J. Paul Schmidt, Freelance Web and Database Developer
    www.Bullschmidt.com
    Access Database Sample, Web Database Sample, ASP Design Tips

  8. #8
    Join Date
    Jan 2006
    Posts
    7
    think im just gunna leave it, and not do it, as cannot manage it, but many thanx for your help

  9. #9
    Join Date
    Jun 2003
    Location
    USA
    Posts
    1,032
    Well the other way to go would be to have the new form show the category names instead of the category ID's. At any rate the table and form should be in tandem both using category ID's or category names...
    J. Paul Schmidt, Freelance Web and Database Developer
    www.Bullschmidt.com
    Access Database Sample, Web Database Sample, ASP Design Tips

  10. #10
    Join Date
    Jan 2006
    Posts
    7
    id rather have the category names

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •