Completed

Create a interface/form using VB for an excel database

This project was successfully completed by BDtW for $70 AUD in 2 days.

Get free quotes for a project like this
Employer working
Completed by:
Project Budget
$30 - $250 AUD
Completed In
2 days
Total Bids
59
Project Description

Hi there,
I have a bunch of index books that need to be transferred from hard-copy to digital. I planned to do this by creating an excel database with all of the information that I need. I would like to have a user interface made using Visual Basic/Macros that is user-friendly. I have had an attempt at making one but simply don't have the knowledge or patience required.

The essential features that the form would need to have are:
(refer to picture for clarity)

Add New Record - The form must have the ability for a user to simply type in information into blank textboxes, then press "Add New Record" and have it create a new row of information in the excel database.

Find Record - Using the same textboxes, if a user enters either a Last Name or a Reference Number, then presses "Find Record", it should search through the Excel database and find any matching records. If a record is found, the other boxes (which have not been filled out) should be populated with data from the relevant row of information that has been found. If there are more than one records found, the user should be able to cycle through the records using the "<<" and ">>" buttons.

Update Record - When a user finds a record using the above process, they should have the ability to edit information, such as the Notes or the client's address. When a user has edited information for the record, they should be able to press "Update Record" and have the relevant row of information updated, without creating a separate new row of information.


The rest of what is required is seen in the picture. The columns/textboxes needed are all there. There should be two drop-down menus (or ComboBoxes); one for "State" and the other for "Street Type". I can provide the list of options that should be in each drop-down menu.

The form seen in my attached pictures was my attempt of this, however the buttons don't work as there is no code. If this form is of any help or saves you time, I can provide this too.

Thanks in advance,
Phil.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online