By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,847 Members | 2,354 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,847 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

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


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

http://www.thescripts.com/forum/thread653390.html

Welcome to TheScripts!

Linq ;0)>
Aug 4 '07 #2

P: 2
nvs
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
Aug 5 '07 #3

Post your reply

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