Results 1 to 2 of 2
  1. #1
    nkuebelbeck is offline Advanced Beginner
    Windows 7 Access 97
    Join Date
    Mar 2010
    Posts
    91

    switchboard like


    Hello all you access gurus!

    I am created a form which I will populate all my reports with buttons. Is there a way to programmaticly grab all reports and make buttons and labels for them. similar to the access switchboard manager? I'd use that but I plan on having way over 8.

    Thanks in advance!

    EDIT - I am using ACCESS 2007
    Last edited by nkuebelbeck; 06-23-2011 at 02:35 PM. Reason: more information

  2. #2
    pkstormy's Avatar
    pkstormy is offline Access/SQL Server Expert
    Windows XP Access 2003
    Join Date
    Mar 2010
    Location
    Madison
    Posts
    682
    You can make a listbox and use this as the rowsource (or use it in code somewhere):

    SELECT MSysObjects.Name AS [Query Name], MSysObjects.Type, MSysObjects.DateCreate, MSysObjects.DateUpdate FROM MSysObjects WHERE (((MSysObjects.Name) Not Like 'MSys*')) ORDER BY MSysObjects.Name, MSysObjects.Type;

    Add in other criteria to filter it further to show just your report names (ie. where Name is like "Rpt" & *, etc....)

    Then use the OnClick event of the listbox to open the report or whatever else you want to do with the records retrieved.

    The switchboard is a horrible feature!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Switchboard problem!
    By Suzan in forum Programming
    Replies: 1
    Last Post: 05-19-2011, 12:51 PM
  2. Switchboard help? Please
    By MrT1993 in forum Access
    Replies: 13
    Last Post: 02-13-2011, 01:15 PM
  3. Switchboard
    By mwabbe in forum Access
    Replies: 4
    Last Post: 08-26-2010, 07:17 AM
  4. Switchboard at startup
    By jamie c in forum Access
    Replies: 10
    Last Post: 03-04-2010, 12:16 PM
  5. Switchboard Help
    By Danzivar in forum Access
    Replies: 1
    Last Post: 12-15-2006, 03:44 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums