By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,746 Members | 1,926 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,746 IT Pros & Developers. It's quick & easy.

Problems with DLookUp() of Access 2003 on Vista

P: 2
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 canceled the previous operation" from MS Access.

Has anybody noticed this abnormality?

Your input will be apreciated.

Thank you

Aug 4 '07 #1
Share this Question
Share on Google+
2 Replies

Expert 2.5K+
P: 3,532
You need to have a look at this:

Welcome to TheScripts!

Linq ;0)>
Aug 4 '07 #2

P: 2
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!


Aug 5 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.