Hi There,
I have a Marco that outputs a CSV file. This Marco previously used a standard query. However, the client requested that depending on a result the column's value will be x, or, y etc etc.
So, I have the new query that contains a SWITCH function. The query runs fine via the "run" feature on Access and throughout the database.... except when I try to use the Marco to export. It always states:
"The Microsoft Office Access database engine could not find the object 'invoices.csv'. Make sure the object exists and that you spell its name and path name correctly."
Even though, if I take out the SWITCH function from the query it all works as expected.
So my question is, could someone please test this out for me that you can export to a csv file using a marco with using a switch function.
I just need to explain to the client that this can not happen... but a possible solution would also be fantastic!
Any help would be much appreciated.
I have a Marco that outputs a CSV file. This Marco previously used a standard query. However, the client requested that depending on a result the column's value will be x, or, y etc etc.
So, I have the new query that contains a SWITCH function. The query runs fine via the "run" feature on Access and throughout the database.... except when I try to use the Marco to export. It always states:
"The Microsoft Office Access database engine could not find the object 'invoices.csv'. Make sure the object exists and that you spell its name and path name correctly."
Even though, if I take out the SWITCH function from the query it all works as expected.
So my question is, could someone please test this out for me that you can export to a csv file using a marco with using a switch function.
I just need to explain to the client that this can not happen... but a possible solution would also be fantastic!
Any help would be much appreciated.
