Rent A Coder - Checkboxes programmatically

Show Bid Request

Checkboxes programmatically
Bid Request Id: 51499

Bookmark in my 'To Do' list

Posted by:	Burt (25 ratings) (Software buyer rating 10)
Non-action Ratio:	Very Good - 0.00%
Posted:	Mar 6, 2003 11:49:05 AM EDT
Bidding Closes:	Mar 10, 2003 12:20:16 PM EDT
Viewed (by coders):	26 times

Phase:	100% of work completed and accepted. Coder has been paid.
Max Accepted Bid:	Bidding is closed
Project Type:	Question or Beginner / Newbie Assistance
Bidding Type:	Open Auction
Categories:	Database, Language Specific, Visual Basic, Access

Enter chat room for this bid request
(0 active users at May 18, 2003 7:23:45 PM EDT)

Description:
Linking the common VB checkbox control to Access tables using the ADO data control is not difficult. But I have not been able to find a way to connect the control "programmatically" to a Boolean field in an Access &'97 table. For example…

This code won&'t load the checkbox control named "Check1(0)" with the value of "NameOfBooleanAccess97Field":

Check1(0) = !NameOfBooleanAccess97Field

And this code won&'t load the Access &'97 field named "NameOfBooleanAccess97Field" with the value of the checkbox I've named "Check1(0)":

!NameOfBooleanAccess97Field = Check1(0)

This MUST be easy to do. What am I missing? I'm willing to pay for the answer.

Deliverables:
Code that will enable me to use ADO to connect a common VB6 checkbox control programmatically to a boolean field in an Access '97 table.

Platform:
All flavors of Windows '95 thru XP.

Remember that contacting the other party outside of the site (by email, phone, etc.) on all business projects < $500 (before the buyer's money is escrowed) is a violation of both the software buyer and seller agreements. We monitor all site activity for such violations and can instantly expel transgressers on the spot, so we thank you in advance for your cooperation. If you notice a violation please help out the site and report it. Thanks for your help.

Bidding/Comments:

All monetary amounts on the site are in United States dollars.
Rent a Coder is a closed auction, so coders can only see their own bids and comments. Buyers can view every posting made on their bid requests.

See all rejected bids (and all comments)

Name Bid Amount
Date Coder Rating

This bid was accepted by the buyer!

GribFritz
(61 ratings)
in College Point, New York
United States
Bid id: 554,067

$10 (USD) Mar 6, 2003
5:01:17 PM EDT 9.95
(Excellent)

Burt,

This is a good faith bid. If you like my answer, I hope you'll accept my bid.

You can't just check the values because Access uses yes/no and VB uses 1/0. A simple if-statement can solve your problem.

If rsTable!FieldName = 'yes' Then
Check1.Value = 0
Else
Check1.Value = 1
End If

:-)

Thomas Tustin

See 1 private reply(ies)
to/from GribFritz.