transfer current access form record to an excel sheet

[ielmrani via AccessMonster.com]

Hi,
I serach Access Monster for a similar issue but i came up with nothing. I
appreciate if someone share a code to transfer the current record from an
access database form to an excel sheet. In other words, when I open the form
and do a search for x record, I would like to transfer X record (not all the
records) to and excel sheet. Thanks in advance

 

[Stefan Hoffmann]

hi,

I serach Access Monster for a similar issue but i came up with nothing. I
appreciate if someone share a code to transfer the current record from an
access database form to an excel sheet. In other words, when I open the form
and do a search for x record, I would like to transfer X record (not all the
records) to and excel sheet. Thanks in advance

Take a look at

DoCmd.TransferSpreadSheet

in the OH. You can use a query, which returns the actual record for this
function.


mfG
--> stefan <--

 

[ielmrani via AccessMonster.com]

Thank you Stephan

hi,

Take a look at

DoCmd.TransferSpreadSheet

in the OH. You can use a query, which returns the actual record for this
function.

mfG
--> stefan <--