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
7  1383 
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
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.
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)>
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.
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
NeoPa 32,556
Expert Mod 16PB
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.
NeoPa 32,556
Expert Mod 16PB
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 :)
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Leonardo Sant Anna |
last post by:
I need to leave a field null, but i also need that field have a
foreign key. But even after creating this table with the field with
not "not-null", if i add the foreign key, i can't leave it blank...
|
by: Chris Mayers |
last post by:
Hi,
I have an application that has (for the sake of argument) 2 (MDI) windows
open.
If I click into a textbox on FormA then the 'Enter' event for that TextBox
fires, great!
However, if I then...
|
by: Wojciech Wendrychowicz |
last post by:
Hello everybody,
I've got a stored procedure wchich calls an external RPG program (see syntax
below). I need to declare a cursor to leave open for a client application as
a resultset. I'd know how...
|
by: caradhras |
last post by:
I've been troubleshooting for a friend's charity. She wants their
database accessible from both their PCs (I'll call them A & B), which
are on a local network, both running A2K on Windows 98.
I...
|
by: nickybon |
last post by:
Hi
I really want to simply leave a message saying "Thank-You for using my
system any reccomendations..bla bla bla.. Good-Bye" and then he simply
clicks OK
Its like putting up a message...
|
by: kosmodisk |
last post by:
Hi,
I'm having problem accessing javascript-created elements from opened
window. This occurs only when I'm including another files in opened
window, javascript or css. When I comment out...
|
by: sreekandan |
last post by:
Hi everybody,
Im doing project in VB6 and Ms Access as backend.
In that, While i am running the project, if the person signIn then the System Time store into the database table.Once if the person...
|
by: bobh |
last post by:
Hi All,
Anyone have code to share that would detect if a database was opened
to database window view??? and since holding the 'you know which key'
down, no form is loaded, the autoexec marco...
|
by: jjkeeper |
last post by:
Hi, I need to create an annual leave Database for the company. I admit I was a complete novice at this. But I got thrown the job and I have to do it. So here's what I get so far, but I got pretty...
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| |
