Microsoft Access: Search function and changes

In Progress

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.

Skills: Visual Basic

See more: 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

About the Employer:
( 4 reviews ) Kerry, Ireland

Project ID: #183958

Awarded to:

Kingpin1962

Kindly check PMB. Thanks...

$70 USD in 3 days
(3 Reviews)
3.8

14 freelancers are bidding on average $70 for this job

wsh2

"we would like to build is a detailed search function".. This is a small change? Respectfully, if you ever speak to anyone very experienced in programming.. they will tell you.. "The first 90% of the code is 10% of More

$99.95 USD in 3 days
(19 Reviews)
5.2
KellogITSolution

Hello Plz check ur PMB for my bid. Thanks

$40 USD in 3 days
(12 Reviews)
4.3
rudyos

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 in 1 day
(3 Reviews)
3.8
momleetech

we can do it

$70 USD in 5 days
(8 Reviews)
3.7
guolibin

hi,please see PMB.

$70 USD in 2 days
(6 Reviews)
3.4
rajneeshag

Hello Sir, Lets start

$60 USD in 2 days
(1 Review)
2.4
alekseymihalych

Hi need to see your app first.

$85 USD in 10 days
(2 Reviews)
0.3
Suddashil

give me the project. i will complete it.

$70 USD in 2 days
(0 Reviews)
0.0
vibielova

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

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

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 More

$100 USD in 5 days
(0 Reviews)
0.0
aarmom

VB veteran and can take this up with ease

$75 USD in 4 days
(0 Reviews)
0.0
tabaqchali

..............

$50 USD in 8 days
(0 Reviews)
0.0
bratvl

1 Day 65$ (best)

$65 USD in 1 day
(0 Reviews)
0.0