Results 1 to 5 of 5
  1. #1
    sabrantley0623
    Guest

    Can't View Switchboard Items in Access 2000 RT

    On one or two pc's in the plant where I have installed the run-time version, I try to open the database (converted from 97 to 2k), and only one of the buttons on the switchboard is visible, and none of the text that is on the switchboard. The pc's in question have Win98 Second Edition, Internet Explorer 5x. I checked the references after going into a code module, and they are the same as in other databases that I have. I can go into the same database on a machine I have in my dept., and it will work okay. I did use the same installation package that I have for all other pc's in the plant. I am using the SR-1 for the Devloper's Edition. Any ideas? Thank you!

  2. #2
    Lounger
    Join Date
    Jan 2001
    Location
    Indiana
    Posts
    41
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can't View Switchboard Items in Access 2000 RT

    Access Runtime for the most part will allow normal functionality of Access DB's. However there are cases directly related to use of the Switchboard Manager to develop the application switchboard, where the application will not operate properly in Runtime. I have been down this path several times myself.

    There are two solutions: you will either need to add the switchboard manager "add-in" onto the PC's with runtime, or the easier solution to save future hassles, is to convert the switchboard buttons and labels over to VB or macro driven. Change them over from the current =option value that relies on the underlying Switchboard table to make them work.

    This should fix your runtime problem.

  3. #3
    sabrantley0623
    Guest

    Re: Can't View Switchboard Items in Access 2000 RT

    I did convert the buttons to being activated via macros, but I did use the switchboard manager to set it up (brand new switchboard), in Access 2000. What I don't get is why it works some of the time, and not others. What file(s) are required for the switchboard manager? Thanks for the help.

  4. #4
    Lounger
    Join Date
    Jan 2001
    Location
    Indiana
    Posts
    41
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can't View Switchboard Items in Access 2000 RT

    Make sure you delete all of the filtering events found in the Form properties under the OnOpen, and OnUpdate properties. These events still cause the form to "look" for the options table.

  5. #5
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Can't View Switchboard Items in Access 2000 RT

    It will work on machines that have Access 2000 installed and fail on those that don't if it follows the normal pattern for runtime problems. Not all menu choices are available in runtime either, so I generally build my own switchboards and commandbar code for runtime applications.
    Charlotte

Posting Permissions

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