Cutom Dialog box

[Guest]

I use a Dialog box with 'Begin' and 'End" dates to open various financial
reports. The Begin and End dates specify the period I want to review.
At month end the user needs to frequently open 5 reports - each for the same
period. It is a bit of a pain to each time re-specify the same Begin and End
dates.

Is there any way I can 'Save' the dates in the Dialogue box, so that the
users do not need to re-specify the dates - unless and until a new period is
required?

 

[Allen Browne]

Just use an Access form (not in dialog mode.)
Leave the form open.
The reports can read the dates from the form.

 

[George Nicholson]

You can always store the values in a UserSettings table if you want the
last-used-dates available the next time the db is opened.

 

[Albert D.Kallal]

Just bind the form to a small table that has the start/end dates.

In other words, don't use a un-bound form...

As a few others mentioned, if you launch the reports FROM the form, then
when you got back, the dates will be still set anyway.

some go

launch report
dialog for dates launches


I find it MUCH MCUH better to go

launch dialog for dates
which has "list of reports to run"
user selects on one the reports..and runs it..

9 out of 10 times, they need to run "several" reports with the same date
range, and so you might as well keep the "prompt" form open, and launch
reports FROM THIS form.

I have a bunch of screen shots here that shows this...and my users prefer
this approach:
http://www.members.shaw.ca/AlbertKallal/Dialog/Index.html