Results 1 to 2 of 2
  1. #1
    Join Date
    May 2006

    Red face Unanswered: 2 Access Questions

    Question 1:

    In the access 2000 version how do I hide the tool bar & menu bars on opening the database and then how do I unhide them when I need them?

    Question 2:

    Can I filter records based on a persons login name, if so what method would I use?

    Thank you

  2. #2
    Join Date
    Feb 2004
    Chicago, IL
    Answer 1:

    Go to Tools/Startup and change the check boxes to what you want. Be careful with the Use Special Keys. If you uncheck it then you will have to write some code to get back to menus. Otherwise uncheck any of the other ones and hold the shift key while you open the database and Access will skip any startup procedures (AutoExec macro, startup forms, disabling menus, etc)

    Answer 2:

    In order to filter on the Username, you will have to include the Username in all of your tables (or just the ones you want to filter by) and then use SQL to filter the results. Base each table on a query that has CurrentUser in the criteria for the Username field. That is one way to do it. There are certainly other ways.

Posting Permissions

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