Two questions

  • Thread starter Thread starter Alp Bekisoglu
  • Start date Start date
A

Alp Bekisoglu

Hi All,

Guess my mind is going haywire... so here are the questions:
1- Have a report with 8 subs in it. 2 of them require an input of year (due
to the source query). Any straight-forward way to get these subs's queries
to accept a field as the variable entry from the Main Report itself?

2- As the application is programmed to go through 2 or more initial data
entry forms before displaying the menu, how can I delay/hide/lose the focus
on the menu? When the first form is completed, the second opens properly but
only to get covered by the bigger sized menu... So I need to keep the focus
on the underlying form.

Suggestions?

Thanks in advance,

Alp
 
Alp,

1. I think the best approach is to put an unbound textbox on a form
which will be open at the time that the report is printed, enter your
criteria in there, and then have all the queries reference this
textbox in the criteria.

2. Set the data form's Modal property to Yes?

- Steve Schapel, Microsoft Access MVP
 
Thanks Steve,

I'll try them. Actually why I didn't do that (1) was the same queries are
also used by other forms and reports. If that creates problem, then I guess
I'll have to re-write those only for this report as well.

Actually (for item 2) the very first form for basic data is called from the
startup (within the menu code) when there are no records, i.e. fresh
database. The form after that is where the new user is forced to enter
further details. This form calls many others in performing this initial data
entry. BTW when I did set the modal to yes, the form opened and minimized
itself???

Eventhough I have read that no further questions within a thread, how do I
restrict the output of a report (set as 2 columns) so that I actually get
the 8 lines of data as 4 and 4? It does it when I set across then down, but
it needs to be the other way around. Sorry for pushing this.

Thanks,

Alp
 
Back
Top