Data export directly from form into Excel.

[Lifeseeker]

Hi all,

Just exploring the possibility of this....

Is it possible to do an export of data directly from a form?

To accomplish the same thing can be done from a report, but users would like to just do that without having to run a report.

I am using Access 2003 and Excel 2003

Any thoughts/comment much appreciated.

 

[boblarson]

Do you want all records from the form (includes filtered form)?

If so, you can paste this code:
http://www.btabdevelopment.com/ts/default.aspx?PageId=47

to a standard module and then call it as instructed in the top of the function.