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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

docmd.runsql syntax

Status
Not open for further replies.
waterj4

waterj4

MIS
Joined
Sep 14, 2005
Messages
3
Location
US
I'm going over some old code that someone else wrote
Code: 
DoCmd.RunSQL "UPDATE tblAssetRecon_Exceptions SET LegalEntity = 0 WHERE LegalEntity Is Null;", -1

What does the -1 do?
 
Sort by date Sort by votes
Its a boolean True value for the UseTransaction named parameter.
BTW, no F1 key on your keyboard ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Moss100
  • Locked
  • Question Question
Help to get syntax correct
Replies
5
Views
521
Andrzejek
Andrzejek
BallunarCrew
  • Locked
  • Question Question
Syntax error check setting gone?
Replies
2
Views
358
BallunarCrew
BallunarCrew
rccline
  • Locked
  • Question Question
DoCmd.RunSQL will not run
Replies
15
Views
1K
MajP
MajP
WalkieTalkie
  • Locked
  • Question Question
FindFirst syntax
Replies
5
Views
2K
MajP
MajP
Lavenderchan
  • Locked
  • Question Question
Syntax Error (Mission operator) in Query Expression
Replies
7
Views
500
MajP
MajP

Part and Inventory Search

Sponsor

Back
Top