Hi
I have created a VB form through a Insert Macro option which has two date fields 'From Date' and 'To Date' in B.O 5.0.
Whenever the user runs the BO report it will automatically run the Macro and in the Macro I have specified UserForm1.Show to display the form.
Once the user enters the 'From Date' and 'To Date' in the form and Clicks OK Button(UserForm1.hide) I want to capture these two values in the Business Object variables and apply filter crediteria to display the report automatically. Has somebody tried these option ?. (We don't want to use Date prompts as we need to design the Report Entry screen in a standard format which cannot be done using Inbuilt prompts)
khobar
I have created a VB form through a Insert Macro option which has two date fields 'From Date' and 'To Date' in B.O 5.0.
Whenever the user runs the BO report it will automatically run the Macro and in the Macro I have specified UserForm1.Show to display the form.
Once the user enters the 'From Date' and 'To Date' in the form and Clicks OK Button(UserForm1.hide) I want to capture these two values in the Business Object variables and apply filter crediteria to display the report automatically. Has somebody tried these option ?. (We don't want to use Date prompts as we need to design the Report Entry screen in a standard format which cannot be done using Inbuilt prompts)
khobar