Create a interface/form using VB for an excel database
$30-250 AUD
货到付款
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.
项目ID: #5497291
关于项目
有53名威客正在参与此工作的竞标,均价$128/小时
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 更多
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 更多
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 更多
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 更多
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
Hello I can do this work... Kindly Pm me for more details Waiting for your positive response Thank You
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
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 更多
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 更多
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
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 更多
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? 更多
Hi, I have vast experience with C#. If you are interested in developing your tool using this approach, let me know. Regards, Cosmin.
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 更多