VBA for Access Database

I have a Microsoft Access Database which I inhireted from a previous co-worker who left the company, and that database is built in a rather complex way that I am not interested in reverse engineer the whole thing.

my first challenge is the sensitivity of the data, therefore working with the real database will not be possible, all work should be done in a simulated environemnt which I can later on adapt to the database itself.

The database I have is a huge combination of tales, forms, reports, queries and macros, and there is one specific macro which I would like to automate.

to describe a bit about the process, when opening the database, a search function is used to find the correct "project", each project has a unique MSAccess ID and Business Order ID. under that project page many sub-applications are there, when selecting the Reporting Application (which is basically a query) the interface is now tagged with the project ID, report number (auto ascending) and so on. one specific button in that reporting section allows printing all project reports as PDF (5 reports for the project that is already open).

that button is simply running a macro, the properties of the macro and the button coding can be shared with whomever is going to work on this.

Taking in consideration that I have around 300 projects, I need a macro to run, which can generate these 5 PDFs and merge them, that macro should by dynamic to enable me selecting certain projects based on business Order ID number, (which corresponds to one single MSAccess unique ID)

some additional info:

when running the macro from outside (without selecting a specific project) I am asked to submit the Business Order Number, and the Report sequencial Number.

in case the VBA will be built in Microsoft Excel as a third party, the project database path should be dynamic, not hard coded

The output path of the reports should be dynamic,

it would be of a high importance that the extracted 5 reports of each project are actually merged into one PDF in a certain order.

more information can be provided during discussions

Skills: Microsoft Access, SQL, Database Programming, Visual Basic, Excel

See more: create report template via vba access database, generate access database, generate powerpoint slide access database, use vba read spreadsheet access database, access vba copy database, importing excel file access database excel vba, export excel file access database excel vba, vba open access database, access database microsoft project using vba, vba access database multiple users, csv access database vba code, vba access database counter type, vba access database import, vba access database interactive inventory, interface excel vba access database, email vba access database, object oriented programming vba access database, vba access database

About the Employer:
( 0 reviews ) Norrköping, Sweden

Project ID: #22216567

20 freelancers are bidding on average $9/hour for this job


Hello dear sir! I am ready to carry out your project in the reasonable price and in the shortest possible time and with the highest quality! You can read reviews about my work at: More

$8 USD / hour
(200 Reviews)

Hi, Let me introduce myself as an expert in MS Access programming. I have worked extensively on MS Access 97,2000, 2003, 2007,2010,2013, 2016 projects both big and small using MS Access as a front end as well as back More

$15 USD / hour
(141 Reviews)

Hi, Would you like to see a quick demo of your project on writing a macro in MS Access that will dynamically enable you to select certain projects based on business Order ID number and then generates 5 reports in PDF f More

$8 USD / hour
(55 Reviews)

Hi, I am a professional MS Access and SQL server database developer. I am developing MS Access database since 2010 and have excellent command in all versions. I can provide you best support on your project. Please pin More

$20 USD / hour
(32 Reviews)

Hi, I read project description and understood it. I'm MSAccess expert. I developed many applications using MSAccess and VBA. Looking forward to work with you. Regards

$8 USD / hour
(23 Reviews)

Hi there, I read your requirements and understand very-well and ready to start work from now. Hope you give me a chance to do work with you. I hope you will be kind enough to consider me for your [login to view URL] forw More

$5 USD / hour
(25 Reviews)

Respected Sir, Greetings of the Day ! I am Udal Bharti. I have 9+ years of competitive experience in web application development using .net and SQL server. I have 7+ years of experience in Database development & More

$6 USD / hour
(3 Reviews)

Hi, Thanks for sharing your requirements here. I’m an Experienced Freelancer with a demonstrated history of working in the internet industry. Skilled in Core PHP, MySQL, HTML, CSS, JQuery, JavaScript. I have worked m More

$8 USD / hour
(1 Review)

I have 20 years in Database Developing, administration, Programming, System Analysis, Data Analysis using Ms. Access, Ms. Excel, VBA, VB6,, C#, SQL, SQL/PL SQL, and MS SQL Server

$8 USD / hour
(6 Reviews)

Hello Client, I am VBA expert with 5+ year experience. I have good experience of lots of project in excel,access,outlook,word,power point, web scraping, manipulate data, linking to SQL Server and read data from PDF More

$3 USD / hour
(4 Reviews)

Hello Sir, I am the same freelancer for which you are looking and I am feeling happy to say that I am  having  5+ exp in website design/development, WordPress  and I love to serve my skills in this project, So please h More

$5 USD / hour
(1 Review)

I can do it

$5 USD / hour
(0 Reviews)

Dear Hiring Manager, Greetings from me. I read Your Job description and Understood.. Iam very confident that I can complete this task with perfection under minimum supervision. I can do it 99% Accurate. As I am a st More

$5 USD / hour
(0 Reviews)

Dear Hiring Manager, I am an Oracle Certified Database Professional (OCP). I have complete masters in computer science. I am a database professional with 15 years’ experience. My background includes Sql, MySQL, Pl Sql, More

$5 USD / hour
(2 Reviews)

Hi, I have more than 12 years experience working with vba and access. Let me help you with this problem

$3 USD / hour
(0 Reviews)

Sounds like a challenge, unpicking someone else's code is always fun. An option could be to create a new app alongside the existing app replicating various functions as you go, I'd be very interested

$5 USD / hour
(0 Reviews)

Hello sir, I'm an expart in data processing excell sheet & ms word frofessional data handling and interpretation with high typing skill. Accuracy my watchword will adequately input your data with Thank you.

$5 USD / hour
(0 Reviews)

Virtual Assistance: Administration, editing and designing of logo’s, catalogue pictures, website designing, social media designing and maintaining. Data Capturing. Data Script Assessing of systems.

$5 USD / hour
(0 Reviews)

Hello there; I have 25 years experience with databases including 18 years in Access 2000-2016, Excel, Sybase, MS SQL 2008-2014, AirTable Web-based database, ODBC connection, QODBC connection to QuickBooks, Lotus Conv More

$30 USD / hour
(0 Reviews)

Hello, I have a BEng in Software Engineering and experience of working with Access and VBA. I can also comment the code so it is easier to follow and add to the live database.

$15 USD / hour
(0 Reviews)