VB/Access - Updatable Grid With Parameter Query

Suoritettu Julkaistu Jul 5, 2002 Maksettu toimituksen yhteydessä
Suoritettu Maksettu toimituksen yhteydessä

***CODER SKILL TESTING QUESTION (NEWLY ADDED)*** I have had several bidders who do not seem to fully grasp the problem as outlined below, so I would like to make sure you know what I want. Read the description below and if you can answer this question correctly, I will consider your bid. Q: Using the database I supplied, and assuming you have written your code correctly, when I run the program and I select '1002' from the pulldown, how many records are there, and what are the values of 'Part Number' and 'Qty' displayed for each row? ************************************************ I have a few problems with my application that I need expert help with. I have created a simple relational database and a form to display some info. I have set up 2 queries in Access, the first(qryCustInv) is a parameter query which is based on 1 table(CustInv). The second(qryCustInvJoin) is based on 1 table(Parts) left joined with the first query(qryCustInv). In Access, you can use table view of the qryCustInvJoin to add/modify/delete records, which will in turn affect the appropriate rows in CustInv or Parts (depending on the changes). I want a visual basic form which will connect to this database and provide the same functionality as table view of qryCustInvJoin. This form needs a pulldown menu which gets populated on the form load event with the Customer Numbers from the Customers table. When the user selects a number from this pulldown, a grid is populated with the results of qryCustInvJoin providing the selected Customer Number as the parameter. I am including the access database, as well as a partially completed vb project (you will see within it some attempts I have made to make it run). I only need someone to finish this simple app. This should be very easy money for someone familiar with vb6 and database programming. If you do a good job, there may be followup work, as this is only a small piece of a larger project.

## Deliverables

This must be done in straight code, using ADO. No controls should be used for data access. Coding work you do must be well documented, and efficient, and must not use any libraries not supplied with VB6 Enterprise. Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. Complete copyrights to all work purchased.

## Platform

VB6, Access97, ADO

## Deadline information

You must answer the skill testing question above, or demonstrate with a sample program that your code will do what I want.

Tietokannan hallinto tekniikka MySQL PHP Tietojärjestelmäarkkitehtuuri Ohjelmistojen testaus SQL Visual Basic

Projektin tunnus: #2858895

Tietoa projektista

20 ehdotusta Etäprojekti Aktiivinen Jul 5, 2002

Myönnetty käyttäjälle:

denzaki

See private message.

$2 USD 14 päivässä
(13 Arvostelua)
2.4

20 freelanceria on tarjonnut keskimäärin $11 tähän työhön

agrasth

See private message.

$8.5 USD 14 päivässä
(107 arvostelua)
6.2
aarrsoftware

See private message.

$17 USD 14 päivässä
(33 arvostelua)
5.6
ameentj

See private message.

$17 USD 14 päivässä
(42 arvostelua)
5.1
peterdimitrovvw

See private message.

$8.5 USD 14 päivässä
(1 arvostelu)
4.4
vw139994vw

See private message.

$12.75 USD 14 päivässä
(60 arvostelua)
4.5
alokgarg

See private message.

$8.5 USD 14 päivässä
(69 arvostelua)
4.2
asadsufi

See private message.

$8.5 USD 14 päivässä
(38 arvostelua)
4.1
kenharvey

See private message.

$5.95 USD 14 päivässä
(8 arvostelua)
3.3
vw203484vw

See private message.

$17 USD 14 päivässä
(17 arvostelua)
3.3
clubpro

See private message.

$17 USD 14 päivässä
(3 arvostelua)
2.3
sephius

See private message.

$5.95 USD 14 päivässä
(5 arvostelua)
1.8
codermaniavw

See private message.

$17 USD 14 päivässä
(2 arvostelua)
0.0
ricardolavia

See private message.

$4.25 USD 14 päivässä
(3 arvostelua)
0.0
apachelephong

See private message.

$12.75 USD 14 päivässä
(0 arvostelua)
0.0
vw367898vw

See private message.

$12.75 USD 14 päivässä
(2 arvostelua)
1.9
powerrajesh

See private message.

$17 USD 14 päivässä
(0 arvostelua)
0.0
darrenadlington

See private message.

$3.4 USD 14 päivässä
(0 arvostelua)
0.0
zorrer

See private message.

$8.5 USD 14 päivässä
(0 arvostelua)
0.0
f0zzy

See private message.

$8.5 USD 14 päivässä
(0 arvostelua)
0.0