Recent use in Access of Built-In Functions gets an error "The expression you entered has invalid vertical bars (|)." with any multi-argument function. This happened in Access 2002. I just upgraded to Office 2007, and the same thing occurs. Trying commas to delimit the arguments doesn't work either. For example I entered in a query:
Right$ ('TruncateMe'| 5) , and it won't evaluate--just gives the above error. Anyone experienced that? Appears to be something with a dll corruption or replacement.
Running Windows XP
6  3211 
Recent use in Access of Built-In Functions gets an error "The expression you entered has invalid vertical bars (|)." with any multi-argument function. This happened in Access 2002. I just upgraded to Office 2007, and the same thing occurs. Trying commas to delimit the arguments doesn't work either. For example I entered in a query:
Right$ ('TruncateMe'| 5) , and it won't evaluate--just gives the above error. Anyone experienced that? Appears to be something with a dll corruption or replacement.
Running Windows XP
Does Right$("TruncateMe", 5) work?
Does Right$("TruncateMe", 5) work?
Not in the Query Designer. I found out with some hacking that all's fine in VBA. In query design, I'm fine if I stay in SQL view only. Any attempt at using a multi-argument function in the QBE grid fails using any delimiter. Strange, no? I'll just stay with SQL view. Actually I do most of my work in SQL anyway (SQL 2005), but Access is great for quick stuff and sometimes working with what someone else has done.
Thanks for the response! dj
Not in the Query Designer. I found out with some hacking that all's fine in VBA. In query design, I'm fine if I stay in SQL view only. Any attempt at using a multi-argument function in the QBE grid fails using any delimiter. Strange, no? I'll just stay with SQL view. Actually I do most of my work in SQL anyway (SQL 2005), but Access is great for quick stuff and sometimes working with what someone else has done.
Thanks for the response! dj
That is definately very strange!
I get this same error in same location with 2003. I have a query with 5 custom fields created using the pipe delimiter in the expression, and it works, still works today but when I try to modify it, it errors with "The Expression you entered has invalid Vertical Bars.(|). So it worked in 2000 & 2003 a couple of months ago, it still works now, if I try to modify the field in anyway it doesn't work.
I need to modify the expression which I can't now because it errors so if anyone has any ideas, please pass them on to us.
Following is my expression.
MyAdd2: IIF(IsNull([Employee Names Table]!AltAddress2)|[Companies Table]!BillAddress2|[Employee names Table]!AltAddress2)
Thanks.
OMG!!!!
I found out that changing my OS (XP Pro) "List Seperator" from pipe back to comma I can now edit my query expressions without getting any more "The expression you entered has invalid Vertical Bars(|)" errors.
Path XP Pro in Category view:
"Control Panel"
"Regional & Language Options"
"Regional Options"
"Customize"
"List Seperator" change it back to the default "," (comma)
What a bug!!
OMG, I changed my list separator back to , and it is working now. We could not figure out why it was working on one machine and not another. Thanks for posting that response if you are still out there :).
Sign in to post your reply or Sign up for a free account.
Similar topics
by: sector119 |
last post by:
I use python 2.4.1 and PIL 1.1.5 and when I execute my program I got
error:
../code.py
Traceback (most recent call last):
File "./code.py", line 7, in ?
class DrawPlus(ImageDraw.Draw):...
|
by: jimjim |
last post by:
Hello,
My question concerns as to how a pointer is passed by reference as a
function argument. The following is from code taken from the MICO
implementation of the CORBA specification.
in...
|
by: Jason Heyes |
last post by:
I am interested in the lifetime of a function argument in two cases. They
are:
1. void foo(Bar bar);
2. void foo(const Bar &bar);
In each case I call foo like so:
foo(Bar());
|
by: int2str |
last post by:
All,
As the simple sample program below demonstrates, function arguments are
destroyed after the return value of the function has been evaluated. As
opposed to local function variables, which...
|
by: Morgan Cheng |
last post by:
Hi All,
I was taught that argument valuse is not supposed to be changed in
function body. Say, below code is not good.
void foo1(int x)
{
x ++;
printf("x+1 = %d\n", x);
}
It should be...
|
by: Vv_vV |
last post by:
Hi all,
I try to call onchange a function and get "missing ) after argument
list" error
Probably systaxis issue
Thanks in advance for any help!
Code:
var html = "";
var myurl =...
|
by: Tuxedo |
last post by:
How can I modify any one of these global variable identified via a function
argument?
var x1 = "bla";
var x2 = "bla";
var x3 = "bla";
function modify(variable) {
???? ???? = "blabla":
|
by: lawrence k |
last post by:
I've got a function that starts off like this:
function alphabeticalListOfAlbumsByLetter($whichLetter="a") {
}
I pass in the letters (a, b, c, d, etc) and the numbers (0, 1, 2, 3,
4,...
|
by: nunoperalta |
last post by:
Hi, everyone! :)
I would like to know if an array, when given as function argument, is cloned (occupying more memory), or it is just referenced (but not modified as global variable).
I will...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |
