Em Andamento

database search

I have made a database in vb6 using adodc code. The database must be able to search the ID field for a 5 number ID, must be able to search the last name field "LastName" for the last name, must be able to search the address "DeliveryAdd", city "City", state "State" fields to find a record by the address. The address, city, state search must include only one field, two of these fields or all three. The database is an access database.

Here is the form_load code

Private Sub Form_Load()

Dim db As Connection

Set db = New Connection

[url removed, login to view] = adUseClient

[url removed, login to view] "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=" & [url removed, login to view] & "\[url removed, login to view];"

Set adoPrimaryRS = New Recordset

[url removed, login to view] "select AllTimeAmt,AmtThisYear,Barcode,City,DateEntered,DateGiven,DeliveryAdd,DonationAmt,FirstName,FullName,HomePhone,ID,LastName,Note,SecondAdd,State,ThirdAdd,WPhone,Zip from Donor Order by LastName", db, adOpenStatic, adLockOptimistic

Dim oText As TextBox

'Bind the text boxes to the data provider

For Each oText In [url removed, login to view]

Set [url removed, login to view] = adoPrimaryRS

Next

mbDataChanged = False

End Sub

## Deliverables

1) Complete and fully-functional working search program in vb6 code form.

2) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site).

## Platform

The final product which I am building will be compiled on a Windows ME machine. ie 32 bit windows.

Habilidades: Processamento de Dados, Engenharia, Microsoft, Microsoft Access, MySQL, PHP, Arquitetura de software, Teste de Software, Visual Basic, Área de trabalho do Windows

Ver mais: open.mdb, find and search in php code, zip code search, visual search, search zip code, database building 2, php connection select, name search number, search open source code, recordset, barcode order app, database connection php, access database text, state machine, search next, order barcode, database connection, barcode product database, windows database app, city state zip database, windows app database, record vb6, order form connection php, code code database, php form search database

Acerca do Empregador:
( 16 comentários ) United States

ID do Projeto: #2993582

Premiar a:

praveenmenonvw

See private message.

$17 USD em 7 dias
(88 Avaliações)
5.7

16 freelancers are bidding on average $12 for this job

agiletechvw

See private message.

$12.75 USD in 7 dias
(36 Comentários)
6.5
mziconsultinginc

See private message.

$8.5 USD in 7 dias
(84 Comentários)
6.3
frameworkte

See private message.

$4.25 USD in 7 dias
(95 Comentários)
5.4
sreeyavw

See private message.

$8.5 USD in 7 dias
(31 Comentários)
5.1
safenet4allinc

See private message.

$15.3 USD in 7 dias
(22 Comentários)
4.8
rubesvw

See private message.

$17 USD in 7 dias
(13 Comentários)
4.1
luaihusaria

See private message.

$8.5 USD in 7 dias
(11 Comentários)
3.8
stolevw

See private message.

$8.5 USD in 7 dias
(28 Comentários)
2.6
motr

See private message.

$17 USD in 7 dias
(3 Comentários)
0.0
kaushalpatel

See private message.

$12.75 USD in 7 dias
(0 Comentários)
0.0
mcure

See private message.

$17 USD in 7 dias
(0 Comentários)
0.0
srivastavavw

See private message.

$12.75 USD in 7 dias
(0 Comentários)
0.0
pairpair

See private message.

$12.75 USD in 7 dias
(0 Comentários)
0.0
candinutzu

See private message.

$12.75 USD in 7 dias
(0 Comentários)
0.0
jeffchilvw

See private message.

$8.5 USD in 7 dias
(0 Comentários)
0.0