Microsoft Access: Search function and changes

This project is a small project that requires some minor fixes to an existing project. The database is 90% complete but needs an experienced developer to make a number of changes. The following changes will need to be made to the project.

A button which does the following will need to be added.

• It will automatically generate a new project identifier (this is not the primary key the primary key is a separate auto number field) for the record this will be a combination of the year and the next consecutive number.

• MsgBox “ The corresponding file structure has been created”

• When a new record is created a new file directory using the mkdir statement is created

• This directory will consist of a new folder containing the new job number and a job description and six sub folders( the names of these sub folders will be hard coded as they never change)

In addition some small changes are need –

• Ensuring the information on sub forms and sub tabs is the correct information for the record. There is only the one main form which consists of two tabs but the information on the second tab does not correspond correctly.( This will become apparent once you see the forms

• An event log which is tracking changes to textboxes needs to be changed so that it tracks changes to drop down menu’s as well

The other feature we would like to build is a detailed search function which can search through a number of free text fields (text and memo) for relevant values and return a list of records that match these. If you are capable of building the search function, it would be good if you could attach a quick note on how you would build the search function.

This project needs to be completed ASAP. If you have previously built a search function in access and can re-use the code that would be ideal.

Habilidades: Visual Basic

Veja mais: access search function, access find function, search function access, access search, microsoft access search function, search function microsoft access, function search access, microsoft access find function, create search function access, microsoft access database search function, microsoft access search, auto search function access, visual basic developer job, search we, search in code, primary job, one tabs, number function, microsoft number, microsoft access job, microsoft access database developer, job values, ideal job, function number, developer search

Acerca do Empregador:
( 4 comentários ) Kerry, Ireland

ID do Projeto: #183958

Concedido a:


Kindly check PMB. Thanks...

$70 USD em 3 dias
(3 Comentários)

13 freelancers estão ofertando em média $67 para esse trabalho


Hello Plz check ur PMB for my bid. Thanks

$40 USD in 3 dias
(13 Comentários)

Hello, I have years of experience with VB/VBA and can complete your database quickly. Regarding the search function, I have done many in VB wherefrom I'm sure the code can be reused. Regards

$70 USD em 1 dia
(2 Comentários)

we can do it

$70 USD in 5 dias
(8 Comentários)

hi,please see PMB.

$70 USD in 2 dias
(6 Comentários)

Hello Sir, Lets start

$60 USD in 2 dias
(1 Comentário)

Hi need to see your app first.

$85 USD in 10 dias
(2 Comentários)

VB veteran and can take this up with ease

$75 USD in 4 dias
(0 Comentários)

1 Day 65$ (best)

$65 USD em 1 dia
(0 Comentários)


$50 USD in 8 dias
(0 Comentários)

Hello, Using my over 8 years experience in building MS Access applications, I would like to offer my services to help you with your project. Regarding the search capability, there are a couple of options: use the MS Mais

$100 USD in 5 dias
(0 Comentários)

give me a chance..i can do it..

$50 USD in 7 dias
(0 Comentários)

give me the project. i will complete it.

$70 USD in 2 dias
(0 Comentários)