Exporting to MS Excel

  • Thread starter Thread starter Tony
  • Start date Start date
T

Tony

How do I programmatically export data to Excel from a
subform that's not bound to a table?
 
A form does NOT have any data until it is bound to a form -- either in
design view or programatically. A form is merely a user interface that
allows you to display the data from a table or tables.
 
I'm quite baffled as to what would be the point of an unbound subform, but
you can always use Automation to open an instance of Excel and
programmatically transfer individual data items from your Access form to the
Excel spreadsheet.

HTH
- Turtle
 

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

Back
Top