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  

purpose of subform?



 
 
Thread Tools Display Modes
  #11  
Old December 31st, 2008, 03:12 AM posted to microsoft.public.access.forms
mike
external usenet poster
 
Posts: 3,942
Default purpose of subform?

i'm a hs teacher who took on a project over break (not paid). trying to use
access to streamline teacher recommendation process at our school. right now
each teacher has to fill out a paper form for each student to select which
subjects he/she recommends for the coming year. then guidance has to gather
all the paper forms and figure out which student was recommended for which
class(es), all this in a short turnaround timeframe.

needless to say its not very efficient so i volunteered to try and create a
program to do this so. interface to show list of students and subjects,
allow teacher to select student and subject, then run reports for guidance.

its turning out to be a bigger task than i thought (always is but i'm
getting close

"Gina Whipp" wrote:

Oops forgot about that...

You can't use the wizard to link them... Go to Properties of the Subform

LinkChildField = NameOfStudentIDField in tblStudentSubjects
LinkMasterFields = NameOfComboBox on Main form

Student ID is blank because the form is not linked AND you need to create a
Relationship between the tables with Cascading Updates set to Yes...

You know I'm starting to get the impression I am doing your classwork for
you. Is this an assignment?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II
"mike" wrote in message
...
Gina,

1. - 3. The combo box on the Main Form should be unbound. You do not
need
to save the value for anything.

got it.

4. Subform should be in continuous view and attached to the Main Form
(Link
Fields) StudentID. Then the field Student Subject should be a combo box
using the tblSubjects as the Record Source and the value should be bound
to
the ssStudentSubject.

-how do i (or when in the wizard do i) link the subform to the main form?
-tried setting "Source object" for subform to main form but when i try to
link child/master fields, get message stating "cant link unbound forms"

tried all above 1)new record is created in tblStudentSubject w/ correct
subject from cbo in subform but 2)studentID is blank.




  #12  
Old December 31st, 2008, 03:32 AM posted to microsoft.public.access.forms
Gina Whipp
external usenet poster
 
Posts: 3,500
Default purpose of subform?

Okay, well that explains it... Unfortunately, Access does have a bit of a
'learning curve' that isn't obvious right out of the box. You have few more
days until break is over... you should make it!

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II
"mike" wrote in message
...
i'm a hs teacher who took on a project over break (not paid). trying to
use
access to streamline teacher recommendation process at our school. right
now
each teacher has to fill out a paper form for each student to select which
subjects he/she recommends for the coming year. then guidance has to
gather
all the paper forms and figure out which student was recommended for which
class(es), all this in a short turnaround timeframe.

needless to say its not very efficient so i volunteered to try and create
a
program to do this so. interface to show list of students and subjects,
allow teacher to select student and subject, then run reports for
guidance.

its turning out to be a bigger task than i thought (always is but i'm
getting close

"Gina Whipp" wrote:

Oops forgot about that...

You can't use the wizard to link them... Go to Properties of the Subform

LinkChildField = NameOfStudentIDField in tblStudentSubjects
LinkMasterFields = NameOfComboBox on Main form

Student ID is blank because the form is not linked AND you need to create
a
Relationship between the tables with Cascading Updates set to Yes...

You know I'm starting to get the impression I am doing your classwork for
you. Is this an assignment?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II
"mike" wrote in message
...
Gina,

1. - 3. The combo box on the Main Form should be unbound. You do not
need
to save the value for anything.
got it.

4. Subform should be in continuous view and attached to the Main Form
(Link
Fields) StudentID. Then the field Student Subject should be a combo
box
using the tblSubjects as the Record Source and the value should be
bound
to
the ssStudentSubject.
-how do i (or when in the wizard do i) link the subform to the main
form?
-tried setting "Source object" for subform to main form but when i try
to
link child/master fields, get message stating "cant link unbound forms"

tried all above 1)new record is created in tblStudentSubject w/ correct
subject from cbo in subform but 2)studentID is blank.






  #13  
Old December 31st, 2008, 05:40 AM posted to microsoft.public.access.forms
mike
external usenet poster
 
Posts: 3,942
Default purpose of subform?

Gina,

thx to you more progress

i ended up putting cboStudent in the subform. when i select a student and
subject, it creates a new record in tblStudentSubject correctly.

interface issue: the cboStudent and cboSubject show up in column format on
the subform. is there a way to format to make it more aesthetically pleasing
i.e. some separation between the two cbo's?

"Gina Whipp" wrote:

Okay, well that explains it... Unfortunately, Access does have a bit of a
'learning curve' that isn't obvious right out of the box. You have few more
days until break is over... you should make it!

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II
"mike" wrote in message
...
i'm a hs teacher who took on a project over break (not paid). trying to
use
access to streamline teacher recommendation process at our school. right
now
each teacher has to fill out a paper form for each student to select which
subjects he/she recommends for the coming year. then guidance has to
gather
all the paper forms and figure out which student was recommended for which
class(es), all this in a short turnaround timeframe.

