Ολοκληρωμένο

Create a interface/form using VB for an excel database

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.

Ικανότητες: .NET, Διαχείριση Βάσεων Δεδομένων, Excel, Visual Basic, Visual Basic για Εφαρμογές

Περισσότερα: vb.net features, create a picture, clarity information, advance excel+, excel advance, visual interface, visual basic form excel, Visual Basic Excel, vb excel, excel visual basic, create an excel, create a excel, advance excel, excel database visual basic, form update excel, client form excel, excel update net, visual basic database excel database, drop list database, macros excel basic

Σχετικά με τον Εργοδότη:
( 2 αξιολογήσεις ) Caroline Springs, Australia

Ταυτότητα Εργασίας: #5497291

Ανατέθηκε στον:

BDtW

Hi Thank you for explaining the the project so neatly. I think I have all the info I need to start working on it. The picture and the explanation has made it all clear. If you take a look at my profile you'll fin Περισσότερα

$70 AUD σε 2 μέρες
(33 Αξιολογήσεις)
5.2

56 freelancers κάνουν προσφορές κατά μέσο όρο $123 για αυτή τη δουλειά

jaylancer43

Hello - I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among n Περισσότερα

$200 AUD σε 5 μέρες
(574 Αξιολογήσεις)
8.2
maverick44000

Hi Mate. Not only I am highly proficient in VBA macros and Excel but I have done a few projects, involving the designing of input user forms, too. I have read the project description and seen the attached snap shot and Περισσότερα

$160 AUD σε 3 μέρες
(96 Αξιολογήσεις)
7.1
paris2785

VB and VBA expert for over a decade. Master in Information Systems. I have delivered similar projects in the past. Please check my portfolio for: [login to view URL] Estate (video demonstration) [login to view URL] (video demonstration Περισσότερα

$98 AUD σε 7 μέρες
(144 Αξιολογήσεις)
6.7
ITservice

Hi, I have 5+ years of experience. Developed various projects in .Net with MsSql database. Infact, 90% of the projects done so far are in ASP, which includes simple dynamic page to complex ecommerce related websites Περισσότερα

$154 AUD σε 7 μέρες
(82 Αξιολογήσεις)
7.0
dpune

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive Περισσότερα

$222 AUD σε 15 μέρες
(130 Αξιολογήσεις)
6.4
expertatwork

hey philep10, we can create forms (similar to the one that you have attached) with full functionality. please reply and we can discuss further. thanks

$55 AUD σε 2 μέρες
(199 Αξιολογήσεις)
6.1
mail2vimalarora

Hi.. I have gone through your requirement in the description of the project in detail and feel comfortable in taking up the task. I have done several projects of data management and similar approach can be applied here Περισσότερα

$200 AUD σε 10 μέρες
(89 Αξιολογήσεις)
5.9
codeindiadigital

Hi, I'm a freelancer from India. I can do this job easily. I know VB and Excel well. Please check my reviews. I'll be waiting for your feedback

$133 AUD σε 3 μέρες
(57 Αξιολογήσεις)
5.5
Vasilchenko

Hi You seem good employer. Your task is perfectly explained. Just select me. I really want to do this project. You can also find me in Scype: Vasilchenko_Andrey,Kiev,Ukraine Remember about timesones. We have Περισσότερα

$50 AUD σε 3 μέρες
(50 Αξιολογήσεις)
5.7
sonarkaushik

Sir, I am well versed in this kind of jobs and can do your project as per requirement. Refer my online work portfolio at [login to view URL] Looking for further discussions in this matter. with than Περισσότερα

$147 AUD σε 4 μέρες
(51 Αξιολογήσεις)
5.8
umbrellasofts

ready to start !!! ............................................................................................................................

$40 AUD σε 3 μέρες
(37 Αξιολογήσεις)
5.1
piyushdpatel

I have 8 yrs of Exp in VBA,VB6.0,VB.net and MsAccess. I have developed many applications in VB6,VBA,VB.NET. Ready to start (i can do Excel + VBA and Access+VB also ,Access + VB is Better if u want i will also send Περισσότερα

$111 AUD σε 3 μέρες
(28 Αξιολογήσεις)
5.2
MuradMurad

A proposal has not yet been provided

$388 AUD σε 7 μέρες
(9 Αξιολογήσεις)
5.2
abdellatif81

Hello , I am IT engineer with European diploma since 2005 Certified as Technical specialist in Microsoft SQL Server databases, i have more than 7 years in IT projects with 5 years working around Microsoft database Περισσότερα

$44 AUD σε 2 μέρες
(15 Αξιολογήσεις)
5.2
rumapaul

Hello I can do this work... Kindly Pm me for more details Waiting for your positive response Thank You

$66 AUD σε 3 μέρες
(46 Αξιολογήσεις)
5.4
buyaspreadsheet

Hi Phil. Why pick me? Outstanding feedback on all projects without exception. I run my own Professional Excel & VBA Consultancy, buyaspreadsheet.com. On my business website you can view a wide range of portfolio exampl Περισσότερα

$175 AUD σε 4 μέρες
(17 Αξιολογήσεις)
4.7
adim

Hi there, This can be done exactly as you required. The form would help too, as is already made and there's no point to make it from scratch. Adrian

$55 AUD σε 2 μέρες
(20 Αξιολογήσεις)
4.8
elboukharimu

Aucune proposition n'a encore été fournie.

$263 AUD σε 10 μέρες
(20 Αξιολογήσεις)
4.9
murtaza1981

Hi, An ASP.NET,c#,vb ,SqlServer,JQuery,Javascript expert here. Please feel free to discuss the project with me so that i can wrap it up in a timely manner as per your requirements. I would like to have a detailed d Περισσότερα

$250 AUD σε 3 μέρες
(8 Αξιολογήσεις)
4.2
pnjadhav

I am available right now. In my total 13 IT years of experience I have done lots of with project management.I am a expert Database Architect.I have done lots of database design and development for desktop and web based Περισσότερα

$277 AUD σε 10 μέρες
(7 Αξιολογήσεις)
4.2