True False Question

  • Thread starter Thread starter Paul Hammond
  • Start date Start date
P

Paul Hammond

On some computers a procedure errors out on a SQL line
with the following reference "tblOrders.Archived = True;"
If the script is changed to "tblOrders.Archived = -1;" the
code works. The code will run properly till the next
time and then error out again. The code must then be
switched back to the original "= True" before it will run
again. I have a user who does this weekly just to get
the procedure to run. It works, but I hate having them
fiddle with my code.

Any ideas?

TIA,

Paul Hammond
 
The simple answer it have you tried to have it read

tblOrders.Archived = True Or tblOrders.Archived = -1

-Steve
 
I never got a chance to check this out. The end user had
Office reinstalled and the problem went away. Thanks for
the suggestion though.

PH
 
Back
Top