How to run saved query in background

[shabar]

Hi All




How to run saved DB query in background (without getting the output results)


Because DoCmd.OpenQuery method giving a output and through DoCmd.RunSQL method cannot run the saved DB query




Cheers


Shabar

[alansidman]

What is the purpose of running a queyr in the background. If you explain to us what you are trying to do in simple language, then we can advise. Your open ended question is difficult to answer because we don't have enough information

[shabar]

Thanks for you reply alansidman


Basically I wanted to run saved DB query and export result to excel sheet through a Form. The issue is when I am using


DoCmd.OpenQuery the result set is dispalyed on the screen which I do not want. But when using DoCmd.RunSQL, I have
to give query within the code. Even that I want to get rid of as I have the saved query in the DB.


Is there a method to run saved query without displaying the result set on the screen.


Hope this clarify the issue smoewhat




Cheers


Shabar

[June7]

Explore TransferSpreadsheet method. http://msdn.microsoft.com/en-us/libr...ffice.12).aspx