Not sure exacly what you are asking for, but what I have done on similar
projects working with Access is to create a query string, such as if your key
is item number, then when you hit the run button for each that is checked
append to a string something like..
if QueryString ="" then querystring = cells(x,y)
if QueryString <>"" then querystring = querystring & ", " & cells(x,y)
not the above exactly but basically you are building your db datastring with
all of the selected items. Hope that made sense.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.
"alex" wrote:
> I need advice to develop an application using excel to develop a "shopping
> Cart" procedure.
>
> I have a excel database with product codes and specifications as a table :
> headings are in columns and data is in rows. I have many (12) worksheets
> where customers can choose (single option botton..True for selected False for
> non selected) from diferents segments and products. In each worksheet
> customers select or no the right product for them.
>
> The problem:
>
> The database is used to extract references like product name and other
> specifications (using funtions like index and vlookup) so if i change the
> secuence (order) the specfications will change or get a data error.
>
>
> The issues here are:
>
> 1) How to develop the procedure to extract only selected items from database
> when the customers click on an "add to cart" button or something like this?
>
> 2) How to develop a procedure to put the selected items (extrated above)
> into a pre formated customer invoice?
>
> Considerations:
>
> I will also appreciatte If somebody tell me where i can found an example
> for this.
>
> Thank for your support.
>
> regards,
>
>
> alex
> madrid-spain
>
>
> This application will run for only one customer per session.
|
Similar Threads
