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. 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
     

Share This Page