Microsoft Access: Search function and changes

Budget $30 - $100 USD
Bids 14
Average Bid $70

This project is a small project that requires some minor fixes to an existing project. The database is 90% complete but needs an experienced developer to make a number of changes. The following changes will need to be made to the project.

A button which does the following will need to be added.

• It will automatically generate a new project identifier (this is not the primary key the primary key is a separate auto number field) for the record this will be a combination of the year and the next consecutive number.
• MsgBox “ The corresponding file structure has been created”
• When a new record is created a new file directory using the mkdir statement is created
• This directory will consist of a new folder containing the new job number and a job description and six sub folders( the names of these sub folders will be hard coded as they never change)

In addition some small changes are need –

• Ensuring the information on sub forms and sub tabs is the correct information for the record. There is only the one main form which consists of two tabs but the information on the second tab does not correspond correctly.( This will become apparent once you see the forms

• An event log which is tracking changes to textboxes needs to be changed so that it tracks changes to drop down menu’s as well

The other feature we would like to build is a detailed search function which can search through a number of free text fields (text and memo) for relevant values and return a list of records that match these. If you are capable of building the search function, it would be good if you could attach a quick note on how you would build the search function.

This project needs to be completed ASAP. If you have previously built a search function in access and can re-use the code that would be ideal.

Post a Project Like This

This project was awarded to

Kingpin1962

A FANTASTIC provider, worked so very hard. Great job.Excellent communication. Fast and Easy to work with him. I will be using again him in the future.A++++++
About the Freelancer
Kingpin1962 Profile Picture

I work as VB6 (13 years) and .Net (both C# and VB - 5 years) developer. Also manage most relational databases (Access, SQL Server, Oracle, MySql, Pervasive SQL).

Looking to make some money?

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

Bids on this Project

  • Suddashil Profile Picture

    Suddashil

    burdwan,  India

    Java, Visual Basic, Data Entry, and J2EE

  • KellogITSolution Profile Picture

    KellogITSolution

    India,  India

    Myself a dedicated freelance software professional. I try to solve our customer problem with utmost care. Customer is my top-most priority. I try to provide solutions to my customer at the lowest cost with no compromise on quality.

    PHP, ASP, C Programming, and Javascript

  • rajneeshag Profile Picture

    rajneeshag

    Jabalpur,  India

    View my online profile at http://www.rajneeshag.com I have developed following Web Applications & Projects for local and online clients. http://www.proshareng.com frontend : PHP, HTML4/5, CSS3 backend : MySQL description: The client is Finantial Analyst Company in Nigeria. http://www.2daywin.com frontend : asp.net3.5 (C#) backend : sqlserver 2008 description: project is to manage data of MLM Company. It includes payout calculation, tree generation, genology, mail messaging, SMS Messaging. It is having a perfect admin section for client. http://www.moneyplus.pro frontend : asp.net3.5 (C#) backend : sqlserver 2008 description: project is to manage data of MLM Company. It includes payout calculation, tree generation, genology, mail messaging, SMS Messaging. It is having a perfect admin section for client. http://www.uniqueearn.biz frontend : asp.net3.5 (C#) backend : sqlserver 2005 description: project is to manage data of MLM Company. It includes payout calculation, tree generation, genology, mail messaging, SMS Messaging. It is having a perfect admin section for client. http://www.jkpower.net frontend : asp.net3.5 (C#) backend : sqlserver 2005 description: project is to manage data of MLM Company. It includes Flash Layout, and having payout calculation, tree generation, genology, mail messaging, SMS Messaging. It is having a perfect admin section for client. http://www.orionera.net frontend : asp.net3.5 (C#) backend : sqlserver 2005 description: project is to manage data of MLM Company. It includes payout calculation, tree generation, genology, mail messaging, SMS Messaging. It is having a perfect admin section for client. http://www.sunnetmoney.com frontend : asp.net3.5 (C#) backend : sqlserver 2005 description: project is to manage data of Insurance Company working privately. http://www.sunnetworld.com frontend : asp.net3.5 (C#) backend : sqlserver2005 description: project is to manage data of MLM (multi level marketing company) and manages other things such as event, membership etc. www.myisbn.us using ASP.net with MS-SQL Server Site for managing Tax Consultation Services http://www.cockydelivery.com frontend: ASP.net backend: SQL Server 2005 description: This site is used to provide facility of ordering of food online and making necessary payments online. http://www.bostonareanightlife.com frontend: PHP backend: mysql description: It is site which I have converted from ASP.net 2.0 to PHP as per the requirement of the buyer. Questionnaire Solely created in VB.net 2005 and MS Access It has facilities for questionnaire, subjects, questions, answers, responses both at the admin and user side. http://intellectualconservative.com using php / MYSQL / WORDPRESS Added new blog services and add rotator configuration on the site. www.pacejbp.com using asp.net, MS-Access major modules are Project details, student membership, notice board, admin http://www.dailys.co.uk using PHP and MySQL, whole site revamped and adjusted in the current shape, Site works in 5 languages. http://www.ramdascollege.com using HTML, JS, PHP, MYSQL I have designed and managing the site which is mainly having static contents Created several stanalone softwares and utility programs which are created using many languages (JAVA, VB.net, ASP.net, VC++, VB, C++, C etc with Oracle, MS-SQL Server, MS-Access, MySQL as back end whereever needed.

    PHP, Java, JSP, and Javascript

  • vibielova Profile Picture

    vibielova

    Bandung,  Indonesia

    PHP, ASP, C Programming, and Java

  • grichani Profile Picture

    grichani

    Thousand Oaks,  United States

    Visual Basic, Translation, Data Processing, and Project Management

  • tabaqchali Profile Picture

    tabaqchali

    london,  United Kingdom

    ASP, Javascript, XML, and Visual Basic

  • wsh2 Profile Picture

    wsh2

    Easton,  United States

    Affiliations: Have very successfully completed over 30 Get-A-Freelancer projects with a 100% On-time and 100% On-budget rating. Hold expert/ mentor Programming status and expert Database status at www.Experts-Exchange and www.Vbcity.com. Programming skills and experience: C, C++, C#, VB.Classic, VB.Net, VBA, VBScript, DOS, Powershell, Windows Scripting. Database skills and experience: Microsoft SQL Server, Microsoft Jet (Access). Microsoft Office skills and experience: Access and Excel. Business System skills and experience: Payroll, General Ledger, Accounts Payable, Accounts Receivable, Inventory, Purchasing, Order Entry, Sales + Marketing, Production Planning, Asset Tracking, Project Management, Engineering Bills Of Material (BOM), Statistical Analysis and Forecasting. Accounting skills and experience: Degreed Accountant (Summa Cum Laude), Quickbooks, Bookkeeping, Financial Statements, and Personal Income Taxes (USA). Languages: American English. ------------------------------------------------------------------ Extemely knowledgable. Extremely skilled. Extremely experienced. Excellent On-Time + On-Budget record. We highly respect your time and energies! Let us capably assist you in getting your project "done right" the very first time.

    XML, Visual Basic, .NET, and Windows Desktop

  • bratvl Profile Picture

    bratvl

    Donetsk,  Ukraine

    XML, Visual Basic, Windows Desktop, and Delphi

  • aarmom Profile Picture

    aarmom

    New Delhi,  India

    ASP, Visual Basic, .NET, and Data Processing

  • alekseymihalych Profile Picture

    alekseymihalych

    Urai,  Russian Federation

    MY SELF DEVELOPMENT PROJECTS "DMS-Info" (medical insurance automation system) "Zasov" (software for registrate and bookkeping montage, service and store of Intercoms) "12 chairs" (Small Furniture factory automation system) "Info-Stand" (For information showing on PC-terminals) "International Passport" (simply tool for Russian International Passport request form) "Invoice Book" "Birthdays" (for social departments) I AM CO-AUTHOR IN PROJECTS "ASPP-15" (accounting tool for samll business tax system) "Breeze" (reataraunt automation - menus, calculations, warehouse) SELF DEVELOPMENT HELPING UTILITIES "BaseCopy" (Simply tool for MDB copying, compact, password enabling. Useful in design-time in projects with mdb-bases) "DB converter" (Simply tool for DBF update. Useful in support) "Acts of Works" "Software Stock" (Developer software stock - platform, price, need-to-update, who uses etc)

    Visual Basic, Delphi, Microsoft Access, and Visual Foxpro