Export Query from Button as .dbf File

[aldeb]

I currently export a select query as a .dbf file to a particular location and file name. I would like to automate this procedure to a command button on click event. Does anyone know the code to do this or have another way for me to do this automatically? It would even be better if I could export this same Query to Crystal Report automatically.

Thanks for the help!

 

[ScottGem]

Use TranserDatabase.

 

[aldeb]

Thanks Scott,

I am looking for a little more or possibly an example. My query name is:
"soe-oms". The file I want to export to is "oms-soe.dbf". I guess I am looking for a little more than just use Transfer Database. Being pretty new to this when I look at Transfer Database and all of the other info needed I am lost. Can you provide an example of the code?

Thanks

 

[ScottGem]

Thanks Scott,

I am looking for a little more or possibly an example. My query name is:
"soe-oms". The file I want to export to is "oms-soe.dbf". I guess I am looking for a little more than just use Transfer Database. Being pretty new to this when I look at Transfer Database and all of the other info needed I am lost. Can you provide an example of the code?

Thanks

Did you lookup TransferDatabase in Access help? You will find an example there. That's why I didn't give you more. If you still need more help after checking the Access help, let us know.