Page breaks and command buttons

[Shazza]

working in access 2000 I want to create a form to input student details and
rather than creating lots of individual forms i thought i would put them into
one with page breaks and command buttons to take the user to each different
page but i can not get it to work. My command button does absolutely nothing
and when i try to direct it to another page it doesnt give me a list of
options even though i have inserted my page breaks into the form design

Please help io am getting most frustrated and none of my books tell me what
to do

 

[Golfinray]

Normally, you would want to set up one main form and multiple subforms on and
linked to the main form. You may have to have more than one mainform with
subforms on each. As a rule, if your command button wizard is not asking you
how you want the command button to work, there would be issues causing it to
do so. Your subforms may not relate properly, the command button wizard does
not see the form you are trying to open, or a host of other problems. If your
tables are not properly related, queries are not working properly, or you
have controls set wrong, all of these could be causing the problem.

 

[John Spencer]

A better solution (in my opinion) is to use a tab control and put the page
items on separate tabs.

The best way to move to a page might be to set focus to the first control on
the page.

--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[John W. Vinson]

working in access 2000 I want to create a form to input student details

STOP!

Take your hands off the keyboard, and step away from the computer. <g>


If you're beginning your design with a Form, it's like starting to assemble
the walls of a house before you even know where the foundation will be poured.

See your other thread, and get the table structures and relationships right
FIRST.

You will end up using Forms with Subforms, and probably a master Switchboard
form to allow specific forms to be opened. You will almost certainly *not*
construct One Great Master Form with all the fields in all your tables on it,
that's just not how Access works!

 

[Shazza]

a bit about what i am trying to do
Ok here goes at the moment we are putting far to much data onto excel about
young skillseeders and the courses they do along with their employer. so
they sent me on a 1 day introduction to Access course so that i could build
up a
database to hold all of the information. The tables i have set up are as
follows:
Delegate details (showing where they live and contact details,
delegate requirements to see if they need accommodation and what type =
start and end dates for courses.
Lodging Information for if they need accommodation detailing their contact
info
College details showing contact details
Company details showing contact info
Courses stating what colleges offer what
course level options to show what levels each delegate has achieved and
Course details showing costs course names start and end detas etc
Now i am under the impression that i have to have the national insurance
number in each of the tables (my unique identifier for each delegate) so that
i can print of reports showing how much each delegate cost, which areas they
are from, what courses they have taken and where they went to work etc etc
which is a bind because i have to enter the NI number an awful lot of times.
am i correct in thinking this because i cant think of a way of linking all of
the information together. I did try one big form that was going to have
several different pages but that didn't work and now i know why. My tables
arn't set up properly yet!!!!!!!!
thank you for your help its much appreciated
Sharon

 

[John W. Vinson]

a bit about what i am trying to do
Ok here goes at the moment we are putting far to much data onto excel about
young skillseeders and the courses they do along with their employer. so
they sent me on a 1 day introduction to Access course so that i could build
up a
database to hold all of the information. The tables i have set up are as
follows:
Delegate details (showing where they live and contact details,
delegate requirements to see if they need accommodation and what type =
start and end dates for courses.

Please clarify. I have no idea what the phrase

what type = start and end dates for courses

might mean. Could you perhaps just list the fieldnames, their datatypes, and
how they will be used? In particular, what is the Primary Key of each table?
If the table doesn't have a primary key... then it's not a table, it's a heap.

Lodging Information for if they need accommodation detailing their contact
info

Sounds like two completely different things. Need for accommodation and
contact info are (unless I misunderstand) two unrelated sets of data.

College details showing contact details
Company details showing contact info
Courses stating what colleges offer what
course level options to show what levels each delegate has achieved and
Course details showing costs course names start and end detas etc
Now i am under the impression that i have to have the national insurance
number in each of the tables (my unique identifier for each delegate)

No. You certainly do NOT. You're missing the point of how relationships
work!!!!

A College DOES NOT HAVE A NATIONAL INSURANCE NUMBER.

A college could have many students. They would all have different NINs. Right?
Which NIN do you put into the college table?

so that

i can print of reports showing how much each delegate cost, which areas they
are from, what courses they have taken and where they went to work etc etc
which is a bind because i have to enter the NI number an awful lot of times.

You need to enter the NIN *once* for each student and then never again. You
will probably *select* it from a Combo Box fairly often but I can't see why
you would ever need to type it again.

am i correct in thinking this because i cant think of a way of linking all of
the information together.

LOGICALLY, using the principles of Database Normalization - which, if you
don't understand, you will need to learn!!

Again: see the tutorials listed below. Crystal's introduction might be
particularly apropos.

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

I did try one big form that was going to have
several different pages but that didn't work and now i know why. My tables
arn't set up properly yet!!!!!!!!

They certainly aren't.

 

[Shazza]

Sorry the what type= ... was a typo it should have been a comma it was
supposed to read what type of accommodation they required and the start and
end dates for the courses.
I have completely scrapped what i am doing after reading the turorial you
sent the link for. It was very helpful and even more amazingly it made sence
to me. I am now surrounded with bits of paper pensils and a rubber. thanks
for your help no doubt you will be hearing from me again once i get back onto
access

 

[John W. Vinson]

I have completely scrapped what i am doing after reading the turorial you
sent the link for. It was very helpful and even more amazingly it made sence
to me. I am now surrounded with bits of paper pensils and a rubber. thanks
for your help no doubt you will be hearing from me again once i get back onto
access

We'll be glad to help. Sounds like you're now on the right track!