Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Database Design / April 2005

Tip: Looking for answers? Try searching our database.

dlookup

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
manveer - 19 Apr 2005 16:47 GMT
=Dlookup ("[Support Area]","[ Lima Caller Mapping Tables]","[System ID]="
&Forms!Form B_W Master Data!MachineID)

Could someone look at this formula and tell me where i'm going wrong....

Thanks in advance
Duane Hookom - 19 Apr 2005 18:06 GMT
There is a space to the left of "Lima..."  Your expression also assumes
System ID is numeric.

Signature

Duane Hookom
MS Access MVP

> =Dlookup ("[Support Area]","[ Lima Caller Mapping Tables]","[System ID]="
> &Forms!Form B_W Master Data!MachineID)
>
> Could someone look at this formula and tell me where i'm going wrong....
>
> Thanks in advance
John Vinson - 19 Apr 2005 19:33 GMT
>=Dlookup ("[Support Area]","[ Lima Caller Mapping Tables]","[System ID]="
>&Forms!Form B_W Master Data!MachineID)
>
>Could someone look at this formula and tell me where i'm going wrong....
>
>Thanks in advance

Using blanks (especially leading blanks!!!) in form and table names,
and not using brackets appropriately. Does your table Lima Caller
Mapping Tables actually have a blank in the table name before the L?
Surely not! The blank in the form name is being interpreted by DLookUp
as the end of the string - it has no idea what Forms!B_W might be, and
the strings "Master" and "Data!MachineID" are just hanging out there
loose. Any time you have blanks or special characters in a name, you
must use brackets to delimit the name.

Try

=Dlookup ("[Support Area]","[Lima Caller Mapping Tables]","[System
ID]=" & [Forms]![Form B_W Master Data]![MachineID])

and consider simplifying your object naming convention.

                 John W. Vinson[MVP]    
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.