Em Andamento

VB code - MS Access Class Object

This project involves writing VB code for use in an MS Access Class Object Module. The version of MS Visual Basic is 6.5 and the version of MS Access is 2007. The purpose of the project is to link to tables in one mdb file and append data to tables in the a master database. I have one master access database set up with a certain schema. I have many other access files with tables that I need to link to. The access files are all in the same parent directory. The master database is in the parent directory and each of the other access files are in a separate subfolder in the parent directory. The mdb files to link to all have the same file name ([url removed, login to view]). I need code for a button on a form in the master database to loop through all of the subfolders in the main directory and find a file with a certain file name ([url removed, login to view]). Then, for each file that it finds in the subfolders, I need to delete the current linked tables in the master database, link the 4 tables from the file in the subfolder ([url removed, login to view]) to the master database and run 3 append queries. It would repeat this process until it finds the last file in the last subfolder and display a message that the process is complete. For all records that are appended to the three tables that the append queries modify, I would like a file index assigned to them. This number would be unique for each [url removed, login to view] file in each subfolder. This file index would be written to the file index field for all records appended in the 3 tables that the append queries modify. The file index value needs to be an integer. For example, for the first [url removed, login to view] file there is one record appended to the StandIP table, 3 records appended to the PlotIP table, and 15 records appended to the TreeIP table. For all records appended to these tables for this file I would like a file index of 1 assigned to these records in the file index field of these tables. The [url removed, login to view] file in the next subfolder has one record appended to the Stand IP table, 2 records appended to the PlotIP table, and 10 records appended to the TreeIP table. For all records appended to these tables for this file I would like a file index of 2 assigned to these records in the file index field of these tables. And so on, assigning a unique number for each file in the run.

Habilidades: Engenharia, Microsoft Access, MySQL, PHP, Gestão de projetos, Arquitetura de software, Teste de Software

Ver mais: writing in code, object writing, ms access with php, mdb files, code writing, access database module, php is object, project management access, object, ms access, in process access, code name one, access delete, visual basic delete access, object form, modify access, append display, access append, access linked table, loop table, access 2007 linked table, writing code, code database access, unique index access 2007, access database process

Acerca do Empregador:
( 1 comentário ) United States

ID do Projeto: #3050889

Premiar a:

ricks7

See private message.

$97.75 USD em 14 dias
(94 Avaliações)
5.3

8 freelancers estão ofertando em média $83 para este trabalho

maramayvw

See private message.

$85 USD in 14 dias
(97 Comentários)
5.6
codedeveloperin

See private message.

$34 USD in 14 dias
(35 Comentários)
5.0
farhanshahid

See private message.

$85 USD in 14 dias
(1 Comentário)
0.5
alanwarren

See private message.

$34 USD in 14 dias
(0 Comentários)
0.0
ijazaziz

See private message.

$102 USD in 14 dias
(0 Comentários)
0.0
VLVawter

See private message.

$170 USD in 14 dias
(0 Comentários)
0.0
greatkoders

See private message.

$59.5 USD in 14 dias
(1 Comentário)
0.0