Hello group,
I am currently working on a project on MS Access using forms and VBA. What I'm doing at the moment is:
- creating a new query using CurrentDB.CreateNewQueryDef
- changing it's SQL using my form values as parameters
- changing the subform's SourceObject to "CreatedQuery"
- deleting the query
So I have subformX and qr (As DAO.QueryDef). Whenever I execute this procedure I get a new table and the table column sizes are always a bit small. How can I programmatically change these column sizes? Any suggestions?
Thank You so much
tim
I am currently working on a project on MS Access using forms and VBA. What I'm doing at the moment is:
- creating a new query using CurrentDB.CreateNewQueryDef
- changing it's SQL using my form values as parameters
- changing the subform's SourceObject to "CreatedQuery"
- deleting the query
So I have subformX and qr (As DAO.QueryDef). Whenever I execute this procedure I get a new table and the table column sizes are always a bit small. How can I programmatically change these column sizes? Any suggestions?
Thank You so much
tim