Popup Query for editing

[R32chaos]

Dear members;

I have a form in which Popup is set to yes. I have many reports opening via buttons on the form and they are all set to Popup Yes and Modal Yes, so there is no problem.

I however have to make a button to open a query for editing also but the query will not open in front of the form and remains hidden behind it because i could not make the query open up and appear on top of the form, any suggestions? Can I possibly make the form property of Popup change when i click on the button for the query to open? Or can i come up with a vb docmd.openqry command which forces the query to stay on top?

Any help will be very much appreciated...thanks in advance!

 

[jal]

Perhaps this can be solved by using another form (DataSheet style) to run the query?

 

[R32chaos]

Thank you Jal, I appreciate the info.

Actually the query needs to made available so that it can be modified an manipulated. A form which enables viewing the data, be it in data sheet format, will not suffice because the query will still be locked away.

What I have done so far is upon opening of the query, the popup form where the button for accessing the query resides, is then closed; this enables users to view the query in a rudimentary sort of way...at least for now.

Thanks for your help!

 

[jal]

Actually the query needs to made available so that it can be modified an manipulated. A form which enables viewing the data, be it in data sheet format, will not suffice because the query will still be locked away.

Personally I think you can have both worlds, but I could be wrong (not much experience in this area). Meaning, I was thinking that both
(1) Any changes the user makes on the datasheet will update the tables.
(2) The query can be changed dynamically at run time and then form updated (using VBA code) to so reflect.

But I'm probably wrong on this. You seem to have some experience in this area.

 

[R32chaos]

Jal,
Thank you for your input. My rudimentary method seems to work ok for now.
As I had stated; what I did was close down the POPUP form in the background whenever the button is pressed for the query to open in design format. This way upon closing the query the user is returned to the Main Menu and it seems to not cause any loss in productivity.

Thanks again for the effort!

There is one other question; is there anyway to force Access to display the Min/Max/Close small button on the top right corner of the query (when its open in design mode) ? this seems to be a bug in almost all versions of Access This phenomenon is also witnessed when opening reports or forms in design mode, the small buttons are visible/invisible sporadically. Any suggestions will be very welcome.

Regards, Martin