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

Hide pop-up whilst query results are displayed

P: n/a
Hi all,
I have a pop-up which has several command buttons which allow users to
run a few stored query's. Having the query's displayed as report is not an
option due to several reasons. My problem is that I want to hide the popup
whilst the results of the query are displayed. I can get the form to hide ok
with the On_Click event of each command button, it's un-hiding it that's my
problem.

Can anyone offer any help on this?

TIA

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


P: n/a
In such cases, I've put code behind the button which
opened the query
set the form's Visible property to False
looped, using SysCmd to determine the state of the query, until it
closed
set the form's Visible property to True.

HTH

"Mark" <ma**********@ntlworld.com> wrote in message
news:cO*************@newsfe5-win.ntli.net...
Hi all,
I have a pop-up which has several command buttons which allow users to
run a few stored query's. Having the query's displayed as report is not an
option due to several reasons. My problem is that I want to hide the popup
whilst the results of the query are displayed. I can get the form to hide ok with the On_Click event of each command button, it's un-hiding it that's my problem.

Can anyone offer any help on this?

TIA

Mark

Nov 13 '05 #2

P: n/a
After a little research, I found I could do this by creating a form based on
the query and open the form in datasheet view. As it is a form, I can use
the events of the form to do as I need!!!

Mark

"Mark" <ma**********@ntlworld.com> wrote in message
news:cO*************@newsfe5-win.ntli.net...
Hi all,
I have a pop-up which has several command buttons which allow users to
run a few stored query's. Having the query's displayed as report is not an
option due to several reasons. My problem is that I want to hide the popup
whilst the results of the query are displayed. I can get the form to hide
ok with the On_Click event of each command button, it's un-hiding it
that's my problem.

Can anyone offer any help on this?

TIA

Mark

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.