Aus Formular Daten in Tabelle abspeichern
bkleine
Gesendet: 03.05.12 21:37
Betreff: RE: Aus Formular Daten in Tabelle abspeichern


Member

Beiträge: 31
25
Großer Meister!

Private Sub chosenStuff_DblClick(Cancel As Integer)
Dim strEinfuegen As String
Dim db As DAO.Database


strEinfuegen = "Insert Into [tab:trainedpersons] " & _
"([trainedpers:event], " & _
" [trainedpers:person]," & _
" [trainedpers:dbeditor]) " & _
"VALUES (" & _
"'" & Me.[train:runningNo] & "', " & _
"'" & Me.chosenStuff & "', " & _
"'" & Me.[train:dbeditor].Value & "');"

DBEngine(0)(0).Execute strEinfuegen, dbFailOnError

strEinfuegen = ""

End Sub

Das funktioniert jetzt.

Wieder was gelernt! und Danke fürs Mitlesen.

Bernhard
Top of the page Bottom of the page