Completed

MS Access: update footers in Reports

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.

Skills: Database Development, Microsoft, Microsoft Access

See more: portrait of you, ms access work, ms access database development, microsoft access database development, microsoft access test, in process access, access delete, access query table, vba update field table field table access, tea report, access table query, access database process, change existing access database, access event database, microsoft access check, copy paste access access, access report code, access table open code, access code report, update values master table access, access 2007 project reports, move access, database update required, access check check, required urgent development

About the Employer:
( 14 reviews ) Brisbane, Australia

Project ID: #6376096

Awarded to:

farr4u

A proposal has not yet been provided

$250 AUD in 5 days
(14 Reviews)
4.0

25 freelancers are bidding on average $523 for this job

expertcoder1vw

I'm an expert Access developer with a flair for precision in design. I can make the changes for all the 1083 reports and can deliver in 2 days or less. Quality assured, Satisfaction guaranteed! Thanks for considerin More

$621 AUD in 2 days
(38 Reviews)
5.7
winghei

Dear Sir, I would like to express my interest on your project posting. With lot of experience and varying skills in database structuring and software development, I am confident that I could provide you a quality pr More

$555 AUD in 10 days
(30 Reviews)
5.4
abdellatif81

Hello , I am IT engineer with European diploma since 2005 Certified as Technical specialist in Microsoft SQL Server databases, i have more than 8 years of experience working around Microsoft software and database d More

$555 AUD in 10 days
(12 Reviews)
4.9
vnb400sl

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

$555 AUD in 10 days
(38 Reviews)
4.7
cheapexcell

Hello Sir/Madam, I am an expert in Access with over 10 years of experience. Ready to start Thanks, Alex

$750 AUD in 20 days
(20 Reviews)
4.5
fabest

Dear, I am Access automation Expert since 11years. I can add specific code to add automatically your Footer on each form. Regards, Fabrice

$442 AUD in 5 days
(11 Reviews)
4.5
yubor

Предложение еще не подано

$555 AUD in 3 days
(12 Reviews)
4.0
acronymsolutions

Hi, I have gone through your requirements and attachment as well.I am a Database developer at CMMI-5 Level company since August 2010.I am working on MS Access,MySql,SQL Server,Oracle database, I can do your job confide More

$580 AUD in 10 days
(7 Reviews)
4.0
cijagani

A proposal has not yet been provided

$526 AUD in 20 days
(7 Reviews)
3.7
dipakmoliya

I have been in this industry for 6 years and such jobs are my daily practice. This is my first time on this site and hence you can see that I have only 5 ratings/feedback to show you. More

$444 AUD in 10 days
(5 Reviews)
3.2
anomanpk

Hi, I am very much interested in your project. I am in IT profession for more than seven Years. I have done a lot of projects in different languages and databases. Recently, i developed a bid Financial Applicatio More

$555 AUD in 10 days
(2 Reviews)
2.4
logu85

Hi I am expert in Access forms and reports, i have been Designing database for last 4 years. I Have done couple of MS access projects in freelancer review my portfolio for reference. I can change the footer and subm More

$250 AUD in 5 days
(1 Review)
1.8
swarm22

Dear Sir, I have +5 year experiences in ms access database development. To Provide Quality, Modular , Result Oriented Work. Thanks & Regards HGDumaswala

$555 AUD in 10 days
(1 Review)
1.8
dogradiwakar

A proposal has not yet been provided

$722 AUD in 10 days
(2 Reviews)
1.7
chaitumv

A proposal has not yet been provided

$555 AUD in 10 days
(0 Reviews)
0.0
aldoparducci

La propuesta todavía no ha sido proveída

$750 AUD in 20 days
(0 Reviews)
0.0
emmanuelolusola

I'm a database administrator with nine years experience in deploying solution with various relational databases of which access is included. I have at some points deployed solutions with pure Ms Access i.e. designed th More

$555 AUD in 10 days
(0 Reviews)
0.0
ayanjit

Hi, I have gone through your descriptions and attachment as well. I am 5+ years experienced Visual Basic,VB.NET,ASP.NET,MS Access,MySQL,SQL,SQL Server(2005 to On wards) developer at CMMI-5 level company.I can do your j More

$410 AUD in 10 days
(0 Reviews)
0.0
ralftoth

Dear Sir or Madam, I have tested your requirements and found a way to do this programmatically. This means the quality of the result will be much better than if anyone does it manually. My code deletes the old contr More

$388 AUD in 3 days
(0 Reviews)
0.0
zakirahmouni

Hello, Can do it programmatically, can you provide the two new footers in order to test Kind regards Zaki RAHMOUNI

$555 AUD in 2 days
(0 Reviews)
0.0