Re: Locking Forms

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

Thank you for the prompt reply. I did try the code, but it didn't enable the
form to open unlocked if the date field was emply.

"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
    ... "Tom van Stiphout" wrote: ... 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 ...
    (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: Why/when does close save?
    ... > to do is trap the close event before it saves, ... close the form, and this, of course, puts you back in the position of getting ... add a prompt to the code behind the "Save" button and change the ... Bruce M. Thompson, Microsoft Access MVP ...
    (microsoft.public.access.formscoding)
  • Re: Lost Permission
    ... I set a password for the Admin User. ... "Joan Wild" wrote: ... Therefore you get no login prompt. ... >>> Microsoft Access MVP ...
    (microsoft.public.access.security)