A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Full line of product info in subform



 
 
Thread Tools Display Modes
  #1  
Old May 3rd, 2006, 07:56 PM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default 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  
Old May 3rd, 2006, 08:42 PM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default 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  
Old May 3rd, 2006, 11:19 PM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default 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  
Old May 8th, 2006, 02:03 PM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default Full line of product info in subform

If you have not already corrected this problem ZIP the db with only a few
records in each table and send it to me I will review it and see what I can
find that is evidently missing..

Send to

--
Hansford D. Cornett


"02c20e5" wrote:

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.

 




Thread Tools
Display Modes

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

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 01:13 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.