S
sam1967
What is the best way to make a read-only form (the form can be used
to view data but not change the data in any way).
to view data but not change the data in any way).
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
Kevin3NF
Create the form and set the following properties of the form to NO:
Allow Edits
Allow Deletions
Kevin3NF
Allow Edits
Allow Deletions
Kevin3NF
M
mark
Why don't you just create a report which is, by
definition, read only?
definition, read only?
S
sam1967
i did that - also Allow Additions - and it worked great.Create the form and set the following properties of the form to NO:
Allow Edits
Allow Deletions
only problem is I had a jump to record control using a combo box (it
jumped straight to the record id you typed in) and it stopped working
.. any idea why ?
J
John Vinson
What is the best way to make a read-only form (the form can be used
to view data but not change the data in any way).
Set its AllowEdits property to True; or (or also) open its
Recordsource and save it as an uneditable query. One simple way to do
so if the table isn't too big (performance hit!) is to make it a
Totals query and just group by all fields.
S
sam1967
Why don't you just create a report which is, by
definition, read only?
good idea. would that allow me to view each record a page at a time
and to implement a "jump to record" feature ?
K
Ken Snell
John - Did you mean to set AllowEdits to False?
J
John Vinson
John - Did you mean to set AllowEdits to False?
oops!
Quite correct, thanks for the catch!
D
Dirk Goldgar
i did that - also Allow Additions - and it worked great.
only problem is I had a jump to record control using a combo box (it
jumped straight to the record id you typed in) and it stopped working
. any idea why ?
Unfortunately, when you tell Access that a form can't be edited, Access
takes that to mean that *none* of the controls on the form are allowed
to be changed by the user; not even unbound controls. This is
annoying, as it means handy gadgets like your "jump to" combo won't
work. There are two ways you might solve that problem:
1. You could set the form's AllowEdits property to Yes, but also set the
Locked property of each bound control on the form to Yes. Then the user
couldn't change those controls, but you could leave the "jump to" combo
unlocked.
2. You could tinker with the form's recordsource query to make it
nonupdatable, as John Vinson mentioned.