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 davsanto

  1. davsanto

    Filter report based on form

    GKProgrammer One more question if you please If I change the MULTI SELECT to simple for the property on the select category input of the form what do I need to change in the code to allow more than one category to be displayed in the report? Thanks das
  2. davsanto

    Filter report based on form

    Thanks Again GKProgrammer! I understand your method and it works great! das
  3. davsanto

    Filter report based on form

    GOT IT! Works great! YEP had the wrong info in one of the criteria field and the report had the filter on. One more item How do I display the selected product and then all the categories if no categories are select. in other words all categories are displayed by default for the selected...
  4. davsanto

    Filter report based on form

    GKProgrammer Thanks again! Crazy comma - yep it works but I don't think I am passing the selections from the form to the query. In other words when I access the report direcly I am asked for the product and category and receive a report as selected. When I try from the form the report is...
  5. davsanto

    Filter report based on form

    FancyPrairie Thanks FP You way almost works! The problem here is using the filter on the form. If I filter only one variable it works but when I put in two it does not work. das
  6. davsanto

    Filter report based on form

    thanks again gkprogrammer I get a compile error on the follow line: "argument not optional" DoCmd.OpenReport , "Test Report 2", acViewPreview thanks das
  7. davsanto

    Filter report based on form

    Thanks GKProgrammer Wow that is a realy simple and clean way of doing it. It works at least when I run the query. How do I open the report from the form that will display my selected criteria on the report. Thanks Again! David
  8. davsanto

    Filter report based on form

    I have a report based on a query. Part of the report consists of products and categories. I have a form that will allow the user to select a specific product and a specific category. This will produce a report that will show only the product and category selected. For example the user...
  9. davsanto

    MS ACCESS QUERY TO FIND LATEST RECORD VERSION

    Yes that works but I think I did not explain myself very well. The results I want to see is all versions of the records except the latest version of records that have the same RCD# - note this is not a unique #. Thanks
  10. davsanto

    MS ACCESS QUERY TO FIND LATEST RECORD VERSION

    I have a list of records such as: RCD# ID# NAME VERSION 1 1.1 XYZ 1 2 1.2 ABC 1 3 1.3 DEF 1 4 1.1 XYZ 2 Records 1 and 4 are similar except record 4 contains changes that are reflected in the second version. I want to keep the first version for record 1 for reference and historical...
See more

Part and Inventory Search

Back
Top