Create a interface/form using VB for an excel database

已完成 已发布的 Feb 28, 2014 货到付款
已完成 货到付款

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的应用程式

项目ID: #5497291

关于项目

53个方案 远程项目 活跃的Apr 4, 2014

授予:

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.4

有53名威客正在参与此工作的竞标,均价$128/小时

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天内
(802条评论)
8.7
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天内
(102条评论)
7.2
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天内
(71条评论)
6.6
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天内
(88条评论)
7.0
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天内
(151条评论)
6.2
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天内
(211条评论)
6.1
rumapaul

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

$66 AUD 在3天内
(47条评论)
5.4
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
MuradMurad

A proposal has not yet been provided

$388 AUD 在7天内
(9条评论)
5.2
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
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
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
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
rfreelancer2008

Hi there - Anything to do with Excel VBA. I have few questions for now: 1. I noticed that you are using .xls. Will it be fine if I convert this into .xlsx (and .xlsm - macro enabled file) and work on that file? 更多

$222 AUD 在3天内
(28条评论)
4.5
pirlitu

Hi, I have vast experience with C#. If you are interested in developing your tool using this approach, let me know. Regards, Cosmin.

$156 AUD 在2天内
(10条评论)
4.3
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.1
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天内
(8条评论)
4.2
Midlander

Phil, I have produced exactly what you want for another client already. You can have the User Form you need as soon as you award me the assignment and pay the fee into the site. It includes Code that even HIDES the Exc 更多

$136AUD 在1天里
(12条评论)
4.5