Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2000 > SQL Server 2000
| Search | Today's Posts | Mark Forums Read
SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old August 18th, 2005, 02:54 PM
Registered User
 
Join Date: May 2005
Location: , , .
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Moving Selected Items from a list box to excel

I am using Access ADP Application with a SQL Server 2000 Back end. Do to the nature of our business (Used equipment), I need to create a list for our sales department for marketing. My inventory consists of thousands of unique items. I want to display a multi-select list box with certain basic criteria (Such as items with a certain make and model). I then want to let the sales person decide which of these they want to present to a client (There may be several reasons they would want to select a particular item over another, such as a customer will only except those units that have a serial number starting with 'ABC' since that indicates when it was Produced. When they have selected their items, they want to move those items selected into a Excel spreadsheet to either fax, print or email to the customer.
They may select several different makes and models for the customer before sending the excel spreadsheet.
I will have several sales people accessing the data at the same time.
Any ideas on how to address this problem.

  #2 (permalink)  
Old August 19th, 2005, 02:01 PM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Use the multi-select list box, then pass those selected items to a view/query that contains all the data you want to show to the client. This will produce a recordset with only those items selected, and all the other data you want to display.
This will work if several sales people are sending the data at once since it will be processed on the server one request at a time, and it is OLAP, not OLTP.
Then send the results to Excel using code.
Is this what you were after?

HTH


mmcdonal
  #3 (permalink)  
Old August 19th, 2005, 02:02 PM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Of course, each salesperson should have a copy of the adp file on their desktop. Multi-user adp files on the server will force everyone other than the first user to read-only. Plus this defeats the whole purpose of using SQL.

mmcdonal


Similar Threads
Thread Thread Starter Forum Replies Last Post
Placing database items into a list box hookenbook Visual Basic 2005 Basics 2 January 14th, 2009 08:56 PM
adding items to list box using javascript k.manisha ASP.NET 1.0 and 1.1 Professional 3 February 16th, 2007 06:32 AM
Choosing Multiple Items in a List Box HenryE Access 1 July 25th, 2005 07:14 AM
multiselect list box display selected problem pmcquirk Javascript How-To 12 January 18th, 2005 12:55 PM
list box 2 show items according 2 current variable warrenb24 ADO.NET 0 December 20th, 2004 12:01 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.