Access VBA Macro to populate data in a table

$10-30 AUD

Finalizat

Data postării:

circa 6 ani în urmă

$10-30 AUD

Plata la predare

Hi I need help writing a Macro (VBA) in access that can populate (add data) into a table. The macro should add 1000 rows The columns are: 1. ID (just increase after each one) 2. Date1 random date between two dates is selected 3. Name random name from a set list. I don't want it done in excel or other software must be VBA access macro. to make it easier to select please start your offer with word Macro.

Microsoft Access

Visual Basic

Visual Basic for Apps

ID-ul proiectului: 16750876

Despre proiect

6 propuneri

Proiect la distanță

Activ: 6 ani în urmă

Vrei să câștigi bani?

Adresa de e-mail

Avantajele de a licita pe platforma Freelancer

Stabilește bugetul și intervalul temporal

Îți primești plata pentru serviciile prestate

Evidențiază-ți propunerea

Te înregistrezi și licitezi gratuit pentru proiecte

Acordat utilizatorului:

@VladimirLilenko

Hello, dear sir! I registered at the forum not so long ago, but I already have several completed projects on www.freelancer.com. I am ready to carry out your project in the reasonable price and in the shortest possible time and with the highest quality! From the Microsoft Access and vba, of course, familiar. Give me a chance to show what I can do!

$20 AUD în 0 zi

4,9

(86 recenzii)

6,0

6 freelanceri plasează o ofertă medie de $26 AUD pentru proiect

@The24CarrotsInc

Greetings for the day!! We have experience working on this subject. We ensure 100% QUALITY with ON-TIME Deliveries. Please allow us to take this opportunity. Thanks & Regards, Team@The24CarrotsInc VBA/EXCEL 100% Satisfaction Of Deliverable

$25 AUD în 1 zi

4,9

(32 recenzii)

5,1

@katiewells3

Macro. I am a technical business analyst with over 15 years experience building solutions with Access, SQL, and VBA. What you are after sounds very achievable by using a loop to generate a series of random numbers. E.g. set the start date as a variable, generate a random number between 0 and the number of days between the start and end date, add the number to the start date; generate a second random number between 1 and the number of names on the list and enter the name in that position as the record. Iterate one thousand times while inserting. Question - does the ID need to be generated by the macro or can it be set using the automnumber feature of the table? If you are running multiple times then this will dadd some complexity as the macro will need to fetch the largest ID from the table to ensure there are no duplicates. Would love to chat further on this! Cheers, Katie

$30 AUD în 1 zi

5,0

(6 recenzii)

3,5

@huongth

Macro. Hi. I am an expert in VBA, VBScript, Visual Basic, C#, F#, C, C++, ASM, Delphi, Java, iMacros, Flash, ASP, ASP.NET, Access, MySQL, MSSQL, QuickBooks, Oracle. I can create auto scripts to scrape websites, auto click, format txt, csv, xls, xlsx, doc, docx, rtf, json, xml, database files as you request

$30 AUD în 1 zi