Fermé

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

Compétences : Microsoft Access, SQL, Programmation de bases de données, Visual Basic, Excel

en voir plus : 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

Concernant l'employeur :
( 0 commentaires ) Norrköping, Sweden

Nº du projet : #22216567

24 freelance font une offre moyenne de $8/heure pour ce travail

VladimirLilenko

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 Plus

$8 USD / heure
(174 Commentaires)
6.7
dvcontact

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 Plus

$8 USD / heure
(49 Commentaires)
6.4
finecodervw

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 Plus

$15 USD / heure
(105 Commentaires)
6.1
VBAautomation

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 Plus

$20 USD / heure
(32 Commentaires)
5.3
MHassanBedor

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 / heure
(19 Commentaires)
4.3
udalsoft

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

$6 USD / heure
(3 Commentaires)
3.6
ravinderkumar248

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 Plus

$5 USD / heure
(6 Commentaires)
3.0
NoSonforhim

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 / heure
(5 Commentaires)
2.5
achievers24

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 Plus

$8 USD / heure
(1 Évaluation)
2.6
Alexsfodik

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 / heure
(2 Commentaires)
2.2
Alka700

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 Plus

$5 USD / heure
(1 Évaluation)
1.8
databasedba

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

$5 USD / heure
(1 Évaluation)
0.0
Gkondylis

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

$8 USD / heure
(0 Commentaires)
0.0
vedaeeff68

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 Plus

$30 USD / heure
(0 Commentaires)
0.0
pmortlsl

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 / heure
(0 Commentaires)
0.0
anandrathod3330

I can do it

$5 USD / heure
(0 Commentaires)
0.0
mintu1302k

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 Plus

$3 USD / heure
(0 Commentaires)
0.0
ShubhamPardhi

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 Plus

$5 USD / heure
(0 Commentaires)
0.0
freelance2498

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 Plus

$5 USD / heure
(0 Commentaires)
0.0
marijabozazivano

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 Plus

$5 USD / heure
(0 Commentaires)
0.0