Become a dv.com member, Click here to register!
    • Lucid Dreaming - Dream Views




    Results 1 to 6 of 6
    1. 03-04-2008 09:02 PM #1
      Adrenaline Junkie
      Adrenaline Junkie is offline
      Member
      Join Date
      Jan 2007
      Gender
      Posts
      2,893
      Likes
      2

      Need Excel/Visual Basic Help

      Hey Guys,

      I'm currently working on my ICT coursework and the task is to create a spreadsheet in Excel which is like a booking form with an invoice and order form etc. We have to link everything together using macros which i have done, however it is the coding and formulas which trouble me.

      I might as well start off by saying this, what i am looking to achieve is a keyword search function. I have a database of about 30 products, and i need to create a search function which allows the product to be searched for by the use of keywords.

      My teacher says that this is going to be hard, but i don't know how i would go about doing it, especially in visual basic.

      So basically, i am looking to link my list of products as a database so that i can then link it to a keyword search function in which you can type in and search the database via keywords.

      Can anyone help me, i know its hard but i'd really appreciate any help i can get?

      Reply With Quote Reply With Quote  
    2. 03-04-2008 09:10 PM #2
      Adam
      Adam is offline
      !DIREKTOR! Adam's Avatar
      Join Date
      Jan 2007
      Gender
      Location
      Aquanina's closet
      Posts
      5,194
      Likes
      34
      Why would they suggest Excel for this, clearly they should be using Acess for this sort of lookup.
      Reply With Quote Reply With Quote  
    3. 03-04-2008 09:14 PM #3
      Adrenaline Junkie
      Adrenaline Junkie is offline
      Member
      Join Date
      Jan 2007
      Gender
      Posts
      2,893
      Likes
      2
      Quote Originally Posted by Adam View Post
      Why would they suggest Excel for this, clearly they should be using Acess for this sort of lookup.
      I honestly don't know why, but it is what we have to use, and i really don't know how best to turn a product list into a database, and then create a search function, and then link the two together.

      Unless there is an alternative.

      Reply With Quote Reply With Quote  
    4. 03-04-2008 09:34 PM #4
      Adam
      Adam is offline
      !DIREKTOR! Adam's Avatar
      Join Date
      Jan 2007
      Gender
      Location
      Aquanina's closet
      Posts
      5,194
      Likes
      34
      you will have to use vlookup I think unless there is another way to do it.
      Reply With Quote Reply With Quote  
    5. 03-04-2008 09:36 PM #5
      Ynot
      Ynot is offline
      FBI agent Ynot's Avatar
      Join Date
      Oct 2005
      Gender
      Location
      Southend, Essex
      Posts
      4,337
      Likes
      14
      it may be helpful if you post some mockup screenshots from Excel
      with a description of what you want

      Code:
                               _______
Search for: Single      |Search|
                        """""""

Room size                 1/2 board              Full board
Single                        30                       50
Double                        50                       70
Double balcony                70                       90
      I input "Single" into box, press search, and a message box pops up with 1/2 & full board prices

      or, something
      (\_ _/)
      (='.'=)
      (")_(")
      Reply With Quote Reply With Quote  
    6. 03-04-2008 10:05 PM #6
      Adrenaline Junkie
      Adrenaline Junkie is offline
      Member
      Join Date
      Jan 2007
      Gender
      Posts
      2,893
      Likes
      2
      Okay Ynot,

      I'll load it up and get some screenshots and show you what i mean, it could take a while but if it means i can get some sense of direction with this then thats awesome. I honestly am no good with computers

      I'll have it up in an hour.

      Reply With Quote Reply With Quote  
    « Previous Thread | Next 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
    •  

    Forum Rules