True False Question

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
 
S

Steven M. Britton

The simple answer it have you tried to have it read

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

-Steve
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA for Dependents shortcut menu 0
Inserting a beginning record in a subform 2
docmd.setwarning false and true 6
VBA code returns no records hwenKey ID is added 14
How do I call a procedure in Main form from sub-form? 2
Synchronization problems while moving folders to new email 1
Unexplained failure of wdFindStop at end of search 0
Changing Bound Text Box Border Width Property Screws Up Tab Order 0

Top