+ Reply to Thread
Results 1 to 7 of 7

Setting up and searching database

  1. #1
    Registered User
    Join Date
    12-10-2009
    Location
    California
    MS-Off Ver
    Excel 2003
    Posts
    20

    Setting up and searching database

    What I want to do is this. I am setting up a comic book database for a guy. I am going to name the tabs the name of the comic books. I want to setup a worksheet that I can search the name of the comic book and the number of the book and have the results underneath the search criteria. I am attaching a sample workbook. On the search database sheet, I have setup how I would like the page to look.

    The spots where Enter Comic Name and Enter Comic Number I would like to act as search boxes, as in Google.

    I would like the Search and Clear to be buttons.

    Is it possible to return the results I want? And can I keep my searches until I push the clear button? If not I will get rid of the clear button.

    The last thing I want to see if possible is once I get a result, can I add a button to go to that comic books location to enter data. Or add a save button so I can edit any info right on the search page and save it in the database.

    He has about 60 Long boxes full of comics so this will probably be a huge database so any help on how to set this up would be greatly appreciated.

    Thanks Guys!!!

    Steve
    Attached Files Attached Files
    Last edited by smraines; 12-22-2009 at 12:34 AM.

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: Setting up and searching database

    Excel as a database all data should be stored on one sheet in a Table Format, then you can use Excel's Dta Functions such as VLOOKUP & Data Validation (List) to create a search form.

    So instead of a separate sheet for each comic type add a Column(Field) for it instead
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Registered User
    Join Date
    12-10-2009
    Location
    California
    MS-Off Ver
    Excel 2003
    Posts
    20

    Re: Setting up and searching database

    I really dont want to group everything on one page. I think it would look better if each comic was be on its own worksheet. Amazing Spiderman alone has over 600 entries. This is why i want to set it up this way. I know there has to be a way to set this up. Does anyone else have any input?

  4. #4
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Setting up and searching database

    I agree with Roy.
    Entia non sunt multiplicanda sine necessitate

  5. #5
    Registered User
    Join Date
    12-10-2009
    Location
    California
    MS-Off Ver
    Excel 2003
    Posts
    20

    Re: Setting up and searching database

    Could you take a look at my file and just throw together a quick sample of what your talking about cuz Im completely lost? Thanks.

  6. #6
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: Setting up and searching database

    I have amalgamated the comic data into one database sheet
    The data table is a Dynamic named Range that will expand as you add data
    There are two extra fiels for comic & a reference. The reference is created y a formula in the ref column
    I have added VLOOKUP formulas to the form.See

    http://excel-it.com/excel_functions.htm

    You could also use DataValidation to create drop downs to choose comic books & numbers, see

    http://excel-it.com/data_validation.htm
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    12-10-2009
    Location
    California
    MS-Off Ver
    Excel 2003
    Posts
    20

    Re: Setting up and searching database

    Okay I see what you meant now. Thats pretty nice. Thank you for your help. Now to format the file and get started on this project.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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