Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2008
    Location
    Missouri
    Posts
    8

    Smile Unanswered: Menu, Switchboard, dasboard create

    I have a few individuals that have created seperate Access Bases for and now that data is collecting I have another utility I have put together that grabs data from these other databases and puts them together and reports, exports etc. I would like to make it simpler from as cross training standpoint and make a seperate set of menus that open these individual data bases so corrections can be made with out closing one, navigating to the other and so on. It seems that in the past I could create a button to run a macro that would run a command to open a seperate access data base. Whats was it, or is there a better way?

    Jim

  2. #2
    Join Date
    Nov 2008
    Location
    Missouri
    Posts
    8

    2003 to 2007 learning curve

    It was a Macro Action, in moving to a newer version of Access, I discovered there was a "Show All Actions" button up top. Why we would hide actions in the new version now baffles me, but there it was, "RunApp" and all I had to do was put in the path. I supose it's ok to answer your own question!


  3. #3
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    It is surely ok to do so

    Well done!
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  4. #4
    Join Date
    Sep 2006
    Posts
    265
    You could giving the appearance of different databases, having a consolidated database in the first place and customising the each user's front end. To the user the database is different when in essence its data source is common to all.

    Simon

Posting Permissions

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