By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,493 Members | 1,179 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,493 IT Pros & Developers. It's quick & easy.

Create a new Form from based on a 'Filter By Selection'

P: n/a
I have cerated a Form, ExamsFrm, which is used to input details of
exams taken at several Centres. It dosplays details from StudentTbl
and has a SubForm which displays details from ExamsTble.

I have incorporated some VB6 code as well as some Conditional
Formatting. The code automatically updates CheckBoxes in the SubForm,
depending on exam results, and the Conditional Formatting changes
background colours, depending on CheckBox datum.

I have created a Main Switchboard with absolute minimum Startup
options for security reasons, which means that the user is not allowed
to filter records.

I intend having controls to access data from each centre e.g. EXAMS
CTR1, EXAMS CTR2, etc. and obviously need to create a new Form for
each Centre.

Is it be possible to create a new Form for each Centre by saving the
results of a 'Filter By Selection' (from ExamsFrm, Centre), as a new
Form which retains all codes, formatting, layout, etc?

Or will I have to create each Form from scratch?

Terry
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Why not create a table of ExamCentres, have a combo box (ExamCenterID) on
your form to select the appropriate exam centre and have the underlying
query with a criteria of WHERE ExamCenterID = Forms!ExamsFrm!ExamCenterID

OR

You can copy and paste a form and change the name. Only problem is if you
have any code and that refers to the form by name, you will have to alter
the code to reflect the name of the new form.

But somewhere you will have to define which exam center you are referring to
and a filter good if you are looking for information, but messy if you know
the information you are looking for.

HTH

Phil
"Terry" <tc*****@merseymail.com> wrote in message
news:38**************************@posting.google.c om...
I have cerated a Form, ExamsFrm, which is used to input details of
exams taken at several Centres. It dosplays details from StudentTbl
and has a SubForm which displays details from ExamsTble.

I have incorporated some VB6 code as well as some Conditional
Formatting. The code automatically updates CheckBoxes in the SubForm,
depending on exam results, and the Conditional Formatting changes
background colours, depending on CheckBox datum.

I have created a Main Switchboard with absolute minimum Startup
options for security reasons, which means that the user is not allowed
to filter records.

I intend having controls to access data from each centre e.g. EXAMS
CTR1, EXAMS CTR2, etc. and obviously need to create a new Form for
each Centre.

Is it be possible to create a new Form for each Centre by saving the
results of a 'Filter By Selection' (from ExamsFrm, Centre), as a new
Form which retains all codes, formatting, layout, etc?

Or will I have to create each Form from scratch?

Terry

Nov 12 '05 #2

P: n/a
Thanks Phil. I had a dabble at your suggestions but couldn't get them
to work. This is mainly due to the fact that I am a complete Newbee
but have gained a lot if confidence/overconfidence through
correspondence with this group. Though I guess you may have sussed
this by my question;-)

But also my heart wasn't really in it because I have set my Form to
display as Datasheet on open (should have mentioned this in my
scenario). The reason for this is that I think this makes it easier
for users to enter mutiple records, on a single screen, without having
to search individual records on a standard Form.

However I'm still finding it difficult to accept the fact that there
isn't a built in facility, among the myriad of other facilities, to
save the results of a Filter By Selection as a new Form, as it would
be so useful if it were at all possible.

It was just an idea and if it can't be done I'll work around it
somehow.

Thanks for your help.

PS Once this project is finished I really do intend looking at
tutorials as hacking it is really hard work:-)

Terry

"Phil Stanton" <di********@stantonfamily.co.uk> wrote in message news:<3f***********************@mercury.nildram.ne t>...
Why not create a table of ExamCentres, have a combo box (ExamCenterID) on
your form to select the appropriate exam centre and have the underlying
query with a criteria of WHERE ExamCenterID = Forms!ExamsFrm!ExamCenterID

OR

You can copy and paste a form and change the name. Only problem is if you
have any code and that refers to the form by name, you will have to alter
the code to reflect the name of the new form.

But somewhere you will have to define which exam center you are referring to
and a filter good if you are looking for information, but messy if you know
the information you are looking for.

HTH

Phil
"Terry" <tc*****@merseymail.com> wrote in message
news:38**************************@posting.google.c om...
I have cerated a Form, ExamsFrm, which is used to input details of
exams taken at several Centres. It dosplays details from StudentTbl
and has a SubForm which displays details from ExamsTble.

I have incorporated some VB6 code as well as some Conditional
Formatting. The code automatically updates CheckBoxes in the SubForm,
depending on exam results, and the Conditional Formatting changes
background colours, depending on CheckBox datum.

I have created a Main Switchboard with absolute minimum Startup
options for security reasons, which means that the user is not allowed
to filter records.

I intend having controls to access data from each centre e.g. EXAMS
CTR1, EXAMS CTR2, etc. and obviously need to create a new Form for
each Centre.

Is it be possible to create a new Form for each Centre by saving the
results of a 'Filter By Selection' (from ExamsFrm, Centre), as a new
Form which retains all codes, formatting, layout, etc?

Or will I have to create each Form from scratch?

Terry

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.