stuck on a simple dcount()

[markjkubicki]

stuck ....that simple
and any suggestions / comments / criticisms will be more than welcome in advance

Sub ShowUserRosterMultipleUsers()
Dim intUserCnt As Integer
Dim str_BE_FileName As String
Dim str_BE_lookup As String

     'get the name of the current backend file
    str_BE_FileName = Right(linklocation("tbeFixtureTypeDetails"), 255)
    
    'count number of users who have are logged into the file; 
    'a visual check of the table where a list  active users is stored shows only one record and the file name matches
    intUserCnt = DCount("User_name", "tblUserFile_Log", "FileLink_BE_proj = "" & str_BE_FileName & """)
    'yet the count is 0 
 
    '<<<--THAT IS WHERE I'M STUCK -->>>
    
    ' since there is only 1 record in the table, so lets take  look at it's value
    str_BE_lookup = DLookup("[FileLink_BE_proj]", "tblUserFile_Log")
    ' and check if it equals the file i am checking for
    MsgBox str_BE_FileName = str_BE_lookup
    ' it does  "true"

End Sub

[Welshgasman]

Strings need to be surrounded by single quotes ' unless it contains a single quote, then triple double quotes works I think?


Dates with # and in mm/dd/yyyy or yyyy-mm-dd format


Numbers do not need anything

[markjkubicki]

oy
i should be embarrassed

ntl
thnx much

[kd2017]

Double quotes are fine too. You were just missing one or two.

"FileLink_BE_proj = """ & str_BE_FileName & """"