Hi all, may be you can help me with an curious error in 2007 Access, until now nobody can say me the cause.
Multiselect filter in numeric field "The expression 'l' you entered is invalid"
Filter by selection (this is a function of Microsoft access 2007)
When attempting to use the "Filter by Selection" criteria in the search screens in Access 2007 ( simples Tables or Divided formularies), if you highlight more than one number (two or more values), depending of the computer, some times you will get a "The expression 'l' you entered is invalid" error. The ability to search by selection on numeric fields in Access 2007, do not work properly in all computers.
The error do not occur in text fields (with text or numbers)
When working with a numeric field in access 2007, it does not seem possible to use the “filter by selection” in all Pc's with the same results.
Computers with windows XP professional SP1 or SP2 or SP3, with Office XP and 2007 Access Runtime, or without any Microsoft Office software and run only 2007 access Runtime, or others with Microsoft Office enterprise 2007. In some computers the filter by selection in numeric field may be work properly or not. The results depend of the computer, in one Pc the filter work all time properly and in other computer do not work. Why ?
In all cases, if you only select one number, the filter will work properly but when you select two or more numbers (registers) the error appear and say "The expression 'l' you entered is invalid".
Before that I send this consult, I tryed several posibilities on 7 differents computers, new Pc, Old Pc, HD was formatted and was installed all software from zero but was impossible to discover the error origin. I investigated the references on VBA, Dll's and Framework versions.
Any information to solve it, will be appreciated.
Multiselect filter in numeric field "The expression 'l' you entered is invalid"
Filter by selection (this is a function of Microsoft access 2007)
When attempting to use the "Filter by Selection" criteria in the search screens in Access 2007 ( simples Tables or Divided formularies), if you highlight more than one number (two or more values), depending of the computer, some times you will get a "The expression 'l' you entered is invalid" error. The ability to search by selection on numeric fields in Access 2007, do not work properly in all computers.
The error do not occur in text fields (with text or numbers)
When working with a numeric field in access 2007, it does not seem possible to use the “filter by selection” in all Pc's with the same results.
Computers with windows XP professional SP1 or SP2 or SP3, with Office XP and 2007 Access Runtime, or without any Microsoft Office software and run only 2007 access Runtime, or others with Microsoft Office enterprise 2007. In some computers the filter by selection in numeric field may be work properly or not. The results depend of the computer, in one Pc the filter work all time properly and in other computer do not work. Why ?
In all cases, if you only select one number, the filter will work properly but when you select two or more numbers (registers) the error appear and say "The expression 'l' you entered is invalid".
Before that I send this consult, I tryed several posibilities on 7 differents computers, new Pc, Old Pc, HD was formatted and was installed all software from zero but was impossible to discover the error origin. I investigated the references on VBA, Dll's and Framework versions.
Any information to solve it, will be appreciated.
