UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> dlookup    
 
   
Diggerdigs
post Aug 13 2005, 10:34 PM
Post #1

UtterAccess Addict
Posts: 145
From: Nottingham, UK
Just moved over to 2003 from 2000 and my dlookup no longer works as it did in 2000.

this isthe old code

=DLookUp("[ProgrammeTitle]","[A-z]","forms![employees]!Form![Event Details].form![a-z code]=[a-z code]")

all i et now is #error

Can anyone help me

thanks
Go to the top of the page
 
+
Larry Larsen
post Aug 13 2005, 10:38 PM
Post #2

UA Editor + Utterly Certified
Posts: 22,722
From: Melton Mowbray,Leicestershire (U.K)
Hi
It may be worth checking your references: References that you must set when you use Microsoft Office Access 2003.
Make sure your up todate and have no "Missing" references..
(IMG:http://www.utteraccess.com/forum/style_emoticons/default/thumbup.gif)
Go to the top of the page
 
+
« Next Oldest · Access Forms · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 24th May 2013 - 01:18 AM