Djblois
05-16-2007, 08:49 AM
I am now trying to get where a user can set up their own Quick Reports (Commonly used reports that use the same exact options ) and save it to a button. I have no trouble with the saving and using the settings for the quick reports but I can't find a way to get the user to save the name of caption for the button.
Here is what I thought would work:
SaveSetting "Business Reporting Today", stgQckRptNum, "Report Name", UserQuickReports.ReportName
and then I delete the toolbar and readd the tool bar, which I have no problem with but the caption of the Quick Report Button always comes up as Quick Report 1.
Set subMenuItem = MenuItem.Controls.Add(Type:=msoControlButton)
subMenuItem.OnAction = "StartQuick1"
subMenuItem.Caption = GetSetting("Business Reporting Today", "StartQuick1", "Report Name", "Quick Report 1")
thank you for the help.
Here is what I thought would work:
SaveSetting "Business Reporting Today", stgQckRptNum, "Report Name", UserQuickReports.ReportName
and then I delete the toolbar and readd the tool bar, which I have no problem with but the caption of the Quick Report Button always comes up as Quick Report 1.
Set subMenuItem = MenuItem.Controls.Add(Type:=msoControlButton)
subMenuItem.OnAction = "StartQuick1"
subMenuItem.Caption = GetSetting("Business Reporting Today", "StartQuick1", "Report Name", "Quick Report 1")
thank you for the help.