Hi !
I'm bit frustrated, I just can't select all in a query. It is allways hard to explain so I have made a small access program to show what I mean.
If You start frmProject_Filter and chose Adam Adamsson in the dropdown meny and press "Start Filtering" It start up start up and show a filtered qryProject for two seconds, just as it should. And it works like charm with all manager in the dropdown meny so far so god !
The problem is when it comes to show all... It shows nothing... I have tried "like *" , "*" and much more. If You use the asterix directly in the query it works but not as a variable...
It's problebly a very litle fault but it still a fault... Is there anyone who can assist and save my weekend...
// Shas
I'm bit frustrated, I just can't select all in a query. It is allways hard to explain so I have made a small access program to show what I mean.
If You start frmProject_Filter and chose Adam Adamsson in the dropdown meny and press "Start Filtering" It start up start up and show a filtered qryProject for two seconds, just as it should. And it works like charm with all manager in the dropdown meny so far so god !
The problem is when it comes to show all... It shows nothing... I have tried "like *" , "*" and much more. If You use the asterix directly in the query it works but not as a variable...
It's problebly a very litle fault but it still a fault... Is there anyone who can assist and save my weekend...
// Shas