Proper input for Data Type "CheckBox"

[franks]

What would be the proper input for "CheckBox" if you want it to stay a check
box in a table and default to blank. I have tried (with all failures) ="0",
="", and =" ". Any ideas?

 

[OldPro]

What would be the proper input for "CheckBox" if you want it to stay a check
box in a table and default to blank. I have tried (with all failures) ="0",
="", and =" ". Any ideas?

checkboxes in access are true and false. Set the format to false.

 

[franks]

Of course! (I say, as I slap my forehead.) I really do appreciate your help.
I guess this project has just gotten to me. I just keep running in sand or
maybe it is more like wiggling in quicksand. fs

 

[franks]

OldPro:
I tried both of the following, and got Type Mismatch.

attended = False
attended = "False"

and even tried:
Set attended = False
Set attended = "False"

In my humble opinion, I just don't think this project wants to be. Oh, yea,
by the way, I have Dim attended As CheckBox.

Well, if there is any thought on the matter, by all means, do let me know.

fs

 

[OldPro]

OldPro:
I tried both of the following, and got Type Mismatch.

attended = False
attended = "False"

and even tried:
Set attended = False
Set attended = "False"

In my humble opinion, I just don't think this project wants to be. Oh, yea,
by the way, I have Dim attended As CheckBox.

Well, if there is any thought on the matter, by all means, do let me know.

fs






- Show quoted text -

You've lost me. Why did you dim attended as checkbox? If there is a
checkbox, just go its properties and set default to false. Or, to set
it in code, chkAttended.value=false (it is always good practice to
preface the name of a checkbox with chk).

 

[franks]

There is not a checkbox from the form. I was just thinking in terms of
default, attended = false; thus, DIMmed the object to the CheckBox. How else
would I get that column to be a visible check box without the parameter
coming up and asking me for an input for the field? I have been working on
this form for about two weeks and it has to be finished for the user to use
by Monday. So, if I seem to be doing desperate things, you can see why.
It's just getting through my mind or something! Thanks for trying to help.

fs

 

[OldPro]

There is not a checkbox from the form. I was just thinking in terms of
default, attended = false; thus, DIMmed the object to the CheckBox. How else
would I get that column to be a visible check box without the parameter
coming up and asking me for an input for the field? I have been working on
this form for about two weeks and it has to be finished for the user to use
by Monday. So, if I seem to be doing desperate things, you can see why.
It's just getting through my mind or something! Thanks for trying to help.

Perhaps you are creating a datasheet or a continuous form, and you
want a checkbox to appear.
1) Open table in designview.
2) Select the Yes/No field.
3) Select 'Checkbox' in the 'Display Control' property, on the
'Lookup' tab of the 'Field Properties' pane.

 

[franks]

As concerning this part of the problem (See "Input from Form, Create fields
for Query bla bla bla. Can't even remember the whole of it!), Datasheet view
would be great after the table is created. My thinking was that I have to
have the "check box" created as the other variables are being added to the
list of names of the cohort; thus, the user could create attendance "sheets"
for several meetings that they had had through the week, and then post them
to a master table holding all of the attendances. I still cannot get the
syntax of getting "check box" to be part of the table via the OnClick Module.
It keeps trying to treat it as a parameter to be filled out.

I have put in the line "Dim ckbxAtttended As CheckBox." I then had
"ckbxAttended = False."

Another senerio:

No Dim statement. Put a hidden ckbxattended on Form that holds other
variable text boxes, Put a line then that said ckbxattended =
Me.ckbxAttended.Value, and the parameter box still comes up.

The string that creates the query with that senerio is:

strTblBldqry = "SELECT DISTINCT L8Names.stu_name, L8Names.stu_id,
typeofcontact, activitydate, " & _
"mintimecredit, ckbxattended INTO ActivityTrker " & _
"FROM L8Names;"


If this seems disjointed, it is probably because I have had to try to
compose it with several interruptions. So....If it makes sense, good. If
not, let me know and I will bolt the door, unplug the phone and try to
concentrate. Your extremely kind in your help and I am indebted.

fs

 

[UpRider]

Put a checkbox on your form. Delete its label. Set its data source to the
appropriate Yes/No field in your table. Set its default value property to
FALSE. Make its visible property = NO.
With this, any time your create a new record with the form, the table will
automatically contain FALSE for that column.

HTH, UpRider

 

[franks]

Thanks! fs

Put a checkbox on your form. Delete its label. Set its data source to the
appropriate Yes/No field in your table. Set its default value property to
FALSE. Make its visible property = NO.
With this, any time your create a new record with the form, the table will
automatically contain FALSE for that column.

HTH, UpRider