N
Nice Guy
You're right: I don't have a solution for you.
TC
message
..
TC
message
..
TC,
I only posted to the Security board thinking it might be
a security issue. If you don't have a solution, say so,
don't hide behind excuses.
Shouting,
Bill
has-----Original Message-----
Sorry Bill, but you've multiposted this all over the place. Someone else
will doubtless help.
Cheers,
TC
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 switchboarddisplayafilter 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 toREAD-RECORDSONLYAND
.