Hey all.
Question with Access: I'm using Macro's to do basic commands with regards to my work. It saves a lot of time to make a macro that imports, sorts and exports rather than doing it manually, as you will know.
With the work i am doing, it wont really save any time or serve any purpose to make a form to handle the macros. Since i use the database for so many things (making queries adhoc and a million different exports) it would take an age to make a form to incorporate everything i do with macros and manually.
What i'm after though is this: Is it possible to make a Macro that exports a qeury with a dynamic filename? I've found the following VB Code that will add Date and Time to a filename but i'm not really looking to use VB, in any case it would require a form as mentioned before.
Basically i export the same file Weekly manually and change the week number myself. Is there any way of doing this automatically without making a form? or is VB the only way forward?
Thanks in advance.
Question with Access: I'm using Macro's to do basic commands with regards to my work. It saves a lot of time to make a macro that imports, sorts and exports rather than doing it manually, as you will know.
With the work i am doing, it wont really save any time or serve any purpose to make a form to handle the macros. Since i use the database for so many things (making queries adhoc and a million different exports) it would take an age to make a form to incorporate everything i do with macros and manually.
What i'm after though is this: Is it possible to make a Macro that exports a qeury with a dynamic filename? I've found the following VB Code that will add Date and Time to a filename but i'm not really looking to use VB, in any case it would require a form as mentioned before.
Code:
DoCmd.TransferText acExportDelim, "Accom_sap_export_spec", "select_updates_qry_1", "G:\NewDatabaseTest\DataTables\Accom_New_sap_" & Format(Now(),"ddmmyyhhnn")& ".csv", False, ""Basically i export the same file Weekly manually and change the week number myself. Is there any way of doing this automatically without making a form? or is VB the only way forward?
Thanks in advance.