473,394 Members | 1,810 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,394 software developers and data experts.

Stay OnTop - Query

I have a form that by pressing a button, it opens up a query. I then
have the code to close the initial form. Then, this put the query
behind the main menu. Is there a code to add for this?:

DoCmd.OpenQuery "Query1"

DoCmd.Close acForm, "Form1"
By the way, I need "Form1" to stay open for "Query1" to open... then
once it is open, I want "Form1" to close and yet, "Query1" to stay on
top of all other forms. (e.g. Main Menu")

I don't want to create a form and have a datasheet view at this time.

Thanks,
Perry
Nov 13 '05 #1
1 1442
Try adding this to your open query statement. I tried it and the query
stayed in front of my main switchboard.

DoCmd.OpenQuery "Query1", acNormal, acEdit
--
Reggie

www.smittysinet.com
----------
"PerryC" <pe******@yahoo.com> wrote in message
news:ea*************************@posting.google.co m...
I have a form that by pressing a button, it opens up a query. I then
have the code to close the initial form. Then, this put the query
behind the main menu. Is there a code to add for this?:

DoCmd.OpenQuery "Query1"

DoCmd.Close acForm, "Form1"
By the way, I need "Form1" to stay open for "Query1" to open... then
once it is open, I want "Form1" to close and yet, "Query1" to stay on
top of all other forms. (e.g. Main Menu")

I don't want to create a form and have a datasheet view at this time.

Thanks,
Perry

Nov 13 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: Cortes | last post by:
Hi all, I have this parent window poping up the child window. SOmething like this popupWinA= window.open("child.html","popupWinA"," width=300 , height=150) I want this child popupWinA always...
3
by: Dung Ping | last post by:
I came across following code in a tutorial. I originally thought the word 'stay' in (!stay) was not important, and could be replaced by another word. The negation mark (!) was doing the whole...
4
by: crispywafers | last post by:
Hi, Is it possible to filter ontop of the current filter being applied to records? This seems like it should be easy? I have two drop down boxes-- one to filter on a student's last name, one...
2
by: michael | last post by:
Hi, folks - I am trying to build a macro that Outputs a query to Excel, then Auto Starts the Excel doc to show the query results. I'd like Excel to be the top window when this is done, but my...
4
by: MrNobody | last post by:
I'd like windows spawned off my by main window to always stay above that main window, even when you give focus to it... how would I do this? The only property I find is one which makes that window...
3
by: Ludovic Lemarinel | last post by:
Hi I've been working on the dotnet framework in vb for a while (about One year), and I've got a problem : I've written a piece of code which makes a first recordset : dim query, updtquery...
1
by: ViRi | last post by:
I am writing my own little video player, using AxMicrosoft.MediaPlayer.Interop.AxWindowsMediaPlayer, and i want to add stats when in fullscreen. I am able to Draw to it with GDI+, but since...
1
by: shayhk | last post by:
Hi all. I built a winForm program in c# I set it to be on front of all windows with the Form 'onTop' property . The problem it that it is not working when for example : windows media player is on...
2
by: Bandet Ace | last post by:
Today the MMORPG Runescape owned by JaGex released there full screen and HD mode to the game.(it's browser based) Because of there full screen mode they fill the whole screen not just the browser...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
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...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.