If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
adding records to an order form
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? |
#2
|
|||
|
|||
adding records to an order form
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" wrote: 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? |
#3
|
|||
|
|||
adding records to an order 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.? NTC wrote: 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? |
#4
|
|||
|
|||
adding records to an order form
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. "elbe" wrote: 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.? NTC wrote: 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? |
#5
|
|||
|
|||
adding records to an order form
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. "elbe" u47285@uwe wrote in message news:8c69b4b2adb6c@uwe... 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.? NTC wrote: 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? |
#6
|
|||
|
|||
adding records to an order 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 Klatuu wrote: 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? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200810/1 |
#7
|
|||
|
|||
adding records to an order form
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. "elbe via AccessMonster.com" u47285@uwe wrote in message news:8c80965d87cc7@uwe... 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 Klatuu wrote: 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? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200810/1 |
Thread Tools | |
Display Modes | |
|
|