Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Changing Switchboard Links

Discussion in 'Information Technology' started by mmartinez, Jul 28, 2006.

  1. mmartinez

    mmartinez
    Expand Collapse
    Guest

    I want to change the file name of an Access report. When I do, I can't open
    the report from the switchboard. How do I change the link so it opens the
    report with the new name?
     
  2. Loading...

    Similar Threads Forum Date
    S Asia Thinking About The Big Move: The Sikh Way Of Life Changing In Khyber-Pakhtunkhwa Breaking News Mar 22, 2014
    Opinion Haanji's Quick Takes On A Changing World (September 23, 2013) Breaking News Sep 22, 2013
    Changing My Last Name To Kaur Questions and Answers May 15, 2013
    Life-changing Inspirational Stories Mar 31, 2013
    USA Sikhism And The Changing Electoral Demographic Breaking News Mar 8, 2013

  3. OP
    fredg

    fredg
    Expand Collapse
    Guest

    On Thu, 20 Jul 2006 07:52:01 -0700, mmartinez wrote:

    > I want to change the file name of an Access report. When I do, I can't open
    > the report from the switchboard. How do I change the link so it opens the
    > report with the new name?


    From what switchboard?
    One you created yourself using an unbound form with command buttons.
    Change the click event of the command button from:
    DoCmd.OpenReport "OldReportName"
    to:
    DoCmd.OpenReport "NewReportName"

    or if the code was written by the command button wizard, change the
    name of the stDocName variable:
    stDocName = "NewReportName"

    If this is the switchboard created by the built-in access Switchboard
    Manager, change the report name in the Switchboard Items table's
    Argument field.
    --
    Fred
    Please respond only to this newsgroup.
    I do not reply to personal e-mail
     
Since you're here... we have a small favor to ask...     Become a Supporter      ::     Make a Contribution     


Share This Page