Data access pages filtering error

Data access pages filtering error

Post by R3I4R3lyb » Fri, 15 Jul 2005 05:51:12


Everytime I try to use the filtering option on a data access page I get the
following error "Arguments are of the wrong type, are out of acceptable
range, or are in conflict with one another."

Anyone know why this is happening?

Thanks
--
Gyro
 
 
 

Data access pages filtering error

Post by R3I4R3lyb » Fri, 15 Jul 2005 06:21:02

Found the answer. The field name had a space in it. Once the spaces are
removed from the field names it worked fine.
Just information for anyone else with the same problem.

--
Gyro

 
 
 

Data access pages filtering error

Post by Sylvain La » Thu, 11 Aug 2005 09:51:02

In many occasions, you can enclose field and table names that have
particular symbols like space with [], as in [File name with spaces]. On
SQL-Server, you can also choose the double quote " as the delimiter
caracter.

However, using names without these symbols is the simplest way of doing
things.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://www.yqcomputer.com/