needless to say its not very efficient so i volunteered to try and create
a
program to do this so. interface to show list of students and subjects,
allow teacher to select student and subject, then run reports for
guidance.

its turning out to be a bigger task than i thought (always is but i'm
getting close

"Gina Whipp" wrote:

Oops forgot about that...

You can't use the wizard to link them... Go to Properties of the Subform

LinkChildField = NameOfStudentIDField in tblStudentSubjects
LinkMasterFields = NameOfComboBox on Main form

Student ID is blank because the form is not linked AND you need to create
a
Relationship between the tables with Cascading Updates set to Yes...

You know I'm starting to get the impression I am doing your classwork for
you. Is this an assignment?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II
"mike" wrote in message
...
Gina,

1. - 3. The combo box on the Main Form should be unbound. You do not
need
to save the value for anything.
got it.

4. Subform should be in continuous view and attached to the Main Form
(Link
Fields) StudentID. Then the field Student Subject should be a combo
box
using the tblSubjects as the Record Source and the value should be
bound
to
the ssStudentSubject.
-how do i (or when in the wizard do i) link the subform to the main
form?
-tried setting "Source object" for subform to main form but when i try
to
link child/master fields, get message stating "cant link unbound forms"

tried all above 1)new record is created in tblStudentSubject w/ correct
subject from cbo in subform but 2)studentID is blank.







  #14  
Old December 31st, 2008, 05:44 AM posted to microsoft.public.access.forms
Gina Whipp
external usenet poster
 
Posts: 3,500
Default purpose of subform?

Mike,

Good to know 'cause it's almost midnight here and I need my rest )

Go into design mode of the form (the little blue triangle and move the
fields around/over/up/down...

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

"mike" wrote in message
...
Gina,

thx to you more progress

i ended up putting cboStudent in the subform. when i select a student and
subject, it creates a new record in tblStudentSubject correctly.

interface issue: the cboStudent and cboSubject show up in column format
on
the subform. is there a way to format to make it more aesthetically
pleasing
i.e. some separation between the two cbo's?

"Gina Whipp" wrote:

Okay, well that explains it... Unfortunately, Access does have a bit of
a
'learning curve' that isn't obvious right out of the box. You have few
more
days until break is over... you should make it!

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II
"mike" wrote in message
...
i'm a hs teacher who took on a project over break (not paid). trying
to
use
access to streamline teacher recommendation process at our school.
right
now
each teacher has to fill out a paper form for each student to select
which
subjects he/she recommends for the coming year. then guidance has to
gather
all the paper forms and figure out which student was recommended for
which
class(es), all this in a short turnaround timeframe.

needless to say its not very efficient so i volunteered to try and
create
a
program to do this so. interface to show list of students and
subjects,
allow teacher to select student and subject, then run reports for
guidance.

its turning out to be a bigger task than i thought (always is but i'm
getting close

"Gina Whipp" wrote:

Oops forgot about that...

You can't use the wizard to link them... Go to Properties of the
Subform

LinkChildField = NameOfStudentIDField in tblStudentSubjects
LinkMasterFields = NameOfComboBox on Main form

Student ID is blank because the form is not linked AND you need to
create
a
Relationship between the tables with Cascading Updates set to Yes...

You know I'm starting to get the impression I am doing your classwork
for
you. Is this an assignment?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II
"mike" wrote in message
...
Gina,

1. - 3. The combo box on the Main Form should be unbound. You do
not
need
to save the value for anything.
got it.

4. Subform should be in continuous view and attached to the Main
Form
(Link
Fields) StudentID. Then the field Student Subject should be a
combo
box
using the tblSubjects as the Record Source and the value should be
bound
to
the ssStudentSubject.
-how do i (or when in the wizard do i) link the subform to the main
form?
-tried setting "Source object" for subform to main form but when i
try
to
link child/master fields, get message stating "cant link unbound
forms"

tried all above 1)new record is created in tblStudentSubject w/
correct
subject from cbo in subform but 2)studentID is blank.









  #15  
Old December 31st, 2008, 04:05 PM posted to microsoft.public.access.forms
mike
external usenet poster
 
Posts: 3,942
Default purpose of subform?

Gina,

hope you slept well

