Find Jobs
Hire Freelancers

Display MS Access data in VB

$30-5000 USD

Completed
Posted over 17 years ago

$30-5000 USD

Paid on delivery
Hi there, The end product is a VB form that contains a drop-down menu, 3 text boxes and 2 command buttons. The VB form needs the following: 1 ??" The drop-down menu has to contain/display records from one MS Access database table. 2 ??" When a record is selected retrieve the details from the MS Access table and display in the text boxes. 3 ??" When details have changed save changes back to the MS Access database via a command button. 4 ??" A further command button exits the VB form. Any feedback very much appreciated… Kind Regards Michael ## Deliverables In summary only the program code in text form is required. See below for sections marked ‘Required:’ Object names are provided below and the code should use and refer to them. The following is a detailed breakdown of the main 4 items… 1 ??" The drop-down menu has to contain/display records from one MS Access database table. **Required: ** Code to connect to database, from one table retrieve data from all rows - 2 fields (ID and Name) - and populate drop-down menu ??" ID not shown (hidden) and by Name sorted. 2 ??" When a record is selected retrieve the details from the MS Access table and display in the text boxes. **Required: **Code to identify the selected record ID and based on that ID call a routine that retrieves all record details from the MS Access database table ??" which is one further field. Display the retrieved values in the text boxes. The ID is stored in a hidden text box and the Name and Amount are stored in the two other text boxes. 3 ??" When details have changed save changes back to the MS Access database via a command button. **Required: **Code for command button to save two of the three values to the MS Access database. Code has to retrieve the original record based on ID in one of the text boxes that is hidden. The values of the other two fields need saving to database. 4 - A further command button exits the VB form. **Required: **Code for command button to shut down and exit. Code should properly close connections, workspaces and databases etc ??" if not done already in above routines. **Object Names: **Drop-down menu: cboSelectClient Text box 1: txtClientID ??" hidden Text box 2: txtClientName Text box 3: txtAmount Command button 1: cmdSave Command button 2: cmdExit Database name and location: C:\[login to view URL] Table Name: tblClient Field 1: ClientID ??" Indexed: Yes (No Duplicates) - Long Integer Field 2: ClientName ??" Text Field 3: Amount ??" Currency ## Platform Development environment: Microsoft Visual Basic .NET (Microsoft Development Environment 2003) Operating system: Windows 98/Windows 2000 or XP MS Access version: 97 or later
Project ID: 3780254

About the project

89 proposals
Remote project
Active 18 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
See private message.
$12 USD in 30 days
4.9 (90 reviews)
7.3
7.3
89 freelancers are bidding on average $52 USD for this job
User Avatar
See private message.
$42.50 USD in 30 days
4.9 (284 reviews)
7.6
7.6
User Avatar
See private message.
$21.25 USD in 30 days
5.0 (213 reviews)
7.3
7.3
User Avatar
See private message.
$29.75 USD in 30 days
4.9 (99 reviews)
6.6
6.6
User Avatar
See private message.
$34 USD in 30 days
4.7 (277 reviews)
6.8
6.8
User Avatar
See private message.
$42.50 USD in 30 days
5.0 (51 reviews)
5.9
5.9
User Avatar
See private message.
$51 USD in 30 days
5.0 (90 reviews)
5.9
5.9
User Avatar
See private message.
$42.50 USD in 30 days
5.0 (71 reviews)
5.8
5.8
User Avatar
See private message.
$12.75 USD in 30 days
5.0 (74 reviews)
5.2
5.2
User Avatar
See private message.
$5.10 USD in 30 days
4.9 (60 reviews)
5.1
5.1
User Avatar
See private message.
$8.50 USD in 30 days
4.8 (27 reviews)
5.4
5.4
User Avatar
See private message.
$42.50 USD in 30 days
4.9 (17 reviews)
5.0
5.0
User Avatar
See private message.
$17.85 USD in 30 days
4.9 (45 reviews)
4.9
4.9
User Avatar
See private message.
$11.05 USD in 30 days
4.9 (11 reviews)
4.9
4.9
User Avatar
See private message.
$42.50 USD in 30 days
5.0 (15 reviews)
4.9
4.9
User Avatar
See private message.
$12.75 USD in 30 days
5.0 (26 reviews)
4.7
4.7
User Avatar
See private message.
$4.25 USD in 30 days
5.0 (39 reviews)
4.5
4.5
User Avatar
See private message.
$17 USD in 30 days
5.0 (31 reviews)
4.5
4.5
User Avatar
See private message.
$17 USD in 30 days
5.0 (30 reviews)
4.3
4.3
User Avatar
See private message.
$22.95 USD in 30 days
4.9 (37 reviews)
4.4
4.4
User Avatar
See private message.
$85 USD in 30 days
5.0 (25 reviews)
4.2
4.2

About the client

Flag of AUSTRALIA
Bendick Murrell, Australia
5.0
1
Member since Sep 7, 2006

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.