L
lblMyName via AccessMonster.com
hi, i'm new to access programming. While creating a simple invoicing app.,
i'm stuck at populating a spreadsheet control, hence this request for help.
I have a table from which i need to copy records from three fields to a
spreadsheet control on which i intend the user to do some further
calculations on the basis of imported data before passing it to a pivot table
and then the final report.
I tried to export the data from table to a .csv/txt file and then import it
to the spreadsheet control.It works, but i want an automated routine to
handle this transfer of data. There's no place on the spreadsheet control
where i could enter the data source. Please suggest how to "link" the control
to the table. And also, if i further need to archive the modified data from
spreadsheet, how to export it back to the original or some other table.
Thanks in advance.
i'm stuck at populating a spreadsheet control, hence this request for help.
I have a table from which i need to copy records from three fields to a
spreadsheet control on which i intend the user to do some further
calculations on the basis of imported data before passing it to a pivot table
and then the final report.
I tried to export the data from table to a .csv/txt file and then import it
to the spreadsheet control.It works, but i want an automated routine to
handle this transfer of data. There's no place on the spreadsheet control
where i could enter the data source. Please suggest how to "link" the control
to the table. And also, if i further need to archive the modified data from
spreadsheet, how to export it back to the original or some other table.
Thanks in advance.