I can do it with VB code no problem... but maybe this might be easier, How do I transfer the result not only into a listbox rowsource BUT to an excel spreadsheet... TransferSpreadsheet acExport function Ultimately this is my problem
Reply from Alex Hedley:
You can use QueryDefs to create a Query on the fly. Did you try the * trick for ALL?
Create a String of where you want to save it to and the name: strExcelFile Choose the correct 'SpreadsheetType'
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Search Seminar.
The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.