Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

syntax help on UPDATE with boolean

Status
Not open for further replies.
tania20

tania20

Programmer
Oct 30, 2006
148
AU
Hi, Can someone please help with my syntax on UPDATE, i know how to use for text and number fileds but not for boolean.RecordSelector is an option button (yes/no)

db.Execute ("UPDATE general_info SET [RecordSelector] = FALSE WHERE strWhere")

Cheers

Tania
 
Sort by date Sort by votes
its ok just worked it out- needed ' ' around strWhere....
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

caykamanj1966
  • Locked
  • Question
Help With Search Form Results 2
Replies
15
Views
660
caykamanj1966
caykamanj1966
BJZeak
  • Locked
  • Question
Struggling with finding an answer to a simple question
Replies
5
Views
703
BJZeak
BJZeak
TrekBiker
  • Locked
  • Question
Running query with parameter from Inputbox 2
Replies
8
Views
785
TrekBiker
TrekBiker
breezett93
  • Locked
  • Question
Function that find all controls on a form and puts their tab index in numerical order
Replies
19
Views
1K
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Forcing Form Updates
Replies
2
Views
582
TrekBiker
TrekBiker

Part and Inventory Search

Sponsor

Back
Top