Create and export data from form to excel

  • Thread starter Thread starter Chad
  • Start date Start date
C

Chad

Hello, I have a form named frmMain and it has a subform named frmMainSubform.
On this subform I have a few controls. I would like to add a button on my
frmMain that would generate an excel workbook and in the first rows like A1
and B1 and C1 have the same headings as what I have on my form and with the
information from my form. How would I do this? Thanks!
 
Chad,
on the button you can use Transfer Spreadsheet.
vba help tells you how to set up the code.


Jeanette Cunningham -- Melbourne Victoria Australia
 

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

Continious forms record source loop 2
Getting to a control from a subform 4
Pop-up form that creates record that links 1:1 to main form 0
Requery main form after subform update and not lose place in main form. 1
Access 97 - When opening, returning a form to the prior state when the ap was closed 1
VBA, Access: Creating new record from subform 0
How to loop through controls and forms? 5
Delete forms record and subforms record 2

Back
Top