My Assistant
Site Message
(Message will auto close in 2 seconds)
  |
 Help with Dlookup in VBA
|
|
 Mar 17 2006, 11:39 AM
Post
#1
|
|
|
UtterAccess Member Posts: 32  |
I had this working just fine in Access query designer and I am trying to us it in VBA and keep getting a complile error. I think it has to do with the double quotes but I am not sure what to do. I simply changed the view in the query designer to sql view to get this code any suggestions?
CODE sqlSTR="SELECT Spring2006.ITM_NUM, CDSITM_M.ITM_DSC1, DLookUp("[CMP_NME]","CDSADR_M","[CTM_NBR]='000000604974' and [ADR_CDE]='STANDARD' and [ADR_FLG]='0'" ) As Company " & _
", IIf(IsNull([UNITS_ORD]),0,[UNITS_ORD]) AS Ordered " & _ "FROM (Spring2006 LEFT JOIN qryAMWHOLE ON Spring2006.ITM_NUM = qryAMWHOLE.ITM_NUM) INNER JOIN CDSITM_M ON Spring2006.ITM_NUM = CDSITM_M.ITM_NUM " & _ "ORDER BY Spring2006.ITM_NUM;" |
 |
 
|
|
Mar 17 2006, 12:14 PM
Post
#2
|
|
|
UtterAccess VIP Posts: 2,128 From: San Jose, California |
Untested, but I suspect the dlookup clause should be:
DLookUp(""[CMP_NME]"", ""CDSADR_M"",""[CTM_NBR]='000000604974' and [ADR_CDE]='STANDARD' and [ADR_FLG]='0'"" ) ??? Jinky |
|
|
|
|
Mar 17 2006, 01:33 PM
Post
#3
|
|
|
UtterAccess Member Posts: 32 |
Thank you that did it... Thanks for your help!
|
|
|
|
|
Mar 17 2006, 02:16 PM
Post
#4
|
|
|
UtterAccess VIP Posts: 2,128 From: San Jose, California |
You are very welcome. Glad to have been of assistance.
And thanks for the feedback. It's always nice to know how things turned out. Jinky. |
|
|
|
 |
|
Jump To Forum:
|
Go to Top · Lo-Fi Version | Time is now: 20th June 2013 - 06:54 AM |