Solved VBE Does not recognize Custom Function

[silentwolf]

Hi,
just wondering why the VBE does not let me jump to a custom function when trying to to to the definition?

Public Sub FillTmpAuszugColumns()
    Dim strSQL As String

strSQL = "UPDATE tmpAuszug SET tmpAuszug.Mandatsnummer = ReturnMandatsnummer([tmpAuszug].[Umsatztext]), " & _
                            "tmpAuszug.Auftraggeber = ReturnAuftraggeberref([tmpAuszug].[Umsatztext])," & _
                            "tmpAuszug.IBAN_Client = ReturnIBAN([tmpAuszug].[Umsatztext])," & _
                            "tmpAuszug.Zahlung = ReturnZahlungsreferenz([tmpAuszug].[Umsatztext])," & _
                            "tmpAuszug.Creditor = ReturnCreditorNumber([tmpAuszug].[Umsatztext]);"
                            
    CurrentDb.Execute strSQL, dbFailOnError
End Sub

ReturnMandatsnummer
ReturnAuftraggeberref
RetunIBAN
ReturnZahlungsreferenz
ReturnCreditorNumber

are all custom functions in a different module as the code

As I mentioned if i right click on those functions and go to definition it tells me not Identifier under the Cursor not reconized... well done those lines as I use a german version so it may be differnt in an english version.

Is there something I need to change in the code or is it normal that you can not jump to a custom function in this kind of situation?


Cheers

 

[Josef P.]

ReturnMandatsnummer is inside "" => for VBE this is a string.

 

[silentwolf]

Hi ok I understand!

Thanks