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
|
|||
|
|||
Full line of product info in subform
I am relatively new at programming in Access and need to create a purchase
order that lists the product, product name, number of products in a case, the cube and weight of the case. I need to keep a running total of the cube and weight columns as the buyers need to know how much room remains in the shipping container. I created a form and subform to do the job, but whenever I run the form, it leaves out the product description, plus I can't choose the product ID from the drop down list. The subform is connected to the products table and each field in the form matches the properties of the corresponding field in the table. Do I need to do some VB in order to have the form work? I have not had any experience with VB at all, so I am at a loss as how to continue. My supervisor is chomping at the bits to get this program running. Any help would be greatly appreciated. |
#2
|
|||
|
|||
Full line of product info in subform
If you build your subform and using the wizard place that subform on to the
main form it should ask you the connecting fields that are alike in both tables i.e. possibly a ID of sorts that is the same in both tables. Once this is done it sets the link childs and master fields and it should rotate as you desire. VB is not normally necessary in this case. -- Hansford D. Cornett "02c20e5" wrote: I am relatively new at programming in Access and need to create a purchase order that lists the product, product name, number of products in a case, the cube and weight of the case. I need to keep a running total of the cube and weight columns as the buyers need to know how much room remains in the shipping container. I created a form and subform to do the job, but whenever I run the form, it leaves out the product description, plus I can't choose the product ID from the drop down list. The subform is connected to the products table and each field in the form matches the properties of the corresponding field in the table. Do I need to do some VB in order to have the form work? I have not had any experience with VB at all, so I am at a loss as how to continue. My supervisor is chomping at the bits to get this program running. Any help would be greatly appreciated. |
#3
|
|||
|
|||
Full line of product info in subform
I rebuilt the form and subform and used the wizard as you suggested, but it
did not ask me what fields were alike (I did,however, make a relationship between the tables beforehand, so that may be why that step was missing). When the pop-up window asked for the link childs and masterfields, I'm not sure what to put. In the Child I put the "like" field, and the master dropdown had the table fields which I used the same "like" field, but now I don't even get any of the products in the product ID combo drop down list. I even tried using the product ID field in the master feld link. "Hansford cornett" wrote: If you build your subform and using the wizard place that subform on to the main form it should ask you the connecting fields that are alike in both tables i.e. possibly a ID of sorts that is the same in both tables. Once this is done it sets the link childs and master fields and it should rotate as you desire. VB is not normally necessary in this case. -- Hansford D. Cornett "02c20e5" wrote: I am relatively new at programming in Access and need to create a purchase order that lists the product, product name, number of products in a case, the cube and weight of the case. I need to keep a running total of the cube and weight columns as the buyers need to know how much room remains in the shipping container. I created a form and subform to do the job, but whenever I run the form, it leaves out the product description, plus I can't choose the product ID from the drop down list. The subform is connected to the products table and each field in the form matches the properties of the corresponding field in the table. Do I need to do some VB in order to have the form work? I have not had any experience with VB at all, so I am at a loss as how to continue. My supervisor is chomping at the bits to get this program running. Any help would be greatly appreciated. |
#4
|
|||
|
|||
Full line of product info in subform
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
can't reinstall office xp pro after deleting from windows xp syste | dana | Setup, Installing & Configuration | 1 | August 5th, 2004 06:32 PM |
can't reinstall office xp pro after deleting from windows xp syste | mkskyflyer | Setup, Installing & Configuration | 1 | August 5th, 2004 05:39 AM |
Recordset in subform based on field in parent form | Lyn | General Discussion | 15 | June 14th, 2004 03:10 PM |
Product Key for Office XP | P.G.Indiana | Setup, Installing & Configuration | 1 | June 7th, 2004 03:22 AM |
Productkey problem when installing office 2003 on network | Stefan Schreurs | Setup, Installing & Configuration | 1 | June 1st, 2004 11:16 PM |