Re: Open a form with all date disabled

Tech-Archive recommends: Speed Up your PC by fixing your registry

Thanks for clarifying. I'm not sure how I or any of the other newsgroup
readers would have known that based on your earlier posts.

One approach might be:

If Me!cboYourStatusFieldName = "Closed" Then
Me.AllowEdits = False
Else
Me.AllowEdits = True
End if

Do you think the rude post is likely to encourage other folks to respond?
Folks who respond in this newsgroup are largely volunteers, and aren't paid
to be polite... we do so out of courtesy.

Good luck

Jeff Boyce
<Access MVP>


"StuJol" <StuJol@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B000671C-EA20-4D39-9D01-FF098E940578@xxxxxxxxxxxxxxxx
> Thanks for NO help. I am trying to learn VBA but it takes time. If im not
> sucessful in writing my own code then that's when i ask for someones
> assistance and when the code is right, i will then teach myself how it
works
> and what i was doing wrong.
>
> "Jeff Boyce" wrote:
>
> > If you are going to be working in Event Procedures, it would be worth
your
> > time to learn a little about VBA... Otherwise, if someone just writes
your
> > code, then tells you where it goes, then tells you how to debug it
if/when
> > it doesn't work exactly right the first time, then ..., you'll have
little
> > incentive to learn it and you certainly won't understand it!
> >
> > Or you could check with a local area users group for someone for hire...
> >
> > Regards
> >
> > Jeff Boyce
> > <Access MVP>
> >
> > "StuJol" <StuJol@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > news:FE733B68-87BF-4271-B589-89A138CA46F8@xxxxxxxxxxxxxxxx
> > > Could you please write the code for a simple if.. then statement as im
not
> > > familiar with the code as im just getting use to Access
> > >
> > > "Jeff Boyce" wrote:
> > >
> > > > If you add a procedure to the OnCurrent event, you can use that to
check
> > the
> > > > contents of the row/record as it is being loaded to the form.
> > > >
> > > > It sounds like you want to set the form's Data Edit property to "No"
if
> > your
> > > > status field value corresponds to "Closed". A simple If... Then
> > statement
> > > > could handle this.
> > > >
> > > > --
> > > > Regards
> > > >
> > > > Jeff Boyce
> > > > <Access MVP>
> > > >
> > > > "StuJol" <StuJol@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > > > news:67F9D31D-826B-49D6-B149-DDB2F3869286@xxxxxxxxxxxxxxxx
> > > > > I have a form with text boxes and combo boxes on. When the
"Status"
> > combo
> > > > box
> > > > > value is "Closed" i want the form to open with every txt box and
combo
> > box
> > > > > (Including the "Status" Combo box) disabled so that no fields can
be
> > > > changed.
> > > > > Read Only.
> > > > >
> > > > > Does anyone know any code that will do this???
> > > >
> > > >
> >
> >

.

Relevant Pages

  • Re: Working days
    ... Doing WorkDay Math in VBA ... Dirk Goldgar, MS Access MVP ... (please reply to the newsgroup) ...
    (microsoft.public.access.forms)
  • Re: InvalidCallException when getting projection transformation
    ... Vanderghast, Access MVP ... > I've seen a few posts on the net (and in this newsgroup) about people ... > exception of type: ...
    (microsoft.public.win32.programmer.directx.managed)
  • Re: Need to grab Path and Filename to run Import txt file process.
    ... Note, by the way, that people responding to one of your posts generally have no idea what you may have posted in other threads. ... Dirk Goldgar, MS Access MVP ... (please reply to the newsgroup) ...
    (microsoft.public.access.modulesdaovba)
  • Re: Using "IIf" or "In" in VBA
    ... "Jim Pockmire" wrote in message ... > I believe there is a way to use these functions in VBA, ... Dirk Goldgar, MS Access MVP ... (please reply to the newsgroup) ...
    (microsoft.public.access.formscoding)
  • Re: Receive a 3134 error
    ... they didn't know any vba. ... remove the lookup column? ... Dirk Goldgar, MS Access MVP ... (please reply to the newsgroup) ...
    (microsoft.public.access.modulesdaovba)