var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Is it actually possible to use SQL in a docmd.transfer*** and whatever method you are using to transfer?
At current it only allows me to use tables or queries, i dont like having queries in my database id rather just have the code built in?
Originally Posted by ChrisGolden
DoCmd.Transfer if for tranfering objects. No object, no transfer. You could create temporary queries and export those if you have an extenuating need to do so.
Because i dont like cluttering up the program where it really doesnt need to be?
I just wanted to create an SQL query that does the same job as the query in the query window.
If i had to create a query for every SQL statement i wrote then my query windows would be about a mile long!
Temp queries/tables are probably the way to go then. I use them for random I/O stuff that I have to export on occassion and therefore need to push into a table or some sort of temp object.
Thanks, ill look into that then