Guidance needed for a project


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Guidance needed for a project

  1. #1
    Join Date
    Aug 2009
    Posts
    1

    Question Guidance needed for a project

    Hello -

    I am not sure what would be the best way to handle this so I thought I would start here and see what you might suggest.

    I have an Access database that houses a price list; the price_table contains two fields: product_tag and product_price.

    Then I have an Excel worksheet that is used to create quotes for our customers. There is a column titled 'Type' in the worksheet that is the same as the product_tag field in the database. There is also a column titled 'Amount' that is the same as the product_price in the database.

    What I need to do is when the user enters the 'Type' in the Excel worksheet cell have the product_price from the database automatically fill in the 'Amount' cell in the worksheet.

    So, if the user enters HD-1 in the 'Type' cell in the worksheet it would automatically search the price_table and find the matching HD-1 row and update the 'Amount' cell in the worksheet with the information in the product_price field.

    There could be multiple Types entered on the quote so we would need it to be able to do this process for each Type the user might enter.

    I do not know what the best method would be to run this process so any info you can provide me will be a great help.

    Thank you,

    QuickStudy

  2. #2
    Join Date
    Apr 2007
    Location
    Sterling Heights, Michigan
    Posts
    8,666
    Moved From Talk To The Editors which is a section for threads relating to the DevX web site in general.
    I don't answer coding questions via PM or Email. Please post a thread in the appropriate forum section.
    Please use [Code]your code goes in here[/Code] tags when posting code.
    Before posting your question, did you look here?
    Got a question on Linux? Visit our Linux sister site.
    Modifications Required For VB6 Apps To Work On Vista

Similar Threads

  1. Control Arrays in VB.NET
    By Gary Nelson in forum .NET
    Replies: 277
    Last Post: 10-01-2003, 12:00 AM
  2. Good Editorial by Russell Jones
    By Robert G in forum .NET
    Replies: 84
    Last Post: 02-08-2001, 02:38 PM
  3. Replies: 0
    Last Post: 09-13-2000, 10:18 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center