J
Jeff Conrad
Hi,
Using Access 97 here.
I have several forms to launch various types of reports.
The forms usually have option boxes, check boxes, and
sometimes combo boxes of employee names, etc. The reports
naturally look to these forms for their criteria. This all
works just fine.
However, I'm finding the form that launches all my
appointment reports is becoming quite busy! I'm making so
many different styles of reports that the form almost
seems overwhelming right now! I have to find out what
layout style, what date or date range, what managers to
display, print color or no color, and finally send to the
screen or directly to the printer. That's a lot for one
form! So I'm thinking of going a different route now.
I notice that most professional applications use a series
of forms to open up a report. They usally have Cancel,
Next, Back, and Finish buttons on them as you progress
through the screens. I'd like to try something similar
here.
I downloaded the Access 97 "Wizard-Building Wizard" Add-In
and have been playing with it for some time. Now the look
of this is just what I want. Each screen progesses you
through the various selections. However, it seems like
there is a lot of "overhead" with this thing and a lot of
complexity for something that should be 'fairly'
straightforward. The wizard creates three extra tables and
has extra module code as well.
So I'd like to find out what you experts do in this
situation. Would it just be easier to build some
identically sized forms, open all the forms hidden, and
toggle the visibility as you go forward and back? Or is
there another way that would be easier for me given my
experience level?
Thanks for any thoughts,
Jeff Conrad
Bend, Oregon
Using Access 97 here.
I have several forms to launch various types of reports.
The forms usually have option boxes, check boxes, and
sometimes combo boxes of employee names, etc. The reports
naturally look to these forms for their criteria. This all
works just fine.
However, I'm finding the form that launches all my
appointment reports is becoming quite busy! I'm making so
many different styles of reports that the form almost
seems overwhelming right now! I have to find out what
layout style, what date or date range, what managers to
display, print color or no color, and finally send to the
screen or directly to the printer. That's a lot for one
form! So I'm thinking of going a different route now.
I notice that most professional applications use a series
of forms to open up a report. They usally have Cancel,
Next, Back, and Finish buttons on them as you progress
through the screens. I'd like to try something similar
here.
I downloaded the Access 97 "Wizard-Building Wizard" Add-In
and have been playing with it for some time. Now the look
of this is just what I want. Each screen progesses you
through the various selections. However, it seems like
there is a lot of "overhead" with this thing and a lot of
complexity for something that should be 'fairly'
straightforward. The wizard creates three extra tables and
has extra module code as well.
So I'd like to find out what you experts do in this
situation. Would it just be easier to build some
identically sized forms, open all the forms hidden, and
toggle the visibility as you go forward and back? Or is
there another way that would be easier for me given my
experience level?
Thanks for any thoughts,
Jeff Conrad
Bend, Oregon