Results 1 to 4 of 4
  1. #1
    roaftech is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Nov 2012
    Location
    Romania
    Posts
    65

    Replicating a switchboard-type function

    Can anyone point me in the direction of a primer on how the switchboard functions? I don't mean how to create switchboard items but rather the processes behind the activities. I would like to use the idea of a table-based functionality to create a series of related reports, where the headings, spacings, datasources, etc, are held in a table, rather than having a large number of separately-designed reports that may differ only in small details of layout. (ie it's not just the content but the format that I want to control.) It seems to me that the way the 'switchboard items' table is configured might be adaptable for this but I need to know more about how the switchboard uses the table data.
    Many thanks

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,626
    Start with http://office.microsoft.com/en-us/ac...001213876.aspx
    I sort of figured out how switchboard works by exploring one of the db templates but no way I can try to convey that here. I doubt it can be applied to report production, never seen it.

    Be aware switchboard is phased out with Access 2010 in favor of the Navigation form. However, I never like the switchboard and don't appreciate the Navigation form any better. Both are designed with web database in mind.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    roaftech is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Nov 2012
    Location
    Romania
    Posts
    65
    Thanks for your prompt response (as usual). I too worked out the basic principles of the built-in switchboard by exploring "what happens if ..." and then building up my knowledge as situations dictated.
    I am relatively new to producing reports in Access - when I worked in local government the scale of the operation was such that I preferred to export the processed data to Excel for preparing reports and graphs. Now I am in a much smaller voluntary situation where the native reporting in Access is appropriate and I am exploring this aspect further.
    My idea was to try to replicate the functionality behind the switchboard - using a table-based approach to defining the details of report layout and contents, and fitting them into a standard template. My reports each have a similar layout but change in details such as title, headings, column widths, etc and rather than design a copy of the report for each variation I was exploring the idea of putting those details into a table, to be called as necessary. (In a way, not dissimilar to constructing a SQL query using VBA.) It's not a high priority thing - more a continuation of 'learning by doing'. I'll report back if anything comes of it.
    (And, being a charity with little funding we won't be getting Ofiice 2007 or 2010 until it starts appearing on the second-hand computers that we get given, by which time I will be too old to learn the ribbon menu system!)

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,626
    Nah, never too old.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replicating ROW_NUMBER OVER (PARTITION BY...)
    By normanj in forum Queries
    Replies: 2
    Last Post: 11-27-2012, 07:36 AM
  2. Replies: 10
    Last Post: 05-24-2012, 02:44 AM
  3. Replies: 7
    Last Post: 09-13-2011, 01:38 PM
  4. Switchboard open form based on function value
    By silverspr in forum Forms
    Replies: 5
    Last Post: 03-10-2011, 02:10 PM
  5. access replicating itself
    By tintincute in forum Access
    Replies: 3
    Last Post: 09-08-2010, 12:49 PM

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