Exporting to Excel

[Pietro]

Hi,

I've a button that exports the current from to Excel,actually i don't
want to extract all fields,so i usually use the VISIBLE property to hide the
fields that id don't want to use on the click event of the same
button,then,after the export process i show them again through the same
property (VISIBLE ).
What happened to me is that I'm trying the same process but i cannot hide
sime fields,do you have suggestions or other ways to hide some controls while
exporting?

 

[Jeanette Cunningham]

Pietro,
create a query that has just the fields you want to export.
Export the query instead of the form.


Jeanette Cunningham -- Melbourne Victoria Australia

 

[Pietro]

Thank you Jeanette
Actually i need to export the form itself as it has many checkboxes that
change the record source of the form,so i always want to export what i see in
front of me...

 

[Jeanette Cunningham]

Pietro,
you won't be able to hide a control while it has the focus.
Make sure to shift the focus to a 'safe' control before you try to hide a
control.
Make you hide the controls before you start the export process.


Jeanette Cunningham -- Melbourne Victoria Australia