netsys
Posts: 39
|
Posted: 07/10/2012, 11:33 AM |
|
I'm having trouble with what should be a simple dlookup but getting no data.
If I do this:
Dim testclassID
testclassID = 2012071013072936946
Class_Times.Label1.Value = CCDLookUp("Class_SchedID","Classes_Scheduled","uniqueclassid=" & "'" & testclassID "',"DBsafehunters)
I get no data for the value.
If I do this: Class_Times.Label1.Value = CCDLookUp("Class_SchedID","Classes_Scheduled","uniqueclassid='2012071013072936946'",DBsafehunters)
I get the correct data. I'm assuming this has something to do with the fact that this is a text field, not a number field, but I can't seem to get that CCDLookup phrased correctly. Can someone help?
|
|
|
netsys
Posts: 39
|
Posted: 07/10/2012, 11:59 AM |
|
Nevermind - had some quotations out of place. Here's what worked:
Class_Times.Label1.Value = CCDLookUp("Class_SchedID","Classes_Scheduled","uniqueclassid=" & "'" & uniqueclassID & "'" & "",DBsafehunters)
|
|
|
|