By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,197 Members | 1,205 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,197 IT Pros & Developers. It's quick & easy.

Leave Opened Table on Top

P: 47
Hi,
I have a form which has a button. The job of the button is to open a table. I ve done that but when the table opens, the form needs to be behind the table. In other words the form needs to be open but has to be hidden behind the table, so that when the table is closed, the form pops up from behind. Kindly help me with this.
Thanks
Mar 13 '08 #1
Share this Question
Share on Google+
7 Replies


MindBender77
100+
P: 234
Hi,
I have a form which has a button. The job of the button is to open a table. I ve done that but when the table opens, the form needs to be behind the table. In other words the form needs to be open but has to be hidden behind the table, so that when the table is closed, the form pops up from behind. Kindly help me with this.
Thanks
You could try:
Adding code to the OnClick event of the button that minimizes your form.
Are you opening a form in datasheet view when you say your opening a table?

Bender
Mar 13 '08 #2

P: 47
You could try:
Adding code to the OnClick event of the button that minimizes your form.
Are you opening a form in datasheet view when you say your opening a table?

Bender
I am opening the form in formview. That form has a cmd button which opens the table in datasheet view.
Mar 13 '08 #3

missinglinq
Expert 2.5K+
P: 3,532
You keep saying that you are "opening a table." If this is true, you are making a grave mistake. End users should never have direct access to tables, but rather should interact only thru forms. Use the table as a basis for a datasheet view form (you can easily use the Forms Wizard for this) then go into Design View and go to the Properties sheet, Other tab and set Popup to True. Now have your button open the form, and it'll appear on top of the first form.

Welcome to TheScripts!

Linq ;0)>
Mar 13 '08 #4

P: 47
You keep saying that you are "opening a table." If this is true, you are making a grave mistake. End users should never have direct access to tables, but rather should interact only thru forms. Use the table as a basis for a datasheet view form (you can easily use the Forms Wizard for this) then go into Design View and go to the Properties sheet, Other tab and set Popup to True. Now have your button open the form, and it'll appear on top of the first form.

Welcome to TheScripts!

Linq ;0)>
The end user of this application i am making is just one person who will make changes to the table frequently. Thats why i need the table to open in datasheet view when i click on the button. The problem i am facing is that the form stays in the forefront even when the table is open. The table still is accessible but it doesnt look good.
Mar 13 '08 #5

Expert Mod 2.5K+
P: 2,545
Hi,
...when the table opens, the form needs to be behind the table. In other words the form needs to be open but has to be hidden behind the table, so that when the table is closed, the form pops up from behind...
Hi. Check that the form's Pop-Up property is set to No. If it is set to Yes it will stay on top of all other open windows in your application.

-Stewart
Mar 13 '08 #6

NeoPa
Expert Mod 15k+
P: 31,494
When you have opened the table, you can run :
Expand|Select|Wrap|Line Numbers
  1. Call DoCmd.SelectObject(acTable, "TableName", False)
You can also hide the form, but triggering the showing of it again is quite fiddly. Let me know if this is important for you.
Mar 14 '08 #7

NeoPa
Expert Mod 15k+
P: 31,494
NeoSam, I've amended the title of this thread to conform to the site rules (See Help above). Please try to follow the correct format in future.

Welcome to TheScripts :)
Mar 14 '08 #8

Post your reply

Sign in to post your reply or Sign up for a free account.