layout of query question

[teach314]

hello

I have VBA that deletes a query, if it exists, then creates a new query def using code like...

Set MyQueryDef = CurrentDb.CreateQueryDef(strQryName, strSQL)

DoCmd.OpenQuery strQryName

The query has many columns, so I change the query layout to make very narrow columns. But when the query is deleted then recreated, I have to readjust the layout every time.

Here is my question. Is there a way to 'preserve' the query layout so that it stays the same every time?

 

[PHV]

Why not simply modify the SQL of the query ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[teach314]

hi PHV

I'm missing something here. What SQL commands can be used to adjust the column widths of the query output?

Thanks

 

[PHV]

My point was: why not modify the SQL of the query instead of deleting and recreating ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886