search records and export

[tggsun]

Hello,
I have a project need to create a user interfact. The function of the interface, 1). allow end user enter a search range (date informat), 2). create a button which will do search and export the search result into a excel / CSV format file into a folder, 3). the exported file's name will be automatic set as exported date.


Do you think this one can be done without VBA? if yes, how to do that?
Thanks,
DD SF

[aytee111]

I have to admit defeat, I cannot find a way to do it without VBA. Have you searched the internet?

Here is how to do it using vba:
- create query, use [Enter Date] parameter - you could also put the date on the form as a text box then the query can refer to it instead (do you know how to do this?)
- on form, put a command button "Export" or whatever
- go to the properties for that button - in the OnClick event, select EventProcedure
- this is the vba to use

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "query_name", "path and file name" & Format(Date, "yyyymmdd") & ".xls", True

(This is for Excel 2003)

Don't copy and paste this - begin typing in VBA and Access will tell you what it wants each step of the way (every time you enter ",") and you will have a better understanding of what you are doing.

[tggsun]

Thank you.
I'll try VBA.
DD SF