how to hide record control

  • Thread starter Thread starter mark R.
  • Start date Start date
M

mark R.

There are these record advancers at the bottom
of subforms, just as in forms.

I do not want the user to change records in the subform.
How do I remove or hide them.

I believe it partly depends on how I created the subform

1) if I let the wizard create the subform, and I right
click on the subform in design view, then "subform in New
window" is not an active option.

2) if I drag in a prior created form to use as a subform
on my main form, I can use "subform in New window" but
when I click on properties and select FormFooter, I see no
way of removing the record advancer.

Also, an additional problem I am having with option 2, is
that I don't know how to get the "Dragged in subform" to
automatically "start the next record" (in the one to MANY
relationship) the way OPTION 1 above - not only
automatically starts the next record, but still shows all
previous records for the primary key-foreign key
relationship.

Example:

subform using OPTION 1:

ID field 1 field 2

63 apple red
63 banana yellow
___ ______ ______


subform using"drag option2":

ID field1 field2
[63] [apple] [red]
 
Go to the Form properties and in the Format tab change
the Nav Records to NO. YOu can change all the various
setting to make the form essentially look like a dialog
box with no way to change a record. Play with all the
setting on that tab, you can customize your forms nicely
with these small but rather helpful properties.

Drew
 
Like Drew says, you CAN change the Navigation buttons for a sub form. Are
you sure you are clicking in the SubForms properties (and not the sub form
Controls properties). Open the sub form on its own and play with the
properties there. However, you are not going to get out of the fact that
users can use the wheel mouse to change between records so your problem will
still exist. To eliminate all possibilities, you can:

a) visit Steven Lebans website (http://www.lebans.com/toc.htm) and download
a usefull utility that he has created to turn the mouse wheel on/off (still
need to prevent the user from pressing ctl+PageDown/PageUp key combinations
tho...)
or
b) Code the BeforeUpdate event to block any unwanted additions to your
subform (you can cancel the update event).

HTH,

Neil.

mark R. said:
Drew,

Thanks....close but no cigar.

I of course realize that that Nav buttons exists, but what
you failed to explain is that they exist for the FORM
selection on the pull down menu of properties FOR THE MAIN
FORM.

If you right click properties for a subform, there IS NO
NAV BUTTONS choice !!! Please read my first post with more
care and you will notice I was asking about SUBFORMS and
two ways that they can be created.

-----Original Message-----
Go to the Form properties and in the Format tab change
the Nav Records to NO. YOu can change all the various
setting to make the form essentially look like a dialog
box with no way to change a record. Play with all the
setting on that tab, you can customize your forms nicely
with these small but rather helpful properties.

Drew
-----Original Message-----
There are these record advancers at the bottom
of subforms, just as in forms.

I do not want the user to change records in the subform.
How do I remove or hide them.

I believe it partly depends on how I created the subform

1) if I let the wizard create the subform, and I right
click on the subform in design view, then "subform in New
window" is not an active option.

2) if I drag in a prior created form to use as a subform
on my main form, I can use "subform in New window" but
when I click on properties and select FormFooter, I see no
way of removing the record advancer.

Also, an additional problem I am having with option 2, is
that I don't know how to get the "Dragged in subform" to
automatically "start the next record" (in the one to MANY
relationship) the way OPTION 1 above - not only
automatically starts the next record, but still shows all
previous records for the primary key-foreign key
relationship.

Example:

subform using OPTION 1:

ID field 1 field 2

63 apple red
63 banana yellow
___ ______ ______


subform using"drag option2":

ID field1 field2
[63] [apple] [red]

.
Click to expand...
.
Click to expand...
Click to expand...
 
1st, I created the form using the wizard, so is the
subform still accessible from the database window as a
separate form?

2nd: what kind of code do you use in the beforeupdate to
cancel aDDITIONS AS YOU SAY? something along the lines if
foreign key does not equal primary key then do not show
record?




-----Original Message-----
Like Drew says, you CAN change the Navigation buttons for a sub form. Are
you sure you are clicking in the SubForms properties (and not the sub form
Controls properties). Open the sub form on its own and play with the
properties there. However, you are not going to get out of the fact that
users can use the wheel mouse to change between records so your problem will
still exist. To eliminate all possibilities, you can:

a) visit Steven Lebans website
Click to expand...
(http://www.lebans.com/toc.htm) and download
a usefull utility that he has created to turn the mouse wheel on/off (still
need to prevent the user from pressing
Click to expand...
ctl+PageDown/PageUp key combinations
tho...)
or
b) Code the BeforeUpdate event to block any unwanted additions to your
subform (you can cancel the update event).

