Results 1 to 6 of 6

Want something besides switchboard or navigation form

This is a discussion on Want something besides switchboard or navigation form within the Microsoft Access forums, part of the Question Forums category; I am used to using buttons or the switchboard for access operations which seemed clunky. Now they have a navigation ...

  1. #1
    New Member
    Join Date
    Jun 2012
    Posts
    3

    Default Want something besides switchboard or navigation form

    I am used to using buttons or the switchboard for access operations which seemed clunky. Now they have a navigation form for reports. I am looking for something different that controls everything. I have seen screen shots for one at TheUAIC.com that seems fairly simple and has some nice features I like:
    It has everything for navigation controlled by one form.
    It can be used to open/execute everything like Reports, Forms, Queries, Macros, Code etc.
    Once a selection has been made it has an area that explains in greater detail of what the Report, Form, Query, Macro, Code etc. is about.
    Documentation can be easily accessed for the selection.
    Due dates can be also viewed and edited quickly for the selection.

    My question is has anybody used this before or know or other navigation systems for Access that may similar or better?

    I was directed to this site by another forum but the link they gave seemed more for permissions.

    Thanks for any assistance.
    James

  2. #2
    Board Regular alansidman's Avatar
    Join Date
    Feb 2007
    Location
    42.28188; -87.88432
    Posts
    2,414

    Default Re: Want something besides switchboard or navigation form

    cross posted at http://www.access-programmers.co.uk/...d.php?t=227488

    Did you try my suggestion at the above thread?

    Alan
    Alan Sidman
    Win 7--Office XP, 2007, 2010


  3. #3
    MrExcel MVP
    Moderator
    SydneyGeek's Avatar
    Join Date
    Aug 2003
    Location
    Sydney, Australia
    Posts
    12,116

    Default Re: Want something besides switchboard or navigation form

    Hi James,

    The UAIC form looks interesting and I like the idea of having a single search form for the database.

    The link on this forum is for permissions but it can also be used to launch forms, reports, queries etc. The permissions part is for restricting certain functionality (eg, admin changes to settings) to particular groups of people. You can also set forms to open read-only for people who can't be trusted with data (managers).

    Another advantage over switchboard layouts is that, because the main interface is a few listboxes, you don't need to create a new button and adjust your layout when you add a couple more reports. Just add a record to an admin table.

    They both have their good points. The permissions system will most likely require some customisation on your part but it's free. The other system is a commercial download.

    Denis
    Self-preservation: For when you've got yourself in a jam
    ------------------------------------------------------
    My site contains a number of Excel and Access Resources

  4. #4
    New Member
    Join Date
    Jun 2012
    Posts
    3

    Default Re: Want something besides switchboard or navigation form

    Sorry I have not responded sooner but working late these days.
    In reply to alansidman: I am trying as many different message boards as I can in order to get as many different responses I can. Thanks for the help.

    In reply to SydneyGeek: I took a quick look at it. I know some code but not a whole lot. I think I can see how to change it to load different objects like forms, reports etc. but I do like the UAIC if it involves just changing tables. The other items I really like about the UAIC is
    • only one form
    • quick access to documenation for the selection to keep track of changes. Also use documentation drop down for information for users.
    • due dates are viewed in in the drop down and can be edited quickly
    • an area below to show information to the user that is most important.
    • it has a unique identifying number for the selection
    • it also has an internal report number that I could use for the selection
    • a specific category can be subdivided in the list
    I will be trying more message boards to see if anyone has any other suggestions.
    Thanks for the help
    James

  5. #5
    MrExcel MVP
    Moderator
    Joe4's Avatar
    Join Date
    Aug 2002
    Posts
    25,972

    Default Re: Want something besides switchboard or navigation form

    In reply to alansidman: I am trying as many different message boards as I can in order to get as many different responses I can. Thanks for the help.
    I will be trying more message boards to see if anyone has any other suggestions.
    Please note our rules on cross-posting (rule #10 here: Forum Rules).

    So you can cross-post here, as long as you adhere to those guidelines.
    TIPS FOR FINDING EXCEL SOLUTIONS
    1. Use the built-in Help that comes with Excel/Access
    2. Use the Search functionality on this board
    3. A lot of VBA code can be acquired by using the Macro Recorder.

    "Give a man a fish, feed him for a day. Teach a man to fish, feed him for life!"

  6. #6
    New Member
    Join Date
    Jun 2012
    Posts
    3

    Default Re: Want something besides switchboard or navigation form

    Sorry about the cross-posting. I thought it meant only to posting again on the same board but in other sections.

    Here are my reponses from other boards:
    http://www.utteraccess.com/forum/Swi...-t1987704.html - It would be better to create your own table of Objects.
    http://www.access-programmers.co.uk/...d.php?t=227488 - Tutorial -- An Access menu / permissions system
    http://answers.microsoft.com/en-us/o...f-669643c4a219 - you can find a multitude of free examples online
    http://www.msfn.org/board/topic/1570...vigation-form/ - Can you provide a link so that we can see what you're talking about?

    Only one possible option listed above that requires me programming.
    James.
    Last edited by Joe4; Jun 16th, 2012 at 09:04 PM. Reason: remove extra url coding

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com