Re: Checkbox
- From: "tina" <nospam@xxxxxxxxxxx>
- Date: Wed, 06 Apr 2005 05:53:48 GMT
try
Me!PrinterSerial.Visible = Nz(Me!printchk = True, False)
hth
"Chip1035" <Chip1035@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:41FA1C46-A6AB-4064-BB9A-6AA240DF1E2D@xxxxxxxxxxxxxxxx
> Found it... Now, when I access the form, I get an error:
>
> Run-Time error '94'"
> Invalid use of Null
>
> Click on Debug and it brings me to the Form_Current line with the code
> highlighted. Here is my code
>
> PrinterSerial.Visible = Me!printchk = -1
> ^---Is the name of textbox ^---Is the name of the checkbox
> I want visable if checkbox is
> checked, not if check box is
> not checked
>
> If I click on End, tehn go fourth with checking the checkbox, no error
comes
> up but still does what I explained earlier.
> "tina" wrote:
>
> > in design view, when you open the Properties box, make sure the
Properties
> > box's title bar says Form - not Section, or anything else. if it doesn't
say
> > Form, then double click in the gray square in the upper left corner of
the
> > design view window, at the junction of the vertical and horizontal
rulers;
> > that should change the Properties box title bar to Form. then click the
> > Events tab and proceed as stated in my previous post.
> >
> > hth
> >
> >
> > "Chip1035" <Chip1035@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > news:AFE74F0D-EDA2-4528-8CB1-3030C541CF50@xxxxxxxxxxxxxxxx
> > > I cannot locate OnCurrent event procedure. I am using Access 2000, am
I
> > > missing something, I feel like this is suppose to be right in front of
me.
> > > I right click on the an emtpy area in Design View, select Properties,
> > cannot
> > > see a OnCurrent.
> > >
> > > "tina" wrote:
> > >
> > > > in the table underlying the form, you should have a field to store
the
> > > > Yes/No value re printer availability. make sure that field is
included
> > in
> > > > the form's RecordSource. bind the checkbox control to the Yes/No
field
> > (set
> > > > the checkbox control's ControlSource to the name of the field). then
> > include
> > > > your code in the form's OnCurrent event procedure, and in the
checkbox
> > > > control's AfterUpdate event procedure. to add the code:
> > > >
> > > > 1. open the form in design view.
> > > > 2. open the Properties box (if it's not already open), click on the
> > Events
> > > > tab, and then double click in the white space at the right of the On
> > Current
> > > > event (first event listed). Access will create the event procedure
and
> > open
> > > > the VBA Editor window, with the cursor inside the procedure.
> > > > 3. enter your line of code, as
> > > >
> > > > Private Sub Form_Current()
> > > >
> > > > PrinterControl.Visible = (Me!CheckBoxName = -1)
> > > >
> > > > End Sub
> > > >
> > > > 4. go back to form design view.
> > > > 5. click on the checkbox control to select it.
> > > > 6. in the Properties box, again double click on the AfterUpdate
event
> > line.
> > > > 7. enter your code inside the procedure, same as before.
> > > >
> > > > hth
> > > >
> > > >
> > > > "Chip1035" <Chip1035@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > > > news:0594D03D-2A50-43DD-971F-85BF54CB86C5@xxxxxxxxxxxxxxxx
> > > > > This is what I got
> > > > > Inventory Form which shows employee name, extension, computer
serial
> > > > number
> > > > > and a checkbox for printer. When the checkbox is checked, a
subform
> > shows
> > > > > the printer's serial number.
> > > > >
> > > > > I have the following code as an AfterUpdate event
> > > > > PrinterControl].Visible = Me![CheckBoxName] = -1
> > > > >
> > > > > Now, when I view a record and the checkbox is empty, the next
record
> > has
> > > > the
> > > > > checkbox empty, but if I want to place a checkbox to show that
> > employee
> > > > has a
> > > > > printer, the previous record has the checkbox checked with the
printer
> > > > > subform empty. If I uncheck the record and go back to the one
that
> > should
> > > > be
> > > > > checked, I find the checkbox unchecked.
> > > > >
> > > > > It was suggested I enter the code above in the Form's current
event.
> > How
> > > > > can I access the Form's current event, in order to place the code
> > there?
> > > > If
> > > > > needed... If there is another code all together, bring it on so I
> > could
> > > > try
> > > > > it. NOTE: I am not a pro at Access, rather just a beginner...
Thank
> > you
> > > > > for any and all help, in advance...
> > > > > --
> > > > > -Chip
> > > > > =)
> > > >
> > > >
> > > >
> >
> >
> >
.
- Follow-Ups:
- Re: Checkbox
- From: Chip1035
- Re: Checkbox
- References:
- Checkbox
- From: Chip1035
- Re: Checkbox
- From: tina
- Re: Checkbox
- From: Chip1035
- Re: Checkbox
- From: tina
- Re: Checkbox
- From: Chip1035
- Checkbox
- Prev by Date: Re: SampShot Viewer
- Next by Date: Re: Field Focus
- Previous by thread: Re: Checkbox
- Next by thread: Re: Checkbox
- Index(es):
Relevant Pages
|
