Query: Hide columns with VB/VBA

P

PGTips

Joined
Sep 1, 2010
Messages
1
Reaction score
0
Hi,
I have a form with subform.
The User selects tick boxes on the form relating to the columns of a data sheet (subform) they want to display. Pressing update refreshes the data sheet view.
I use the 'columnhidden' attribute to hide/display the columns.

What I want is to be able to export the chosen columns to a .xls spreadsheet.
How do I do this?
Should I export the data sheet or can I hide/unhide columns in the query using VB/VBA.

Any help would be good.

Using 2003 on XP.

Thanks in advance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do you hide Columns in a SubForm - based on values in the datasheet 1
How do you hide Columns in a SubForm 34
Access VBA error "Microsoft Access can't find the field '|' referred to in your experssion" 0
Access VBA error "Microsoft Access can't find the field '|' referred to in your experssion" 0
VBA Hide/UnHide columns 0
How to hide columns in a form in datasheet view if null 5
Excel Excel vba column hiding unhiding 2
hide columns with a "+" 2

Top