VBA for Access Database

Chiuso Pubblicato 4 anni fa Pagato alla consegna
Chiuso

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

Microsoft Access SQL Programmazione Database Visual Basic Excel

Rif. progetto: #22216567

Info sul progetto

19 proposte Progetto a distanza Attivo 4 anni fa

19 freelance hanno fatto un'offerta media di $9/ora per questo lavoro

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 Altro

$8 USD / ora
(228 valutazioni)
7.0
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 Altro

$8 USD / ora
(60 valutazioni)
6.6
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 Altro

$15 USD / ora
(170 valutazioni)
6.7
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 Altro

$20 USD / ora
(37 valutazioni)
5.8
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 / ora
(24 valutazioni)
4.9
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 & Altro

$6 USD / ora
(4 valutazioni)
4.2
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 Altro

$8 USD / ora
(2 valutazioni)
3.7
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 / ora
(6 valutazioni)
2.7
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 Altro

$3 USD / ora
(4 valutazioni)
1.9
va2goline

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 / ora
(0 valutazioni)
0.0
tibanafernando

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

$3 USD / ora
(0 valutazioni)
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 Altro

$5 USD / ora
(0 valutazioni)
0.0
anandrathod3330

I can do it

$5 USD / ora
(0 valutazioni)
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 / ora
(0 valutazioni)
0.0
GKEvans

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 / ora
(0 valutazioni)
0.0