X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
   Reply to this topicStart new topic
> dbFailOnError = 128    
 
   
dwAccessUser32
post Jan 24 2007, 03:49 PM
Post#1


UtterAccess Veteran
Posts: 368
Joined: 29-November 06



I am trying to debug some code that I can't get to work. When I step through it and hover over the following line:
execute the sql statement that was just created
CurrentDb.Execute strSQL, dbFailOnError
Specifically, over the dbFailOnError I see it equals 128. What does this mean? Does anyone know?
Any help would be greatly appreciated!
Go to the top of the page
 
adamsherring
post Jan 24 2007, 03:56 PM
Post#2


VIP Emeritus
Posts: 1,750
Joined: 16-June 05
From: The Great White North


Hi,
bFailOnError is a VBA constant, or a value that is always the same (128). Generally, these constants are bit values, so they can be OR'd together to produce several effects. Its just an effeciant way of passign multiple arguements in a single digit to an access function. The 'dbFailOnError' portion is done so it means something to the user calling the function. Its a lot easier to remember 'dbFailOnError' makes the function fail on error than 128. Or, conversly, it is a lot easier to say vbYesNo OR vbExclamation than 4 or 48, or 52 (that was a lucky one - OR doesnt always Add)
Hope this helps,
Adam
Go to the top of the page
 
dwAccessUser32
post Jan 24 2007, 04:07 PM
Post#3


UtterAccess Veteran
Posts: 368
Joined: 29-November 06



Thanks for the info!
Go to the top of the page
 
adamsherring
post Jan 25 2007, 02:13 PM
Post#4


VIP Emeritus
Posts: 1,750
Joined: 16-June 05
From: The Great White North


Glad I could help,
dam
Go to the top of the page
 


RSSSearch   Top   Lo-Fi    25th January 2015 - 11:22 PM