Re: Locking Forms

Tech-Archive recommends: Fix windows errors by optimizing your registry



"Tom van Stiphout" wrote:

On Sun, 12 Oct 2008 10:26:01 -0700, Janna
<Janna@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

=LockBoundControls([Form], not Isnull(me.dateappr))

-Tom.
Microsoft Access MVP


I've used Allen Browne's Locking bound control codes
(http://allenbrowne.com/ser-56.html) to prevent overwriting data accidentally
My On Load property of the form is set to

=LockBoundControls([Form],True)

How might I change the above code so that if a specific date field is empty
on the form [dateappr], the form does not come up locked, but in all other
instances, it's locked when it opens?

Thank you.

.

Relevant Pages

  • Re: Locking Forms
    ... Microsoft Access MVP ... My On Load property of the form is set to ... on the form [dateappr], the form does not come up locked, but in all other ... it's locked when it opens? ...
    (microsoft.public.access.formscoding)
  • Re: Locking Forms
    ... Thank you for the prompt reply. ... "Tom van Stiphout" wrote: ... Microsoft Access MVP ... My On Load property of the form is set to ...
    (microsoft.public.access.formscoding)
  • Re: Three fields conditionally based on other fields
    ... "Tom van Stiphout" wrote: ... Microsoft Access MVP ... "Josh" wrote: ... (where PhoneType = "Email") ...
    (microsoft.public.access.queries)
  • Re: Secured db now events failing
    ... "Tom van Stiphout" wrote: ... The MDW would reside on the server, and as Joan alrealy said, the ... Microsoft Access MVP ... have set the permissions for each user which works fine on my machine from ...
    (microsoft.public.access.security)
  • Re: Filter form using multiple combo boxes selection
    ... "Tom van Stiphout" wrote: ... Microsoft Access MVP ... Me!subform2.Form.Filter = strFilter ... ClientID is FK, Dept – FK, Exception Type – FK, .. ...
    (microsoft.public.access.formscoding)