I currently have a form (Form1) with a subform (Form2). After entering criteria in Form1 the results set is displayed in datasheet view on Form2. I would like to create a button when pushed will open a new Excel workbook and then send the results set from Form2 to a worksheet. Any help with this will be appreciated.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Exporting From Access Form To Excel
- Thread starter NewComer
- Start date
Let your wizard be your guide. When you choose cndbutton with the old boy turned on he takes you thru the whole bit. Choose to open and app, I think and one of the choices will be EXCEL. The some messing around will allow you to open the file - I think it is open app with the name of your file. That should get you started.
You want more explicit send and email and I will send you some of my old code.
rollie@bwsys.net
You want more explicit send and email and I will send you some of my old code.
rollie@bwsys.net
- Status
Similar threads
