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

Closeing MSQuery Window from Access

P: n/a
Is there any way that I can close an MsQuery Window by VBA?

I have code with some DDE commands that opens an MSQuery and executes a
query. That opens a window called Query1 in MsQuery. I want to be able
to close the Query1 window in Msquery without closing MsQuery itself.

Thanks
Brian

Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a


BerkshireGuy wrote:
Is there any way that I can close an MsQuery Window by VBA?

I have code with some DDE commands that opens an MSQuery and executes a
query. That opens a window called Query1 in MsQuery. I want to be able
to close the Query1 window in Msquery without closing MsQuery itself.

Thanks
Brian


Nov 13 '05 #2

P: n/a
You can use docmd.Close acQuery, "queryname". You can also open the
query in a recordset so that you can use the data behind the scenes. I
am not sure what you are trying to do.

Nov 13 '05 #3

P: n/a
Thanks Collen,

MSquery is a seperate application that I am opening with access using
DDECommands. However, I cannot figure how to close it out without the
user click on the X button.

-Brian

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.