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?

On Aug 27, 10:46 am, franks <fra...@discussions.microsoft.com> wrote:
> 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.

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" wrote:

> On Aug 27, 10:46 am, franks <fra...@discussions.microsoft.com> wrote:
> > 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.
> 
> 

On Aug 27, 11:42 am, franks <fra...@discussions.microsoft.com> wrote:
> 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" wrote:
> > On Aug 27, 10:46 am, franks <fra...@discussions.microsoft.com> wrote:
> > > 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.- Hide quoted text -
>
> - 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).

On Aug 27, 1:54 pm, franks <fra...@discussions.microsoft.com> wrote:
> 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.

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


"OldPro" wrote:

> On Aug 27, 1:54 pm, franks <fra...@discussions.microsoft.com> wrote:
> > 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.
> 
> 
> 

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" <franks@discussions.microsoft.com> wrote in message 
news:ECE53338-BF81-4E09-994D-2A9FA305890F@microsoft.com...
> 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
>
>
> "OldPro" wrote:
>
>> On Aug 27, 1:54 pm, franks <fra...@discussions.microsoft.com> wrote:
>> > 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.
>>
>>
>> 

Thanks!  fs

"UpRider" wrote:

> 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" <franks@discussions.microsoft.com> wrote in message 
> news:ECE53338-BF81-4E09-994D-2A9FA305890F@microsoft.com...
> > 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
> >
> >
> > "OldPro" wrote:
> >
> >> On Aug 27, 1:54 pm, franks <fra...@discussions.microsoft.com> wrote:
> >> > 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.
> >>
> >>
> >> 
> 
> 
>