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 Rhinorhino 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 shards

  1. shards

    Limit records based on login

    Thanks to you both. However, I'm looking for information on filtering down to the supervisor only being able to view records of those who report to him. I don't believe that setting something up only on the access level will accomplish what I need to do. ?
  2. shards

    Limit records based on login

    I am creating an HR (human resources) database that will be used by both the HR department and all supervisors. HR wants to limit what supervisors can see—they want them to see, add performance evaluations, do consultations, etc. only for those employees who report to them. BUT…all of HR...
  3. shards

    show all records if nothing selected on form

    Thanks to you both. This is good stuff!!
  4. shards

    show all records if nothing selected on form

    FABULOUS. I was having a difficult time with the quotation placement. THANKS!!!
  5. shards

    show all records if nothing selected on form

    I answered my own question on the last item above. However, I am a bit lost on what changes when i want to reference text instead of a number. Title is text...I need to filter on that as well.
  6. shards

    show all records if nothing selected on form

    Thanks...very helpful. I assume this all goes on the OnClick control on the form, correct?
  7. shards

    show all records if nothing selected on form

    I have a pop up form (fp_training_rpt_select) where the users have options to input data they want to print a report based upon (unbound, form selection fields are: employee, year_start, year_end, title). Ultimately, If the user selects nothing, then I want all records to show on the report...
  8. shards

    Make control on report visible depending on where print cmd is called

    Remou - you are fabulous! That worked. Thanks a bunch.
  9. shards

    Make control on report visible depending on where print cmd is called

    Thanks, Remou and dhookom. I've tried the following code in both the On Load and On Format events in the report and get a compile error that the sub or function is not defined when I attempt to print the report form the form. The report will still open with no error if the report is opened...
  10. shards

    Make control on report visible depending on where print cmd is called

    I have a report for incidents and accidents that, depending on where the report is generated from, a drug_test control needs to be visible or not. If the report is generated from the cmdPrintReport button on the form f_safety, then I want the drug_test control to be visible. If it is printed...
See more

Part and Inventory Search

Back
Top