TC from below asks:
Is that correct?
Bill T replies: Yes
Is the relevant DoCmd.OpenForm statement either the form
properties filter statement or On Open event procedure?
If so, it was created from the Switchboard Manager.
When I remove the filter or the on open event procedure
[ItemNumber] = 0 AND [Argument] = 'Default'
the other buttons on the switchboard won't work so I'm
assuming those filters are related to how the buttons
work on the switchboard and not to records on the other
form. It sounds as though the behavior I'm seeing is
how all Access Applications behave. You cannot have
User Level Security with a Full Data group and a Read-
Only group use the same form through a button on the
Switchboard. Or can you cause that would be the ultimate
way to use it? I've copied the form and chose a New Data
group instead of Read-Only group and made form2 have
properties Allow Additions set to No so it works like
read-only but now I have two buttons on the switchboard
and two forms -which seems redundant. It should be easier
,no?
Bill
-----Original Message-----
So, when you are logged-in as a member of the read- only
group:
- the form displays some records when it is started
directly (bypassing the
switchboard form), but
- the form displays blank when it is started from the
switchboard form.
Is that correct?
If so, the switchboard form is presumably applying a
filter when it starts
the other form. That filter would be defined on the
relevant DoCmd.OpenForm
statement in the switchboard form. Is that what you mean
by: "The
switchboard has a filter of: [ItemNumber] = 0 AND
[Argument] = 'Default'"?
If so, then there is your problem: there are no records
matching those
criteria! That is, there are no >matching< records for
the form to display.
So, you must either:
1. >remove< that filter criteria, or
2. add some records that match it, or
3. modify the other form so it does >not< display blank
when there are no
records to display, or
4. accept that the behaviour you are seeing, is "as
designed" behaviour for
your application.
Does that help?
TC
message
Thanks for the etiquette tips. I was trying to make my
post stand out, I'm sorry -but now I know.
The form works as read-only for the read-only group
when I bypass the switchboard. The switchboard has a
filter of: [ItemNumber] = 0 AND [Argument] = 'Default'
It also has an On Open [Event Procedure] of:
' Move to the switchboard page that is marked as the
default.
Me.Filter = "[ItemNumber] = 0 AND
[Argument]'Default' "
Me.FilterOn = True
And an On Current [Event Procedure] of:
' Update the caption and fill in the list of options.
Me.Caption = Nz(Me![ItemText], "")
FillOptions
Is there a way I can change any of this so the form
works
for the read-only group when it is selected from the
switchboard? Your help is highly appreciated!
Bill
-----Original Message-----
Bill, two things about newsgroup etiquette first.
(1) DON'T SHOUT. All-caps is considered to be
shouting,
therefore rude, in
most newsgroups.
(2) If a respondent adds his reply >below< your
question, please add your
reply below his. That is called "bottom posting". If
he
adds his reply
above< your question, add your reply above his. That
is
called "top
posting". Do not mix it up as you have done. That is a
sure way to make the
thread unreadable, after a few exchanges.
As for your problem, if a form opens showing no
controls, there is only one
explanation AFAIK: there are no records to display for
that user, >and<,
that user is not allowed to add new records: either
because of his
permissions on the table concerned, or because the
form
itself does not
allow additions.
So, logically speaking, you must be mistaken in saying
that there are lots
of existing records for the read-only users to see.
For
example, when you
checked that, did you log on >as one of those read-
only
users<? Or did you
log-on as a read/write user, check the tables, and
deduce which records you
think< the read-only users should be able to see?
Log-on >as a read-only user<, check there are records
in
the underlying
table, then open the form directly (bypassing the
switchboard) & tell us
what happens. Maybe a filter in the switchboard DoCmd
call (or in the form
itself) is preventing those users from seeing the
records you think they
should be able to see.
HTH,
TC
in
message
RICK,
THERE ARE LOTS OF EXISTING RECORDS FOR THE READ- ONLY
USERS TO SEE. COULD THE PROBLEM BE BECAUSE THE
READ-ONLY USERS HAVE NO ABILITY TO ADD NEW RECORDS,
HENCE THE "READ-ONLY"? OTHER USER GROUPS THAT HAVE
FULL DATA OR ADD DATA RIGHTS CAN ADD NEW RECORDS AND
SEE THE FORM JUST FINE.
THANKS,
BILL
-----Original Message-----
"BILL T" <
[email protected]>
wrote
in
message
I set up user level security on my Access 2000
Application and the Read-Only group isn't able to
view
my form. When they click on the switchboard
button
to
open the form it opens as a completely blank form
with
no controls on it. I prefer them to be able to
see
it
in read-only mode but the only way I can get it
to
show
up is if I make them a New Data User Group. I
don't
want them to be able to add new data and was
hoping
someone knew how to make the form viewable for
the
read-only group.
Thank You
The detail section of a form will appear completely
blank when there are no
records to display and no ability to add new ones.
Your read-only users should not get a blank form
unless
there are no
existing records to see. Are there any?
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
.
.
.
