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

Evner: Microsoft Access, SQL, Programmering af database, Visual Basic, Excel

Se mere: 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

Om arbejdsgiveren:
( 0 bedømmelser ) Norrköping, Sweden

Projekt ID: #22216567

24 freelancere byder i gennemsnit $8/time for dette 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: https://www.freelancer.com/u/VladimirL Flere

$8 USD / time
(173 bedømmelser)

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 Flere

$8 USD / time
(49 bedømmelser)

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 Flere

$15 USD / time
(105 bedømmelser)

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 Flere

$20 USD / time
(32 bedømmelser)

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 / time
(19 bedømmelser)

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 & Flere

$6 USD / time
(3 bedømmelser)

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

$8 USD / time
(5 bedømmelser)

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 Flere

$8 USD / time
(1 bedømmelse)

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 Flere

$5 USD / time
(4 bedømmelser)

Hello. How are you. I'm software engineer and algorithm expert. I have many experiences in Access, Excel, VBA. I can complete your project successfully. Thanks.

$5 USD / time
(1 bedømmelse)

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 Flere

$5 USD / time
(1 bedømmelse)

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, Flere

$5 USD / time
(1 bedømmelse)

I have more than 12 years of exeprience in automatic business processes using tools like MS Access, Excel and VBA.

$8 USD / time
(0 bedømmelser)

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 Flere

$30 USD / time
(0 bedømmelser)

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 / time
(0 bedømmelser)

I can do it

$5 USD / time
(0 bedømmelser)

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 Flere

$3 USD / time
(0 bedømmelser)

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 Flere

$5 USD / time
(0 bedømmelser)

Hello, Look no further, and feel free to contact us. Our team will try our best effort to provide a great solution and whats more if we hired you'll definitely receive outstanding result before the project deadline Flere

$5 USD / time
(0 bedømmelser)

I'm working on computer related jobs for the last 7 years. I am very professional. I always meet the expectations of my employer. I am very trust worthy and skilled worker. I always make sure to submit my work on or b Flere

$5 USD / time
(0 bedømmelser)