var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Query Properties in VBA
I have a piece of code that I am using to get some db information to an xls file. One of the things I would like to output is the "Destination Table" property for Append Queries.
dB.QueryDefs(lQryCnt).Properties("Destination Table") is not working.
Does anyone know the proper way to refer to the query properties in vba?
Any thoughts or input would be appreciated.
As far as I know, it can't be done directly. However, it is inherent in the query's SQL, of course.
returns the entire SQL, which you can then edit.
CurrentDb.QueryDefs("Your Query Name").Properties("SQL").Value
Hope this helps,
Thanks for your response.
I'm using dB.QueryDefs(lQryCnt).SQL to fill a different column. I was hoping not to have to go through all of the queries indivually. I've inherited about 30 interlinking databases and zero documentation. I'm trying to get a handle on the data flow/relationships and layout.
will ensure the first character is the start of the table name. If it begins with a "[" then the next "]" will mark the end of the table name, otherwise it will be the next space. No probs
ur codings are working excelent.
Thanks. That's exactly what I needed.