Reference to query Property ???

[Ryan]

I would like to set the Column Headings property of a
crosstab query from VBA script on a form. I don't know
all of the object hierarchy and can't reference the
property.

This is what I have tried:

Application.CurrentData.AllQueries("Time Admin
CrossTab").ColumnHeadings = ColumnString

CurrentDb.QueryDefs("Time Admin Crosstab").ColumnHeadings
= ColumnString

Neither works since .ColumnHeadings isn't a property of
either ... I just don't know where to reference it. Can
someone tell me how to do what I am trying to do.

Thanks, Ryan

 

[Ryan]

Never mind ... found a KB article that addresses the issue.

KB# 155489

Cheers,
Ryan