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
|
|||
|
|||
Setting forms up
I have to make a form for testing parts. What I'm doing is put one part
number per record and entering each time it is tested. My problem is I don't know how to be able to keep entering data for different days. PART # MANUFACTURER 1234 DANLEE PO # ACCEPT/REJECT DATE COMMENTS ABC XXXXX 11/28/06 XXXXX DEF XXXXX 11/29/06 XXXXX GDI XXXXX 11/30/06 XXXXX How do I set the form up so I can enter daily? Thanks in advance. |
#2
|
|||
|
|||
Setting forms up
Hi Jane
I think it may be an idea to have another table. tblParts PartID = Autonumber = primary PartName = Text Manufacturer = Text plus any other fields that are unique to the part eg. ToStock Date, Location, etc tblTests ID = Autonumber primary PartID = Number = Linking field from tblParts TestDate = Date Pass = Yes/No Plus anything else specific to "that" test. eg. Grade given, test by who, etc Open both the relationship window and drag the PartID over the the link field in tblTest - Assuming that parts must be there before they can be tested (?) I would enforce the referential integrity. Next create a form based on tblParts. Sinlge form Next create a form based on tblTests. Datasheet or continous forms Open frmParts in design view andselect the toolbox and then insert a subform. Use frmTests as the subform and link the partID (hich will be on both forms). Now when you select a part the test dates form will be shown for the part. Hope this help -- Wayne Manchester, England. Enjoy whatever it is you do Scusate,ma il mio Inglese fa schiffo :-) Percio se non ci siamo capiti, mi mandate un messagio e provero di spiegarmi meglio. "Jane" wrote: I have to make a form for testing parts. What I'm doing is put one part number per record and entering each time it is tested. My problem is I don't know how to be able to keep entering data for different days. PART # MANUFACTURER 1234 DANLEE PO # ACCEPT/REJECT DATE COMMENTS ABC XXXXX 11/28/06 XXXXX DEF XXXXX 11/29/06 XXXXX GDI XXXXX 11/30/06 XXXXX How do I set the form up so I can enter daily? Thanks in advance. |
#3
|
|||
|
|||
Setting forms up
Thank you. It sound like what I need. I will let you know how it works.
Thank you very much. I'm very new to access. I'm learning by reading alot of the discussions in this group. You guys are the best. Thanks again. "Wayne-I-M" wrote: Hi Jane I think it may be an idea to have another table. tblParts PartID = Autonumber = primary PartName = Text Manufacturer = Text plus any other fields that are unique to the part eg. ToStock Date, Location, etc tblTests ID = Autonumber primary PartID = Number = Linking field from tblParts TestDate = Date Pass = Yes/No Plus anything else specific to "that" test. eg. Grade given, test by who, etc Open both the relationship window and drag the PartID over the the link field in tblTest - Assuming that parts must be there before they can be tested (?) I would enforce the referential integrity. Next create a form based on tblParts. Sinlge form Next create a form based on tblTests. Datasheet or continous forms Open frmParts in design view andselect the toolbox and then insert a subform. Use frmTests as the subform and link the partID (hich will be on both forms). Now when you select a part the test dates form will be shown for the part. Hope this help -- Wayne Manchester, England. Enjoy whatever it is you do Scusate,ma il mio Inglese fa schiffo :-) Percio se non ci siamo capiti, mi mandate un messagio e provero di spiegarmi meglio. "Jane" wrote: I have to make a form for testing parts. What I'm doing is put one part number per record and entering each time it is tested. My problem is I don't know how to be able to keep entering data for different days. PART # MANUFACTURER 1234 DANLEE PO # ACCEPT/REJECT DATE COMMENTS ABC XXXXX 11/28/06 XXXXX DEF XXXXX 11/29/06 XXXXX GDI XXXXX 11/30/06 XXXXX How do I set the form up so I can enter daily? Thanks in advance. |
#4
|
|||
|
|||
Setting forms up
Thanks for getting back to me - it is always good to get feedback.
Good luck with project -- Wayne Manchester, England. Enjoy whatever it is you do Scusate,ma il mio Inglese fa schiffo :-) Percio se non ci siamo capiti, mi mandate un messagio e provero di spiegarmi meglio. "Jane" wrote: Thank you. It sound like what I need. I will let you know how it works. Thank you very much. I'm very new to access. I'm learning by reading alot of the discussions in this group. You guys are the best. Thanks again. "Wayne-I-M" wrote: Hi Jane I think it may be an idea to have another table. tblParts PartID = Autonumber = primary PartName = Text Manufacturer = Text plus any other fields that are unique to the part eg. ToStock Date, Location, etc tblTests ID = Autonumber primary PartID = Number = Linking field from tblParts TestDate = Date Pass = Yes/No Plus anything else specific to "that" test. eg. Grade given, test by who, etc Open both the relationship window and drag the PartID over the the link field in tblTest - Assuming that parts must be there before they can be tested (?) I would enforce the referential integrity. Next create a form based on tblParts. Sinlge form Next create a form based on tblTests. Datasheet or continous forms Open frmParts in design view andselect the toolbox and then insert a subform. Use frmTests as the subform and link the partID (hich will be on both forms). Now when you select a part the test dates form will be shown for the part. Hope this help -- Wayne Manchester, England. Enjoy whatever it is you do Scusate,ma il mio Inglese fa schiffo :-) Percio se non ci siamo capiti, mi mandate un messagio e provero di spiegarmi meglio. "Jane" wrote: I have to make a form for testing parts. What I'm doing is put one part number per record and entering each time it is tested. My problem is I don't know how to be able to keep entering data for different days. PART # MANUFACTURER 1234 DANLEE PO # ACCEPT/REJECT DATE COMMENTS ABC XXXXX 11/28/06 XXXXX DEF XXXXX 11/29/06 XXXXX GDI XXXXX 11/30/06 XXXXX How do I set the form up so I can enter daily? Thanks in advance. |
#5
|
|||
|
|||
Setting forms up
Hi Wayne,
Thank you very much for the help. I'm having a little problem. I get a error message saying you cannot add or change a record because a related record is required in tblparts. This is what I have done. table one (tblparts) Part ID # (autonumber) Primary Part # Manufacturer # table two (tbltests) ID # (autonumber) Primary PO # Order Qty Rec/Bo Qty Test Qty Accept/Reject Accept Date Comments The relationship window is tblparts(Part ID #) linked to tbltests (ID #) I get the error message after I enter data and try to enter more information is the test area. What am I doing wrong. Thanks for your help. I have access 2002. "Wayne-I-M" wrote: Thanks for getting back to me - it is always good to get feedback. Good luck with project -- Wayne Manchester, England. Enjoy whatever it is you do Scusate,ma il mio Inglese fa schiffo :-) Percio se non ci siamo capiti, mi mandate un messagio e provero di spiegarmi meglio. "Jane" wrote: Thank you. It sound like what I need. I will let you know how it works. Thank you very much. I'm very new to access. I'm learning by reading alot of the discussions in this group. You guys are the best. Thanks again. "Wayne-I-M" wrote: Hi Jane I think it may be an idea to have another table. tblParts PartID = Autonumber = primary PartName = Text Manufacturer = Text plus any other fields that are unique to the part eg. ToStock Date, Location, etc tblTests ID = Autonumber primary PartID = Number = Linking field from tblParts TestDate = Date Pass = Yes/No Plus anything else specific to "that" test. eg. Grade given, test by who, etc Open both the relationship window and drag the PartID over the the link field in tblTest - Assuming that parts must be there before they can be tested (?) I would enforce the referential integrity. Next create a form based on tblParts. Sinlge form Next create a form based on tblTests. Datasheet or continous forms Open frmParts in design view andselect the toolbox and then insert a subform. Use frmTests as the subform and link the partID (hich will be on both forms). Now when you select a part the test dates form will be shown for the part. Hope this help -- Wayne Manchester, England. Enjoy whatever it is you do Scusate,ma il mio Inglese fa schiffo :-) Percio se non ci siamo capiti, mi mandate un messagio e provero di spiegarmi meglio. "Jane" wrote: I have to make a form for testing parts. What I'm doing is put one part number per record and entering each time it is tested. My problem is I don't know how to be able to keep entering data for different days. PART # MANUFACTURER 1234 DANLEE PO # ACCEPT/REJECT DATE COMMENTS ABC XXXXX 11/28/06 XXXXX DEF XXXXX 11/29/06 XXXXX GDI XXXXX 11/30/06 XXXXX How do I set the form up so I can enter daily? Thanks in advance. |
Thread Tools | |
Display Modes | |
|
|