Results 1 to 6 of 6

Creating a form to query and update database

Threaded View

  1. #1
    Registered User
    Join Date
    04-27-2010
    Location
    boston ma
    MS-Off Ver
    Excel 2007
    Posts
    4

    Creating a form to query and update database

    Hello all,

    I am very new to Excel and am very surprised about its power ( I thought the best it could do was auto sum and graphs two weeks ago!)

    I am now trying to develop a simple application for a small start up company that I want to start that is engaged in transporting University students back and forth from the airport. The application's first release will be in Excel and will aim to store and update customer, payment, and reservation information. It will also print a receipt and email it to the customer.

    I have attached a horrible hack of what I am trying to do. What is missing is a form to query the reservations and to update information in it (we have multiple steps in the reservation life cycle before it is fulfilled).

    The main interface is a sheet called ABS.
    The "database" is called reservation
    The receipt is called Receipt
    The customer and payment info "database: is called customer info
    Info for dropdowns found on the ABS sheet is found under dropdowns sheet
    The business layer sheet is doing a lot of the lookups in the database (here is where it gets really hacky)
    Ambassador Smart System (2) is there just in case I mess up ABS I have another copy (another hack)

    OBJECTIVE:
    To create a form that will lookup and update values in the reservations sheet that will query the database based on multiple criteria: cell phone number, reservation number, first and last name, status of reservation.

    I have 45 columns in the reservation "database" and I am looking to combine the solutions that I found here both by Leith attached:
    1. "Database Form"
    2. "Search Database"

    Your help is greatly appreciated...and if you have other ways to do what I am trying to do...I am all ears.

    PS...I am not really liking the fact that the database and the application are together...I would love to hear any ideas that will allow multiple people to work at the same time on the data as well as protect the data from an application crash.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1