N
Nimrod
I have a single form "frmSerial" that has a single textbox "txtSerialNum".
Upon entering data I need to trigger a VBA event to export the content of
this one single text box into an Excel sheet. Preferrably I would want to
zero the entire worksheet (or create a new one) prior to transferring the
text box content.
I know this VBA event needs to be placed in the After Update event. But I'm
not sure how to go about doing the transfer from Access to Excel. It's not
a table since its an unbound text box.
After I do an export I need to run an external program to retrieve data from
R/3 which will fill more data into my spreadsheet. I will need to then read
all of this data into a table.
Can someone point me in the right direction? Thanks in advance!
Scott
Can someone point me in the direction I need?
Upon entering data I need to trigger a VBA event to export the content of
this one single text box into an Excel sheet. Preferrably I would want to
zero the entire worksheet (or create a new one) prior to transferring the
text box content.
I know this VBA event needs to be placed in the After Update event. But I'm
not sure how to go about doing the transfer from Access to Excel. It's not
a table since its an unbound text box.
After I do an export I need to run an external program to retrieve data from
R/3 which will fill more data into my spreadsheet. I will need to then read
all of this data into a table.
Can someone point me in the right direction? Thanks in advance!
Scott
Can someone point me in the direction I need?