Leave Opened Table on Top | Member | | Join Date: Mar 2008 Location: Bangalore, India
Posts: 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
|  | Familiar Sight | | Join Date: Jul 2007 Location: Pittsburgh,Pa USA
Posts: 232
| | | re: Leave Opened Table on Top
Quote:
Originally Posted by neosam 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
| | Member | | Join Date: Mar 2008 Location: Bangalore, India
Posts: 47
| | | re: Leave Opened Table on Top
Quote:
Originally Posted by MindBender77 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.
|  | Moderator | | Join Date: Nov 2006 Location: Richmond, Virginia USA
Posts: 3,000
| | | re: Leave Opened Table on Top
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)> | | Member | | Join Date: Mar 2008 Location: Bangalore, India
Posts: 47
| | | re: Leave Opened Table on Top
Quote:
Originally Posted by missinglinq 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.
| | Moderator | | Join Date: Feb 2008 Location: Beauly, near Inverness, Scotland
Posts: 1,576
| | | re: Leave Opened Table on Top
Quote:
Originally Posted by neosam 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
|  | Administrator | | Join Date: Oct 2006 Location: London - UK
Posts: 15,730
| | | re: Leave Opened Table on Top
When you have opened the table, you can run : - 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.
| | Administrator | | Join Date: Oct 2006 Location: London - UK
Posts: 15,730
| | | re: Leave Opened Table on Top
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 :)
|  |
Similar Microsoft Access / VBA bytes | | |  /bytes/about
We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights.
Get the best answers to your questions from over 226,471 network members.
|
