L
linronamy
Am having difficulty with form design. After many attempts at trying To setup
a form design to allow data entry for a set(record) of data, I have failed
to achieve any workable results. I have done a lot of reading and reviewed
several tutorials without seeing the detailed choice descriptions allowing me
to succeed. The following are the tables in my database:
tblLiturgies
LitID (primary key, Number, field size Byte)
LitName (Text)
tblCycles
CycleID (pk, Number, field size Byte)
CycleName (Text)
tblLiturgyParts
PartID (pk, Number, field size Byte)
PartCode (Text; entries in this field would be "Prl", "InProc", "Gath", etc)
PartName (Text; entries in this field would be "Prelude", "Instrumental
Procession", "Gathering", etc)
tblHymns
HymnID (pk, Number, field size Byte)
HymnName (TEXT)
HymnNumber (TEXT)
tblLiturgyEvents
LitEventID (pk, Autonumber)
LitID (foreign key from tblLiturgies)
CycleID (fk from tblCycles)
EventDate (the particular date that this particular liturgy was delivered)
tblEventDetails
DetailID (pk, Autonumber)
LitEventID (fk from tblLiturgyEvents)
PartID (fk from tblLiturgyParts)
HymnID (fk from tblHymns)
the relationships are:
tblLiturgies.LitID 1:n tblLiturgyEvents.LitID
tblCycles.CycleID 1:n tblLiturgyEvents.CycleID
tblLiturgyEvents.LitEventID 1:n tblEventDetails.LitEventID
tblLiturgyParts.PartID 1:n tblEventDetails.PartID
tblHymns.HymnID 1:n tblEventDetails.HymnID
My Main data tables are tblLiturgyEvents and tblEventDetails
Form design process:
• Selected “CREATE FORM BY USING WIZARD.â€
• The first question is “WHICH FIELDS DO I WANT ON FORM?â€
• I selected each table and the required fields as suggested.
o tblLitugies: LitName
o tblCycles: CycleName
o tblLitParts: PartCode, PartName
o tbl Hymns: HymnName, HymnNumber
• Next question is “HOW DO I WANT TO VIEW MY FORM?â€
o Choices are FORM WITH SUBFORM(S) or LINKED FORM
• Selected Form with Subform(s)
• Next question is “WHAT LAYOUT WOULD YOU LIKE FOR EACH SUBFORM?â€
o Used the default DATASHEET
• Selected the EXPEDITION style
• Selected titles for each form:
o FORM – Liturgies
o SUBFORM – Cycles Subform
o SUBFORM – Hymns Subform
Results: LitName field with drop down choice
Cycles subform with CycleName field and drop down choice
Hymns subform with PartCode, PartName, HymnName, HymnNumber fields and
No drop down choices.
• Upon attempting to input data I found the following:
• LitName field accepted data and allowed drop down choice
o Using the TAB key I found the cursor moved to the next record in that
field NOT THE NEXT FIELD on the form??? Do I need to specify
an ON
CLICK {event procedure} to the next field?
o CycleName field accepted data and allowed drop down choice with
same TAB key results.
• Upon choosing the PartCode field with the mouse I attempted to enter
data and got FIELD CANNOT BE UPDATED error message??? After selecting
the
OK button in the error message box the box went away and the cursor was
located after the character entered in the PartCode field and I was able
to enter
the data in the all the fields in the subform.
I have navigation controls in all three forms.
• I expected only the Main form controls hoping to enter data into each
field and moving to the next record.
• I am confused by my need to enter 11 unique parts with corresponding
Hymns and Hymn numbers into each record but there is only the ability
to enter
one part/hymn/hymn number per record.
I am sure there is a way but I do not understand enough to make it happen. I
have spent the last three weeks researching using the HELP feature of ACCESS
2003, recommended tutorials (DataPig Technologies were excellent) (DATABASE
DESIGN TIPS by Michael J. Hernandez) (CONRAD SYSTEMS DESIGN’s Database Design
101) , STEP BY STEP ACCESS 2003 by Online Training Solutions, Inc., HOW TO DO
EVERYTHING WITH ACCESS 2003 by Virginia Anderson. I have a sense of “Brain
dead†with form design but wish to go forward. Any suggestions on how to
proceed are most welcome. THANX
a form design to allow data entry for a set(record) of data, I have failed
to achieve any workable results. I have done a lot of reading and reviewed
several tutorials without seeing the detailed choice descriptions allowing me
to succeed. The following are the tables in my database:
tblLiturgies
LitID (primary key, Number, field size Byte)
LitName (Text)
tblCycles
CycleID (pk, Number, field size Byte)
CycleName (Text)
tblLiturgyParts
PartID (pk, Number, field size Byte)
PartCode (Text; entries in this field would be "Prl", "InProc", "Gath", etc)
PartName (Text; entries in this field would be "Prelude", "Instrumental
Procession", "Gathering", etc)
tblHymns
HymnID (pk, Number, field size Byte)
HymnName (TEXT)
HymnNumber (TEXT)
tblLiturgyEvents
LitEventID (pk, Autonumber)
LitID (foreign key from tblLiturgies)
CycleID (fk from tblCycles)
EventDate (the particular date that this particular liturgy was delivered)
tblEventDetails
DetailID (pk, Autonumber)
LitEventID (fk from tblLiturgyEvents)
PartID (fk from tblLiturgyParts)
HymnID (fk from tblHymns)
the relationships are:
tblLiturgies.LitID 1:n tblLiturgyEvents.LitID
tblCycles.CycleID 1:n tblLiturgyEvents.CycleID
tblLiturgyEvents.LitEventID 1:n tblEventDetails.LitEventID
tblLiturgyParts.PartID 1:n tblEventDetails.PartID
tblHymns.HymnID 1:n tblEventDetails.HymnID
My Main data tables are tblLiturgyEvents and tblEventDetails
Form design process:
• Selected “CREATE FORM BY USING WIZARD.â€
• The first question is “WHICH FIELDS DO I WANT ON FORM?â€
• I selected each table and the required fields as suggested.
o tblLitugies: LitName
o tblCycles: CycleName
o tblLitParts: PartCode, PartName
o tbl Hymns: HymnName, HymnNumber
• Next question is “HOW DO I WANT TO VIEW MY FORM?â€
o Choices are FORM WITH SUBFORM(S) or LINKED FORM
• Selected Form with Subform(s)
• Next question is “WHAT LAYOUT WOULD YOU LIKE FOR EACH SUBFORM?â€
o Used the default DATASHEET
• Selected the EXPEDITION style
• Selected titles for each form:
o FORM – Liturgies
o SUBFORM – Cycles Subform
o SUBFORM – Hymns Subform
Results: LitName field with drop down choice
Cycles subform with CycleName field and drop down choice
Hymns subform with PartCode, PartName, HymnName, HymnNumber fields and
No drop down choices.
• Upon attempting to input data I found the following:
• LitName field accepted data and allowed drop down choice
o Using the TAB key I found the cursor moved to the next record in that
field NOT THE NEXT FIELD on the form??? Do I need to specify
an ON
CLICK {event procedure} to the next field?
o CycleName field accepted data and allowed drop down choice with
same TAB key results.
• Upon choosing the PartCode field with the mouse I attempted to enter
data and got FIELD CANNOT BE UPDATED error message??? After selecting
the
OK button in the error message box the box went away and the cursor was
located after the character entered in the PartCode field and I was able
to enter
the data in the all the fields in the subform.
I have navigation controls in all three forms.
• I expected only the Main form controls hoping to enter data into each
field and moving to the next record.
• I am confused by my need to enter 11 unique parts with corresponding
Hymns and Hymn numbers into each record but there is only the ability
to enter
one part/hymn/hymn number per record.
I am sure there is a way but I do not understand enough to make it happen. I
have spent the last three weeks researching using the HELP feature of ACCESS
2003, recommended tutorials (DataPig Technologies were excellent) (DATABASE
DESIGN TIPS by Michael J. Hernandez) (CONRAD SYSTEMS DESIGN’s Database Design
101) , STEP BY STEP ACCESS 2003 by Online Training Solutions, Inc., HOW TO DO
EVERYTHING WITH ACCESS 2003 by Virginia Anderson. I have a sense of “Brain
dead†with form design but wish to go forward. Any suggestions on how to
proceed are most welcome. THANX