asked on

How to add check box details to a database

In a VB from I have a problem with adding a check box field to a database.

What is the value to put in where the question symbols are displayed in the code below (i.e. if it was a text box it would be frmNewMareRecord.txtFoal.Text = ""):

frmMareRecordProcessingActions.datMare.Recordset.AddNew

frmNewMareRecord.chkFoal.??????? = ""
frmNewMareRecord.chkShoes.?????? = ""

Jacamar

vbChecked, or vbUnchecked

Jacamar

sorry.........it should be
.Value

Arthur_Wood

and the Value should be either VBChecked or vbUnChecked.

vbChecked has the numeric value 0, vbUnchecked has the numeric value 1.

in the Database, the field shhould be defined (in Access) as a Yes/No field (Yes is equivalent to Checked, No to UnChecked)

AW

ASKER CERTIFIED SOLUTION

Anthony Perkins

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

willwatters

ASKER

How can I store the following query as a variable (the data contorl is datEmployee):

"Select [EmployeeNumber] from EMPLOYEE where [Position] = Customer Assistant"

Anthony Perkins

willwatters,

That was very "generous" of you, but I suspect that Arthur or Jacamar was the one who merited the points for your question. One thing for sure, at least you are consistent. For the record: Last 10 Grades Given B A B B C C

Arthur, Jacamar
Let me know if you would like me to post some points for you.

Anthony