If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access report management
i have a form on an access FE (access 2000) i use one combo box to determine
which report is loaded on a click event, at the moment they open in acViewPreview, but i wish to be able to have a combo box with acViewNormal and acViewPreview as the options and then have the vba grab the view method however i get type mismatch error any advice? or help here is my code dim ReportName as Variant dim Method as Variant ReportName = me.cboreport Method = me.cboMethod doCmd.OpenReport ReportName, Method |
#2
|
|||
|
|||
Access report management
Why not leave your report open in acViewPreview and have a custom menu with
the options to print or close that opens with the report. Steve "Access Beginner" Access wrote in message ... i have a form on an access FE (access 2000) i use one combo box to determine which report is loaded on a click event, at the moment they open in acViewPreview, but i wish to be able to have a combo box with acViewNormal and acViewPreview as the options and then have the vba grab the view method however i get type mismatch error any advice? or help here is my code dim ReportName as Variant dim Method as Variant ReportName = me.cboreport Method = me.cboMethod doCmd.OpenReport ReportName, Method |
#4
|
|||
|
|||
Access report management
|
#5
|
|||
|
|||
Access report management
I'm not suggesting doing away with the combobox. I just suggested that when
each report is opened (when it is selected in the combobox) that a custom menu with the option to Print or Close automatically opens with each report. This can be done with one custom menu that all reports automatically open. Steve "Access Beginner" wrote in message ... The people that are using this system are not to clever, hence why all the reports are in a combo box, the last version of the program had a button for each report and it frustrated them, they asked if this could be worked into this version "Steve" wrote: Why not leave your report open in acViewPreview and have a custom menu with the options to print or close that opens with the report. Steve "Access Beginner" Access wrote in message ... i have a form on an access FE (access 2000) i use one combo box to determine which report is loaded on a click event, at the moment they open in acViewPreview, but i wish to be able to have a combo box with acViewNormal and acViewPreview as the options and then have the vba grab the view method however i get type mismatch error any advice? or help here is my code dim ReportName as Variant dim Method as Variant ReportName = me.cboreport Method = me.cboMethod doCmd.OpenReport ReportName, Method |
Thread Tools | |
Display Modes | |
|
|