button to open form export to Excel and close form

D

deb

I have a form called fBuyer and a form called fAdmin. I would like to have a
button on fAdmin to...
open the form fBuyer, export it to excel and close the form fBuyer.

How can I do this?

Thanks
 
D

deb

Let me re-word...
I need to click a button and have the data export to Excel, from the
form"fBuyer" which is a form that is a datasheet view.

It sounds like you already know what I needed, but I was not able to explain
it the way you wanted.

Thanks
 
B

bhicks11 via AccessMonster.com

Sorry Deb. I wasn't trying to be snotty, it really is easy to be
misunderstood via the written word especially when you are talking about
things that can be worded so differently by different people.

So, to export to excel: On the button's OnClick event, put something like
this (customize to your table/queries, etc names):

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel8, TableName,
FileNameto,HasFieldNames,


Look in the VBA help under TransferSpreadsheet if you have syntax problems.

Bonnie

http://www.dataplus-svc.com
Let me re-word...
I need to click a button and have the data export to Excel, from the
form"fBuyer" which is a form that is a datasheet view.

It sounds like you already know what I needed, but I was not able to explain
it the way you wanted.

Thanks
Hi Deb,
Click to expand...
[quoted text clipped - 12 lines]
Click to expand...
 
Top