In Progress

VBA - Adding Data via Auto Counter & Exporting Data

You will be working with a 2003 MS Access database. Your goals for this project will be as followed. More detailed instructions will be given upon starting the project. You will also be required to be able via IM chat to discuss questions and problems that may arise.

1. You will need to create a counter that pulls the number to start with for the counter from a text file that you will create and store on the root of the C drive (C:). So each time your code runs it will look at the text file located at C:[url removed, login to view] and starts the counting process from that number. Once the code completes it will need to remove that number from the text file and put the number that would be next on the counter in that text file. If the file exists already it should just grab that number and start the counter process.

2. You will use that counter to replace the IDs that are located in the files. Not all files have an ID column so it will be your job to create a column that will appear in column D pushing the other columns to the right.

a. For example your code will start the process on the first table and find out what number it should start with from the text file. It will then check to see if the table has a column named ID if it doesn’t then it will create it in Column D pushing the other columns right. It then will implement the counter starting with the number in the text file and adding one for the records in the table. It then will proceed to the next table and do the same thing but starting the counter with the number that would be next in the counting process.

3. You then will use the relationship tables and replace the Name field with the matching ID for that record.

4. Once this step is complete you will copy the IDs into name fields for specific tables that I tell you to.

a. For example Table C will need have to have the name column and the ID column with the same matching ID.

5. Once step 4 completes you will need to code a procedure that will jump into the relationship files and replace the Name field with the matching ID for that record that you created in step 4.

6. You then will extract certain tables and queries (which we will tell you) into a folder called Data that is stored on the C: drive.

7. Close Access

Skills: .NET, Excel, Visual Basic, Windows Desktop

See more: vba counter, counter vba, access vba counter, counter access vba, create counter vba, vba counter code, auto counter, laura miller vba, vba laura miller, access auto counter, working first data, vba with, starting visual basic, starting visual basic net, find problems, create counter data report, counter visual basic applications, access counter vba, access add counter data, check file exists vba, day auto counter, acess counter, view counter vba, add text automatic, vba code count data

About the Employer:
( 10 reviews ) Fort Collins, United States

Project ID: #233764

Awarded to:

safonty

Hello ! Ready to work with you again. Sent e-mail. Vladislav

$150 USD in 4 days
(6 Reviews)
3.6

18 freelancers are bidding on average $139 for this job

HussienSharaf

HI, i m the best VBA MS Access developer plz check PM thanks

$230 USD in 3 days
(59 Reviews)
6.9
svet63

VBA developer since 1997. Can do. (IM available). Regards, Svet.

$130 USD in 3 days
(76 Reviews)
6.6
JavaBeau

Let's start:) Please check PMB.

$125 USD in 2 days
(9 Reviews)
3.8
msoftsolution

Hi, i can do it

$70 USD in 2 days
(4 Reviews)
3.5
samareshmandal

I am excelent Visual Basic Developer, So you faith on me and test.

$180 USD in 3 days
(3 Reviews)
2.8
MsVBA

Greetings! A detailed bid has been submitted via PM. I look forward to working with you! Thanks! Laura Miller (aka Ms. VBA)

$90 USD in 1 day
(2 Reviews)
2.5
grossekathoefer

German VB developer can do that.

$90 USD in 3 days
(1 Review)
2.0
Iric

I can easily do this job for you. About our company, we are based out of Sacramento, CA and we have an offshore data processing and development center which, when combined with our team here, can produce just the right More

$150 USD in 3 days
(1 Review)
1.7
Dilip1981

Hi, I am ready to take your assignment. Regards, Dilip

$225 USD in 5 days
(0 Reviews)
0.0
psrwat

yes i can do that for you..plz see PM

$200 USD in 5 days
(0 Reviews)
0.0
ramsam624824

I am doing projects in home for a leading VB Software development company in chennai for 3 years . So i can easily grasp your idea and deliver the project in quick turn around

$100 USD in 3 days
(0 Reviews)
0.0
kamrajkmri

Sir, I can do this job so please find my bid and send reply. kamaraj

$50 USD in 7 days
(0 Reviews)
0.0
durgadas

i am confident that i can mke it easily.

$35 USD in 2 days
(0 Reviews)
0.0
igensol1

check your PM.

$250 USD in 5 days
(0 Reviews)
0.0
basilis

Your job will done. comments will be added to code. Looking forward for future cooperation as well.

$100 USD in 3 days
(0 Reviews)
0.0
sadikhanmail

Hello. I can do it for you.

$100 USD in 3 days
(0 Reviews)
0.0
znwodi

I'm very familiar with VBA,Please PM me for further information.Excellent job is ready for you. regards!

$220 USD in 15 days
(0 Reviews)
0.0