PC Review


Reply
Thread Tools Rate Thread

can someone point me it the right direction need help Please!!!!!!

 
 
Elbe
Guest
Posts: n/a
 
      29th Apr 2009
I have a continuous form each line is a different product. I would like to
have it so that as the customer looks through the products they can enter the
qty they want to buy and it automatically adds it to their order.

I have the following forms.
customer
orders / subform order details
customer catalog ( continuous form)
Products

it would be like using a shopping cart on the wed.
is there an example on how to do this?
I am familiar with access but not the coding

 
Reply With Quote
 
 
 
 
KARL DEWEY
Guest
Posts: n/a
 
      29th Apr 2009
One way is to have order form to enter CustomerID and button to make order.

That button runs an append query that append a record of each product
available to the Orders table with CustomerID and OrderDate default Now() and
displays in subform.

Customer scroll and enters quanity into the subform.

Then another button to complete order that deletes all records in Orders
table without a quanity and any other ordering actions such as printing
shipping report.

"Elbe" wrote:

> I have a continuous form each line is a different product. I would like to
> have it so that as the customer looks through the products they can enter the
> qty they want to buy and it automatically adds it to their order.
>
> I have the following forms.
> customer
> orders / subform order details
> customer catalog ( continuous form)
> Products
>
> it would be like using a shopping cart on the wed.
> is there an example on how to do this?
> I am familiar with access but not the coding
>

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
A point in the right direction... Jaybird Microsoft Excel Programming 0 2nd May 2008 03:28 PM
Point me in the right direction =?Utf-8?B?Q2hlcmk=?= Microsoft Outlook Discussion 1 19th May 2007 04:49 PM
Point me in the right direction?? Robert M. Cepek Microsoft Windows 2000 DNS 2 3rd Mar 2004 08:16 AM
Can someone help/point me in the right direction? Stu Padasso Windows XP Video 1 22nd Jan 2004 10:31 PM
Can someone point me in the right direction? Mike G. Microsoft Outlook Interoperability 1 10th Jul 2003 09:09 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:07 AM.