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

    Want value of ALL for drop down in form

    The location is the Nursestation and the class is the AHFS classification. I do not have the date range built - I am just using transaction date right now.
  2. joylene6

    Want value of ALL for drop down in form

    Here is the SQL for my query SELECT TOP 100 PDM.LABEL_NAME AS [Generic Name], PDM.BRAND_NAME AS [Brand Name], Nz([THERA_CODE_FMT],"92:00.00") AS [AHFS Classification], Nz([THERA_DESC],"MISCELLANEOUS THERAPEUTIC AGENTS\1") AS [Therapeutic Category], PDM.ROUTE, PHM_CURES.TRANS_DATE...
  3. joylene6

    Want value of ALL for drop down in form

    They put a date range in and click a "RUN REPORT" button. A report would then appear with the drug class information for the locations they picked from the drop down.
  4. joylene6

    Want value of ALL for drop down in form

    Thank you for responding. I want users to be able to select one or all drug classes and, I want them to pick one or all locations. There are hundreds of drug classes, so I put a drop down in the form to limit to the ones that are relevant for the report's use.
  5. joylene6

    unsafe expressions in access

    To prevent this from happening again - Goto Tools, Macro ,Security and set the security level to Low
  6. joylene6

    Want value of ALL for drop down in form

    I am building a form to look for classes of drugs in a query. I have 2 drop downs. I have manually added the classes to one dropdown. I have manually added locations to the other. I have added a option of ALL in both dropdowns. I think the easiest way would be to write a command in the query...

Part and Inventory Search

Back
Top