469,658 Members | 1,844 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,658 developers. It's quick & easy.

Full screen forms

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

Sep 11 '06 #1
5 3601
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

Sep 11 '06 #2
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
Sep 11 '06 #3
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

Sep 11 '06 #4
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
Sep 12 '06 #5
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


Sep 12 '06 #6

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Larry R Harrison Jr | last post: by
6 posts views Thread by Tony Liu | last post: by
16 posts views Thread by Naveen Mukkelli | last post: by
1 post views Thread by Angus Lepper | last post: by
15 posts views Thread by iwdu15 | last post: by
reply views Thread by Franklin M. Gauer III | last post: by
1 post views Thread by Jon Vaughan | last post: by
11 posts views Thread by Richard | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.