adding records to an order form

[elbe]

What I have is the following tables
products
order details
orders
customers

the relational links are as follows

customer to orders 1 to many [ customerID] to [ customerID]
orders to order details 1to many [order id] to [order id]
order details to products 1 to many [productsID] to [products ID]

right now i have a combo box in the sub order form called product that adds
the product to the order

what i would like to do is get rid of the combo box

and to be able to pull up the products form (listing all the products with a
pic of the products)
and enter the quantity that the customer wants and have it add it to the
customers order and then be able to save it for future reference
If this cannot be done is it possible to add a button on the continuous
parts form that will add it to the customers order? if so how do i do this?

 

[NTC]

well - the combobox is Access's vanilla way to look up values in some other
table (i.e. Products table) so that you can enter a value in your current
table (Orders Table)

if you really can't use a combobox - because an image of the product is
critical - you could create another form for Products, perhaps a popup form
would be convenient....

and then the user can scroll thru the products form...and then manually
enter the product ID into the Orders form....

 

[elbe]

is there a way to have a button on the continuous form one for each record
that when press would and the product id to the order form? or perhaps a
check button on the products form that the customer can check as they scroll
though the products and them at the end click a button that would add those
items to their order.?

well - the combobox is Access's vanilla way to look up values in some other
table (i.e. Products table) so that you can enter a value in your current
table (Orders Table)

if you really can't use a combobox - because an image of the product is
critical - you could create another form for Products, perhaps a popup form
would be convenient....

and then the user can scroll thru the products form...and then manually
enter the product ID into the Orders form....

What I have is the following tables
products

[quoted text clipped - 19 lines]

If this cannot be done is it possible to add a button on the continuous
parts form that will add it to the customers order? if so how do i do this?

 

[NTC]

yes; but it requires alot of custom vb which is probably not feasible to
explain in this type forum; plus if you are plugging in other's code you
would have a hard time maintaining it...

in general terms you could have a checkbox field in the products table.....
and then check the products you want in a single order; upon an 'Enter'
button event you could then identify those with a check, insert them into the
orders table, and then clear them off the products table....

but if you are not comfortable with all this - the simpler thing (besides
the combobox) is to simply use a the products form as a visual aid - and
manually enter the product ID into the orders form.

is there a way to have a button on the continuous form one for each record
that when press would and the product id to the order form? or perhaps a
check button on the products form that the customer can check as they scroll
though the products and them at the end click a button that would add those
items to their order.?

well - the combobox is Access's vanilla way to look up values in some other
table (i.e. Products table) so that you can enter a value in your current
table (Orders Table)

if you really can't use a combobox - because an image of the product is
critical - you could create another form for Products, perhaps a popup form
would be convenient....

and then the user can scroll thru the products form...and then manually
enter the product ID into the Orders form....

What I have is the following tables
products

[quoted text clipped - 19 lines]

If this cannot be done is it possible to add a button on the continuous
parts form that will add it to the customers order? if so how do i do this?

 

[Klatuu]

This is not a bad idea, but you would not need a button for each product.
Use a form/subform. The form would have a text box for the quantity and a
command button that would update the order detail subform of the order form.

The only issu here is I have been trying for some time to figure out how to
put images on a continuous form without success, so if that is impossible,
then you may need to put the picture on the mainform and you can make the
picture change to show the picture for the current record in the sub form.

And, if you know how to get pictures in a continuous form using linked
pictures rather than imbedded pictures, I would love to learn that.

is there a way to have a button on the continuous form one for each record
that when press would and the product id to the order form? or perhaps a
check button on the products form that the customer can check as they
scroll
though the products and them at the end click a button that would add
those
items to their order.?

well - the combobox is Access's vanilla way to look up values in some
other
table (i.e. Products table) so that you can enter a value in your current
table (Orders Table)

if you really can't use a combobox - because an image of the product is
critical - you could create another form for Products, perhaps a popup
form
would be convenient....