HTH,

Neil.

mark R. said:
Drew,

Thanks....close but no cigar.

I of course realize that that Nav buttons exists, but what
you failed to explain is that they exist for the FORM
selection on the pull down menu of properties FOR THE MAIN
FORM.

If you right click properties for a subform, there IS NO
NAV BUTTONS choice !!! Please read my first post with more
care and you will notice I was asking about SUBFORMS and
two ways that they can be created.

-----Original Message-----
Go to the Form properties and in the Format tab change
the Nav Records to NO. YOu can change all the various
setting to make the form essentially look like a dialog
box with no way to change a record. Play with all the
setting on that tab, you can customize your forms nicely
with these small but rather helpful properties.

Drew

-----Original Message-----
There are these record advancers at the bottom
of subforms, just as in forms.

I do not want the user to change records in the subform.
How do I remove or hide them.

I believe it partly depends on how I created the subform

1) if I let the wizard create the subform, and I right
click on the subform in design view, then "subform in
New
window" is not an active option.

2) if I drag in a prior created form to use as a subform
on my main form, I can use "subform in New window" but
when I click on properties and select FormFooter, I see
no
way of removing the record advancer.

Also, an additional problem I am having with option 2,
is
that I don't know how to get the "Dragged in subform" to
automatically "start the next record" (in the one to
MANY
relationship) the way OPTION 1 above - not only
automatically starts the next record, but still shows
all
previous records for the primary key-foreign key
relationship.

Example:

subform using OPTION 1:

ID field 1 field 2

63 apple red
63 banana yellow
___ ______ ______


subform using"drag option2":

ID field1 field2
[63] [apple] [red]

.

.
Click to expand...
Click to expand...


.
Click to expand...
 
Wait, I think I found some critical information as to the
mystery.

my source object says table.tablexyz not subformname_xyz

So what's the difference?

Had I dragged a table into the subform window and not a
form?

Is that why I can't access the subform?
-----Original Message-----
Like Drew says, you CAN change the Navigation buttons for a sub form. Are
you sure you are clicking in the SubForms properties (and not the sub form
Controls properties). Open the sub form on its own and play with the
properties there. However, you are not going to get out of the fact that
users can use the wheel mouse to change between records so your problem will
still exist. To eliminate all possibilities, you can:

a) visit Steven Lebans website
Click to expand...
(http://www.lebans.com/toc.htm) and download
a usefull utility that he has created to turn the mouse wheel on/off (still
need to prevent the user from pressing
Click to expand...
ctl+PageDown/PageUp key combinations
tho...)
or
b) Code the BeforeUpdate event to block any unwanted additions to your
subform (you can cancel the update event).

HTH,

Neil.

mark R. said:
Drew,

Thanks....close but no cigar.

I of course realize that that Nav buttons exists, but what
you failed to explain is that they exist for the FORM
selection on the pull down menu of properties FOR THE MAIN
FORM.

If you right click properties for a subform, there IS NO
NAV BUTTONS choice !!! Please read my first post with more
care and you will notice I was asking about SUBFORMS and
two ways that they can be created.

-----Original Message-----
Go to the Form properties and in the Format tab change
the Nav Records to NO. YOu can change all the various
setting to make the form essentially look like a dialog
box with no way to change a record. Play with all the
setting on that tab, you can customize your forms nicely
with these small but rather helpful properties.

Drew

-----Original Message-----
There are these record advancers at the bottom
of subforms, just as in forms.

I do not want the user to change records in the subform.
How do I remove or hide them.

I believe it partly depends on how I created the subform

1) if I let the wizard create the subform, and I right
click on the subform in design view, then "subform in
New
window" is not an active option.

2) if I drag in a prior created form to use as a subform
on my main form, I can use "subform in New window" but
when I click on properties and select FormFooter, I see
no
way of removing the record advancer.

Also, an additional problem I am having with option 2,
is
that I don't know how to get the "Dragged in subform" to
automatically "start the next record" (in the one to
MANY
relationship) the way OPTION 1 above - not only
automatically starts the next record, but still shows
all
previous records for the primary key-foreign key
relationship.

Example:

subform using OPTION 1:

ID field 1 field 2

63 apple red
63 banana yellow
___ ______ ______


subform using"drag option2":

ID field1 field2
[63] [apple] [red]

.

.
Click to expand...
Click to expand...


.
Click to expand...
 
Back
Top