We need to change the FOOTER of a large collection of MS Access 2007 reports from an existing format to a new one. You will be supplied with the new formatted footer as an Access report object for both landscape and portrait formats. You will be required to open the MS Access reports collection from the supplied accdb database. Then, one at a time, delete the current footer text, check if the report is A4 lanscsape or A4 portrait, copy and paste from the new templated report footer the new landscape or portrait footer, check the new footer "on format" event is set to =FormatFooter(), check the new footer is neatly between the left & right margins of the report body, then save and close the report. A prefilled access table of all the report names will be supplied in the same database for you to note success or if a problem occured (so we can go back later and fix that report). Then you would move to the next report and repeat the process.
We have test run the process and we can average 1 report every minute approx. It would take about 50 reports to get the hang of the process. There are 1,083 report to check. Please note that you cannot "run" the reports as none of the query, tables or code for the whole database is being supplied or is necessary to be used. We are only supplying the reports collection.
We have a couple of days to have this work done, so you can take your time and have lots of cups of tea and sleep in between. This project is not urgent. Accuracy is important.
The attached zip file "RGCReportsOnly_Example" is an accdb of the final version. This version shows only a handful of the files to be converted. The full accdb database with all the 1,083 reports will be supplied to the successful bidder.
25 freelancers are bidding on average $523 for this job
Hello sir i can update the report footer as required in the existing MS Access database(s) and carry out all necessary updates as listed in the description Best regards vnb400