O
Oldiesmann
I was having a few problems with a validation rule while working in Access
2003 earlier. Most of the time I was just given a message saying that the
expression was typed incorrectly. However, one particular expression (In
("Value1", "Value2", "Value3")) yielded a different message - "Reserved Error
(-3100). There is no message for this error.". Why isn't there a message for
this error, and why wasn't I given the typical invalid expression message? I
did figure out the correct expression (Value1 Or Value2 Or Value3), but it
would have been helpful if it had given more detail. Also, with the invalid
expression message, it said that I might need to put something in quotes.
Problem is, they were already in quotes. I would appreciate Microsoft giving
more useful error messages in the future.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/com...-8ac7-d79e8616577d&dg=microsoft.public.access
2003 earlier. Most of the time I was just given a message saying that the
expression was typed incorrectly. However, one particular expression (In
("Value1", "Value2", "Value3")) yielded a different message - "Reserved Error
(-3100). There is no message for this error.". Why isn't there a message for
this error, and why wasn't I given the typical invalid expression message? I
did figure out the correct expression (Value1 Or Value2 Or Value3), but it
would have been helpful if it had given more detail. Also, with the invalid
expression message, it said that I might need to put something in quotes.
Problem is, they were already in quotes. I would appreciate Microsoft giving
more useful error messages in the future.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/com...-8ac7-d79e8616577d&dg=microsoft.public.access