and then the user can scroll thru the products form...and then manually
enter the product ID into the Orders form....

What I have is the following tables
products

[quoted text clipped - 19 lines]

If this cannot be done is it possible to add a button on the continuous
parts form that will add it to the customers order? if so how do i do
this?

 

[elbe via AccessMonster.com]

here is how you can add a photo into a continuous form.
on your table add a field called photo then in the data type field click on
attachments.
add this field to your form when you add it to your form it will give you
three choices
pick the photo.FileData it will show a blank on the form then click on
the blank and it will ask you for the file you want to add find the picture
and click on it. it will now show up in the attachment
field on the form. when you want to change the photo just click on the photo
and delete the old photo and reattach a new photo. also as a tip for you
what i did was put a label field under were the photo will be that says
photo unavailable. be sure to go to arrange and send the label to the back
so when you add a photo you wont see the photo unavailable label hope this
work let me know if you have any questions.

what do i need to do, to have a command button on the continuous form that
will add the product number to a customers order? would it be better to have
a check field so that the customer can check off the products that they want
and then have one command button that will take all the items that the
customer checked off and add it to their order with the quantity they
inputted on the products form***** kind of like a shopping cart.

let me know if you know where i can find an example of this
thanks for your help

This is not a bad idea, but you would not need a button for each product.
Use a form/subform. The form would have a text box for the quantity and a
command button that would update the order detail subform of the order form.

The only issu here is I have been trying for some time to figure out how to
put images on a continuous form without success, so if that is impossible,
then you may need to put the picture on the mainform and you can make the
picture change to show the picture for the current record in the sub form.

And, if you know how to get pictures in a continuous form using linked
pictures rather than imbedded pictures, I would love to learn that.

is there a way to have a button on the continuous form one for each record
that when press would and the product id to the order form? or perhaps a

[quoted text clipped - 23 lines]

 

[Klatuu]

Thanks, but that is a 2007 solution. There is no attachement data type in
2003.

As to the check boxes and one command button. (well, you want quantity,
too, right)

On your form for selecting the products, add two fields, one a chec box for
selecting the a product and one a text box for entering the quantity.

Once the user has made all the selections, in the button's click event use
recordset processing on the form's recordset and for each record that is
checked, create a record in the orders detail form.

here is how you can add a photo into a continuous form.
on your table add a field called photo then in the data type field click
on
attachments.
add this field to your form when you add it to your form it will give you
three choices
pick the photo.FileData it will show a blank on the form then click
on
the blank and it will ask you for the file you want to add find the
picture
and click on it. it will now show up in the attachment
field on the form. when you want to change the photo just click on the
photo
and delete the old photo and reattach a new photo. also as a tip for
you
what i did was put a label field under were the photo will be that says
photo unavailable. be sure to go to arrange and send the label to the
back
so when you add a photo you wont see the photo unavailable label hope
this
work let me know if you have any questions.

what do i need to do, to have a command button on the continuous form
that
will add the product number to a customers order? would it be better to
have
a check field so that the customer can check off the products that they
want
and then have one command button that will take all the items that the
customer checked off and add it to their order with the quantity they
inputted on the products form***** kind of like a shopping cart.

let me know if you know where i can find an example of this
thanks for your help

This is not a bad idea, but you would not need a button for each product.
Use a form/subform. The form would have a text box for the quantity and a
command button that would update the order detail subform of the order
form.

The only issu here is I have been trying for some time to figure out how
to
put images on a continuous form without success, so if that is impossible,
then you may need to put the picture on the mainform and you can make the
picture change to show the picture for the current record in the sub form.

And, if you know how to get pictures in a continuous form using linked
pictures rather than imbedded pictures, I would love to learn that.

is there a way to have a button on the continuous form one for each
record
that when press would and the product id to the order form? or perhaps
a

[quoted text clipped - 23 lines]

parts form that will add it to the customers order? if so how do i do
this?