var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: can't find the object.
I am exporting to excel with the statement
DoCmd.TransferText acExportDelim, , "qryToExport", s, True
but as i click save.
I recieve the error can't find the object.
where qryToExport is a view not table.
Is there any other way if i want to make use to views rather than table?
TransferText does not export to Excel; TransferSpreadsheet does. I suggest you consult the help file. Also, where's the filename argument? That's probably why you get the error can't find object.
I did that.
I created a stored procedure which on the fly creates a table and then i used table in this statement.