Forum Discussion
JabereMS
Jan 14, 2023Copper Contributor
Export into CSV file from Access query
Hello I have no deep experience on MSO365 ACCESS nor I am experient in Makro programming. I have the following problem I have a database with direct debit with different value days. I select th...
JabereMS
Copper Contributor
Hello arnel_gp
Thanks for the advice. I know this approach, but the goal is running the query and export directly into a CSV file.
The query requesting the value day to export before execution but in case of using the export assistant this request will ot appaer.
arnel_gp
Jan 16, 2023Steel Contributor
maybe use Form to fetch the "parameter date".
once the date is entered. you create/update a query that will hard-code the date into the query.
then use this new query for your export.
the above can only be done through form and vba (creating/updating a query using querydef).
once the date is entered. you create/update a query that will hard-code the date into the query.
then use this new query for your export.
the above can only be done through form and vba (creating/updating a query using querydef).