Sniper-BoOyA-
Registered User.
- Local time
- Yesterday, 21:52
- Joined
- Jun 15, 2010
- Messages
- 204
Good morning,
Since last Monday ive been getting this error when i try to open a report. And i cant figure out how to solve it without losing other functions of the database.
I know changing the reference to the from Microsoft DAO 3.6 to Microsoft DAO 3.5.1 solves the problem, but then i wont be able to use the function i made to track changes any report them in a table.
The report has a subreport, which happends to cause the problem.
The query to create that form works just fine, but when i save and open the report i am getting an errror.
The error im getting is :
"function is not available in expressions. in query expression Left(Boorkern,10)"
Even if i delete anything that has to do with boorkernnr from the query, i still get the message.
Any ideas??
Since last Monday ive been getting this error when i try to open a report. And i cant figure out how to solve it without losing other functions of the database.
I know changing the reference to the from Microsoft DAO 3.6 to Microsoft DAO 3.5.1 solves the problem, but then i wont be able to use the function i made to track changes any report them in a table.
The report has a subreport, which happends to cause the problem.
The query to create that form works just fine, but when i save and open the report i am getting an errror.
The error im getting is :
"function is not available in expressions. in query expression Left(Boorkern,10)"
Even if i delete anything that has to do with boorkernnr from the query, i still get the message.
Any ideas??