Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2009
    Posts
    3

    Unanswered: inventory design

    hey guys ive been searching everywhere to get some decent ideas and posting in quite a few forums...but here it goes im building an inventory program for our computers...computer names, hardware, software, keys, users, in use....they are all in a large database...i need to be able to search the database and have the program post what it found in accordance with the item searched.

    here is kinda what we are looking for....type in say a computer name and choose computer name in drop down box hit the go find button and it will retrieve and print out the answers in their respected textboxes or fields located next to their labels

    thank you for the help in advance
    Attached Thumbnails Attached Thumbnails rough draft.JPG  

  2. #2
    Join Date
    May 2005
    Posts
    1,191
    Welcome to the forums blkpython

    Sounds like your still at the concepting stage of your project. I don't know your background or your skill level with databases, but be sure to be familiar with Relational Database Design while you're still laying out the table design.

    Also, it kinda sounds like your looking for a pre-existing solution that you can tweak and implement; I'm not sure such a thing exists. Do you have a bit more specific question? If you need a start, you could look at the Code Bank.
    Me.Geek = True

  3. #3
    Join Date
    Jul 2009
    Posts
    3
    yeah right now its kinda just the planning stages....im looking for the easiest way to complete it cuz im no pro at coding anything, i know a few commands that im trying to play around with (dlookup and such)....i was hoping to get some references and have some peeps point me in the right direction before i lose the rest of my hair i dont have lol


    thanks

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Sounds to me like you need a developer. Yes, you can save a few dollars by doing it yourself, but you/your company will pay a lot more for it later. Believe me.

    The most common job I get is to come in to a business and pick up a database that has been designed by someone who was not a professional and I can tell you with certainty that it would have cost FAR less (sometimes in the order of tenfold) for them to get it done right the first time around.

    Even if it's just a few hours of consulting with you to get your design right, I highly recommend you consider the option.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  5. #5
    Join Date
    Jul 2009
    Posts
    3
    Quote Originally Posted by StarTrekker
    Sounds to me like you need a developer. Yes, you can save a few dollars by doing it yourself, but you/your company will pay a lot more for it later. Believe me.

    The most common job I get is to come in to a business and pick up a database that has been designed by someone who was not a professional and I can tell you with certainty that it would have cost FAR less (sometimes in the order of tenfold) for them to get it done right the first time around.

    Even if it's just a few hours of consulting with you to get your design right, I highly recommend you consider the option.

    i appreciate the suggestion...and if i cant figure it out i might do just that but we will see i wanna give it a whirl and maybe learn sumthin new in the process

Posting Permissions

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