Data entry with Leban RTF

S

SF

Hi,

I have a data entry form having 5 fields and 1 save button link to a
temporary table (1 PK and 4 memo fileds). These memo fields are bound to
Leban RTF 1.8. The form is set to record multiple records. When I click the
save button, the last record alway been ignored by the append query (If the
table has 5 record, only 4 is added).

Could someone advice?



btnSave

Dim dbs As DAO.Database
Dim rst As DAO.Recordset
Dim qdf As DAO.QueryDef
Dim Vstd As Long
Dim Stg As String

If IsNull(Me.MsID) Then
MsgBox "Error Found! Missing ID:", vbOKOnly + vbInformation
DoCmd.Close
Exit Sub
End If

DoCmd.Hourglass True


Set dbs = CurrentDb
Vstd = Me.MsID


Set qdf = dbs.QueryDefs("AddDetailMileStone")
qdf.Parameters("S") = Vstd
qdf.Execute dbFailOnError
Set qdf = Nothing
''Call ClearTempMiletone

DoCmd.Hourglass False
DoCmd.Close
End Sub

SF
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help Error 3146 ODBC call fail 0
Querydef Timeout 9
Excel automation 2
Excel workbook and printing 3
Exort set of queries to excel 2
Export with Format 8
export vba not working 0
help with Code 1

Top