Save As msgbox after Query is run????/

[Rmck87]

Alright, i have a form that has option groups and comboboxes on the same form. It also has a search button on it. Whenever the search button is selected a query is run that selects records that correspond with the users selections in the comboboxes, and option groups. The question is: Whenever the query is run i want a msgbox to come up asking if the user would like to save the query, and if they select yes, then what they would like to save the query as. If they select no, then the query does not get saved. Is there a way to do this after the query is run? I dont want it to come up the second the query is run, but i want it to come up a minute or half a minute after it comes up so the user has time to look over the query and decide if they like the records. Is this possible? Please let me know as soon as possible. Thanks for the help.

One Ring to Rule Them All, One Ring to Find Them, One Ring to Bring Them All, and in the Darkness Bind Them.

 

[Wiszh]

If the data is changing saving the query will not save the data as it is, retrieving the data later will bring back the new data.

 

[Rmck87]

Ok, you have just completely lost me!?!?!?!? I'm not following.

One Ring to Rule Them All, One Ring to Find Them, One Ring to Bring Them All, and in the Darkness Bind Them.

 

[Wiszh]

When you save a query the records are not saved with it only the search criteria.

Therefore, if you user saves their new query the data that they see may not be the same next time they view the query.

(I assume you've included some means to view the query again, otherwise there is no point in saving it.)

 

[Rmck87]

Yes there are some means to viewing it again. Whenever the user saves the query, i have it created so the user can go open the saved query in Excel, and in Excel, behind the scenes it opens and refreshes the query. So it works fine. But i just need to know how to set a save prompt to come up after the query is run.

One Ring to Rule Them All, One Ring to Find Them, One Ring to Bring Them All, and in the Darkness Bind Them.

 

[Wiszh]

It sounds like you need the onTimer event where you can tell it to pop open the save dialog after the specified interval.

 

[Rmck87]

That sounds like what i was looking for. But how would the code look for that. Would i set up a docmd.save or something like that. or would i be able to have a saveprompt come up with the ontimer event?

One Ring to Rule Them All, One Ring to Find Them, One Ring to Bring Them All, and in the Darkness Bind Them.

 

[Wiszh]

You should be able to pop open the save prompt when the timer runs out.

 

[Rmck87]

How do i set the timer for a specified amount of seconds?

One Ring to Rule Them All, One Ring to Find Them, One Ring to Bring Them All, and in the Darkness Bind Them.

 

[Rmck87]

Would this timer start counting after the form is loaded? Or would the timer start counting after the search button is pressed?

One Ring to Rule Them All, One Ring to Find Them, One Ring to Bring Them All, and in the Darkness Bind Them.