Thank you, missingling,
My humble apologies.
I started blame Vista a bit prematurely.
It was my mistake - I was trying to DLookUp the re-named field.
No wonder that Access put #Error message in the text box.
The good thing is - Your old Access 2003 programs developed on
Windows XP work perfectly on Vista!
Cheers
Nick
User Profile
Collapse
-
Problems with DLookUp() of Access 2003 on Vista
Hi All,
My Access 2003 Application was created on MS XP and worked perfectly.
After installing it on Vista I have noticed that DLookUp function does not work
on Forms. It generates Error inside a text box.
Interesting that this function works perfectly in Reports.
If I run DLookUp inside a procedure (OnCurrent, for example) and try to see the result in MsgBox,
it generates Error Message "You...
No activity results to display
Show More
Leave a comment: