DLookup problem

[natsirtm]

Can't for the life of me figure out why this won't work.

Simple DLookup

? DLookup("rid_Database", "tblDatabases", "[sDatabaseShortForm]='3CONP'")

rid_Database is valid field in table tblDatabases
3CONP is a valid entry within the field sDatabaseShortForm

all i get is ????????

 

[boblarson]

Does the field rid_Database really have the underscore?

And sDatabaseShortForm is a field in tblDatabases?

 

[natsirtm]

Does the field rid_Database really have the underscore?

Yes

And sDatabaseShortForm is a field in tblDatabases?

Yes

 

[!Blue]

Does 3CONP have a trailing space in the table..?

 

[natsirtm]

Does 3CONP have a trailing space in the table..?

Nope. I think it must have something to do with rid_Database being a GUID

 

[!Blue]

This produces a result...

Public Sub Blue()
Dim txt As String
Dim a() As Byte
 
    a = DLookup("rid_Database", "tblDatabases", "[sDatabaseShortForm]='3CONP'")
    txt = StringFromGUID(a)
    
End Sub

 

[natsirtm]

This produces a result...

Public Sub Blue()
Dim txt As String
Dim a() As Byte
 
    a = DLookup("rid_Database", "tblDatabases", "[sDatabaseShortForm]='3CONP'")
    txt = StringFromGUID(a)
 
End Sub

That looks good, thought I might need the GUID functions.
Out of curiousity, is the () for the byte variable required? What does it do?

 

[!Blue]

Yes the () is required...

Declares a byte array instead of a byte...

The guid is stored as a byte array...

 

[natsirtm]

Ended up having to flip it back into a GUID declared variable and again to String (non jet), but ya put me on the right track. Thanks