Upgrade Access 2003 Report
Budget: $250 – $750 USD
I have an ageing Microsoft Access 2003-based .mdb that still runs fine, but one of its key reports now has to pull data from a set of CSV files that arrive weekly. The existing report logic and its VBA behind-the-scenes obviously know nothing about these new layouts, so the job is to retrofit the report so it recognises the incoming tables, maps the fields correctly, and continues to render exactly the output my users already expect.
Here is the current picture:
• Database format: native Access 2003, with VBA modules and a handful of saved queries that feed the report.
• New data source: flat CSV files, one per table. They replace what used to be manually keyed tables, so the field names and sometimes even the data types differ slightly.
• The report: a single multi-section Access report that groups, totals and colour-codes results. Nothing in the visual layout needs redesign; only the underlying queries and any VBA that references the old tables must be adjusted.
What I need from you:
1. Link or import the CSV files in a way that keeps refresh simple (I am open to linked tables, a small import routine, or a hybrid approach you suggest).
2. Update or rewrite the queries and related VBA so the report runs error-free against the new table structures.
3. Leave the report’s front-end look identical unless a small tweak is required to accommodate the new data.
4. Provide a brief, step-by-step note so I can repeat the import/link process when new CSVs arrive.
Acceptance criteria:
• Opening the database and pressing the existing “Run Report” button produces the same formatted report, populated entirely from the CSV-backed tables, with no missing or mis-mapped fields.
• No compile or runtime errors in VBA.
• All code changes clearly commented.
If you have solid VBA skills and have wrestled with old-version Access projects before, this should be a straightforward lift. Let me know any clarifications you need and a realistic turnaround time, and we can get started right away.
Here is the current picture:
• Database format: native Access 2003, with VBA modules and a handful of saved queries that feed the report.
• New data source: flat CSV files, one per table. They replace what used to be manually keyed tables, so the field names and sometimes even the data types differ slightly.
• The report: a single multi-section Access report that groups, totals and colour-codes results. Nothing in the visual layout needs redesign; only the underlying queries and any VBA that references the old tables must be adjusted.
What I need from you:
1. Link or import the CSV files in a way that keeps refresh simple (I am open to linked tables, a small import routine, or a hybrid approach you suggest).
2. Update or rewrite the queries and related VBA so the report runs error-free against the new table structures.
3. Leave the report’s front-end look identical unless a small tweak is required to accommodate the new data.
4. Provide a brief, step-by-step note so I can repeat the import/link process when new CSVs arrive.
Acceptance criteria:
• Opening the database and pressing the existing “Run Report” button produces the same formatted report, populated entirely from the CSV-backed tables, with no missing or mis-mapped fields.
• No compile or runtime errors in VBA.
• All code changes clearly commented.
If you have solid VBA skills and have wrestled with old-version Access projects before, this should be a straightforward lift. Let me know any clarifications you need and a realistic turnaround time, and we can get started right away.