Public Function Ma_Name_auslesen() Dim Rst As DAO.Recordset Dim SQL As String Dim DeineVariable As String SQL = "SELECT Ma_Name FROM Ma_Tabelle WHERE Ma_Nr=3" Set Rst = CurrentDb.OpenRecordset(SQL, dbOpenDynaset) DeineVariable = Rst!Ma_Name MsgBox DeineVariable Rst.Close End Function
DeineVariable = nz(DLookup("MA_name", "MA-Tabelle", "Ma_Nr = " & Nummer))
58.4k Fragen
249k Antworten
7k Nutzer