Go into design mode of the form (the little blue triangle and move the
fields around/over/up/down...

-when i go into design mode, the cbo's show up as independent boxes inside
the subform which i can move all around (no blue triangles?) but no matter
they still show up as side-by-side columns in form view.

-also i think there will be less incorrect entries if i add a cmdBtn to
allow user(teacher) to confirm selection. else, as soon as a class is
selected its written to tblStudentSubject which i believe will lead to alot
of invalid entries. is that difficult to change?
  #16  
Old December 31st, 2008, 04:14 PM posted to microsoft.public.access.forms
Gina Whipp
external usenet poster
 
Posts: 3,500
Default purpose of subform?

Mike,

Like a rock!!!

1. Are you using Access 2007? Maybe you said but I missed that. In
earlier versions to get to design mode you clicked a blue triangle looking
button. If Access 2007, then you probably have to UNgroup them to get them
to move independently of each other. I THINK this can be done by
right-clicking on one of the boxes and select 'ungroup'. If that doesn't
work I'll have to open my Access 2007 and have a look. Also, if you are
using Datasheet View then they will always be side-by-side no matter where
you move them.

2. Then by all means add the button to add a new record. You know your
users better then anyone.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

"mike" wrote in message
...
Gina,

hope you slept well

Go into design mode of the form (the little blue triangle and move the
fields around/over/up/down...

-when i go into design mode, the cbo's show up as independent boxes inside
the subform which i can move all around (no blue triangles?) but no matter
they still show up as side-by-side columns in form view.

-also i think there will be less incorrect entries if i add a cmdBtn to
allow user(teacher) to confirm selection. else, as soon as a class is
selected its written to tblStudentSubject which i believe will lead to
alot
of invalid entries. is that difficult to change?



  #17  
Old December 31st, 2008, 06:06 PM posted to microsoft.public.access.forms
mike
external usenet poster
 
Posts: 3,942
Default purpose of subform?

Gina,

i'm using 2003.

2. Then by all means add the button to add a new record. You know your
users better then anyone.

since the cbo's are bound to fields in tblStudentSubject, when i select a
cboStudent and then select a cboSubject, it creates a new record in
tblStudentSubject which is what i want. however, i'd like to add a
confirmation step. after user selects subject use a messageDialogBox to
confirm entry.

-i imagine i have to use VBA something like

Private Sub cboSubject_click
MessageDialogBox.show("Confirm entry")
if yes, then add record to table w/ selected item in both cbo's
else, reset cbo's w/out writing a new record
End Sub

will that do it?
  #18  
Old December 31st, 2008, 06:20 PM posted to microsoft.public.access.forms
Gina Whipp
external usenet poster
 
Posts: 3,500
Default purpose of subform?

Yes, that will work...
--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II
"mike" wrote in message
...
Gina,

i'm using 2003.

2. Then by all means add the button to add a new record. You know your
users better then anyone.

since the cbo's are bound to fields in tblStudentSubject, when i select a
cboStudent and then select a cboSubject, it creates a new record in
tblStudentSubject which is what i want. however, i'd like to add a
confirmation step. after user selects subject use a messageDialogBox to
confirm entry.

-i imagine i have to use VBA something like

Private Sub cboSubject_click
MessageDialogBox.show("Confirm entry")
if yes, then add record to table w/ selected item in both cbo's
else, reset cbo's w/out writing a new record
End Sub

will that do it?



  #19  
Old December 31st, 2008, 07:29 PM posted to microsoft.public.access.forms
John W. Vinson
external usenet poster
 
Posts: 18,261
Default purpose of subform?

On Wed, 31 Dec 2008 09:06:01 -0800, mike
wrote:

-i imagine i have to use VBA something like

Private Sub cboSubject_click
MessageDialogBox.show("Confirm entry")
if yes, then add record to table w/ selected item in both cbo's
else, reset cbo's w/out writing a new record
End Sub


I'd actually use the Form's BeforeUpdate event.

HOWEVER...

in my experience this kind of confirmation really ends up being an annoyance.
Users will get to the point that they thoughtlessly just choose OK (and then
ask you to fix up the damage they've done), and it will just waste their time.
"Yes, I wanted to make an entry, that's why I opened the blasted form!!!"
--

John W. Vinson [MVP]
  #20  
Old January 1st, 2009, 03:21 AM posted to microsoft.public.access.forms
mike
external usenet poster
 
Posts: 3,942
Default purpose of subform?

Gina, John (Vinson), and Allen (Browne):

wanted to say thank you for your gracious help. thx to Allen and John i was
able to "properly" construct a DB using relationships, and thx to Gina for
helping me bring it all together.

john: i agree with your point about the confirmation button. going to omit
it for now.

as a teacher, i have an appreciation for people who are willing to share
his/her knowledge for the sake of helping

all in all i've got what i set out the create. could use a few bells and
whistles but i can fiddle with it now.

Regards.
Mike


"Gina Whipp" wrote:

Yes, that will work...
--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II
"mike" wrote in message
...
Gina,

i'm using 2003.

2. Then by all means add the button to add a new record. You know your
users better then anyone.

since the cbo's are bound to fields in tblStudentSubject, when i select a
cboStudent and then select a cboSubject, it creates a new record in
tblStudentSubject which is what i want. however, i'd like to add a
confirmation step. after user selects subject use a messageDialogBox to
confirm entry.

-i imagine i have to use VBA something like

Private Sub cboSubject_click
MessageDialogBox.show("Confirm entry")
if yes, then add record to table w/ selected item in both cbo's
else, reset cbo's w/out writing a new record
End Sub

will that do it?




 




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


All times are GMT +1. The time now is 09:16 PM.


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