Full screen forms

[King]

Hi

I have created a database where I made the forms appear full screen
through courtesy of this group. But I have a problem when I click a
command button for a report or a query. How do I make a report or query
to be on top of the Form.

Thanks

MaCh

[Michael Kintner]

Each Form has a Header and Footer as well as the body.

Use the header or footer to store your command buttons.

"King" <pi*******@gmail.comwrote in message
news:11**********************@b28g2000cwb.googlegr oups.com...

Hi

I have created a database where I made the forms appear full screen
through courtesy of this group. But I have a problem when I click a
command button for a report or a query. How do I make a report or query
to be on top of the Form.

Thanks

MaCh

[King]

Hi Michael

Thanks for the reply.

But I didn;t get what exactly you mean by storing command buttons.

I have created a form where I have 10 command buttons for 10 queries
and another form with 8 command buttons to open 8 reports.
Michael Kintner wrote:

Each Form has a Header and Footer as well as the body.

Use the header or footer to store your command buttons.

"King" <pi*******@gmail.comwrote in message
news:11**********************@b28g2000cwb.googlegr oups.com...

Hi

I have created a database where I made the forms appear full screen
through courtesy of this group. But I have a problem when I click a
command button for a report or a query. How do I make a report or query
to be on top of the Form.

Thanks

MaCh

[Ed Robichaud]

Sounds a little "busy" on your menu forms. What happens when you need to
add another report? Look at using a listbox to select the desired report,
then 1 cmd button to preview/print it. To answer your original question,
when a form/report is set to Pop-up = True, then they will always be on top.
-Ed

"King" <pi*******@gmail.comwrote in message
news:11**********************@p79g2000cwp.googlegr oups.com...

Hi Michael

Thanks for the reply.

But I didn;t get what exactly you mean by storing command buttons.

I have created a form where I have 10 command buttons for 10 queries
and another form with 8 command buttons to open 8 reports.
Michael Kintner wrote:

>Each Form has a Header and Footer as well as the body.

Use the header or footer to store your command buttons.

"King" <pi*******@gmail.comwrote in message
news:11**********************@b28g2000cwb.googleg roups.com...

Hi

I have created a database where I made the forms appear full screen
through courtesy of this group. But I have a problem when I click a
command button for a report or a query. How do I make a report or query
to be on top of the Form.

Thanks

MaCh

[King]

Hi Ed

Thanks for the recommendation of list box as it sounds great.

How do create a list box to show the reports. I am unaware of it. I am
ony aware of list box and combo box in which the values are selected
from tables or queries.

Appreciate your time and help.

Thanks

Ed Robichaud wrote:

Sounds a little "busy" on your menu forms. What happens when you need to
add another report? Look at using a listbox to select the desired report,
then 1 cmd button to preview/print it. To answer your original question,
when a form/report is set to Pop-up = True, then they will always be on top.
-Ed

"King" <pi*******@gmail.comwrote in message
news:11**********************@p79g2000cwp.googlegr oups.com...

Hi Michael

Thanks for the reply.

But I didn;t get what exactly you mean by storing command buttons.

I have created a form where I have 10 command buttons for 10 queries
and another form with 8 command buttons to open 8 reports.
Michael Kintner wrote:

Each Form has a Header and Footer as well as the body.

Use the header or footer to store your command buttons.

"King" <pi*******@gmail.comwrote in message
news:11**********************@b28g2000cwb.googlegr oups.com...
Hi

I have created a database where I made the forms appear full screen
through courtesy of this group. But I have a problem when I click a
command button for a report or a query. How do I make a report or query
to be on top of the Form.

Thanks

MaCh

[Ed Robichaud]

You would load your listbox with the table MSysObject, filtered to only show
reports (type = "-32764" ). To view the system/hidden tables, use the
"Tools" menu, "Options", "View" tab.
-Ed
"King" <pi*******@gmail.comwrote in message
news:11**********************@e63g2000cwd.googlegr oups.com...

Hi Ed

Thanks for the recommendation of list box as it sounds great.

How do create a list box to show the reports. I am unaware of it. I am
ony aware of list box and combo box in which the values are selected
from tables or queries.

Appreciate your time and help.

Thanks

Ed Robichaud wrote:

>Sounds a little "busy" on your menu forms. What happens when you need to
add another report? Look at using a listbox to select the desired
report,
then 1 cmd button to preview/print it. To answer your original question,
when a form/report is set to Pop-up = True, then they will always be on
top.
-Ed

"King" <pi*******@gmail.comwrote in message
news:11**********************@p79g2000cwp.googleg roups.com...

Hi Michael

Thanks for the reply.

But I didn;t get what exactly you mean by storing command buttons.

I have created a form where I have 10 command buttons for 10 queries
and another form with 8 command buttons to open 8 reports.
Michael Kintner wrote:
Each Form has a Header and Footer as well as the body.

Use the header or footer to store your command buttons.

"King" <pi*******@gmail.comwrote in message
news:11**********************@b28g2000cwb.googleg roups.com...
Hi

I have created a database where I made the forms appear full screen
through courtesy of this group. But I have a problem when I click a
command button for a report or a query. How do I make a report or
query
to be on top of the Form.

Thanks

MaCh