Access VBA Macro to populate data in a table

$10-30 AUD

Suoritettu

Julkaistu

noin 6 vuotta sitten

$10-30 AUD

Maksettu toimituksen yhteydessä

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

Projektin tunnus (ID): 16750876

Tietoa projektista

6 ehdotukset

Etäprojekti

Aktiivinen 6 vuotta sitten

Haluatko ansaita rahaa?

Sähköpostiosoite

Freelancerin tarjouskilpailun edut

Aseta budjettisi ja aikataulu

Saa maksu työstäsi

Kuvaile ehdotustasi

Rekisteröinti ja töihin tarjoaminen on ilmaista

Myönnetty käyttäjälle:

@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 0 päivässä

4,9

(86 arvostelua)

6,0

6 freelancerit tarjoavat keskimäärin $26 AUD tätä projektia

@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 1 päivässä

4,9

(32 arvostelua)

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 1 päivässä

5,0

(6 arvostelua)

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 1 päivässä