Exporting data to excel form

[Ben M]

Hello



When equipment is returned to our company the details are put into an access database, then the same details are filled into a excel sheet to be printed and handed around for other depments to fill in by hand then sign. I have been asked to see if it is possible to alter the database so that the appropriate parts of the excel sheet could be filled in automatically. You can see an example below, its only the sales section that comes from the database the rest is filled in by hand.



Is it possible to setup a query that would ask for say the RER number and serial number to find the correct record then export the data to fill in the right cells; or is it easier for me to try and recreate the excell sheet as an access report and have it filled in that way.

Thanks

[June7]

It is possible but requires VBA code. Yes, if you are distributing paper, build Access report replica of the spreadsheet layout.

Could build Access to allow the other departments to enter data directly into Access via a form instead of writing on paper.