Saving data in Access table with VB ?

[Bauhaus]

I have a form with a button and if you click the button, a list of invoices
are generated and saved in the table 'Invoice'.
Problem is, the data isnt saved

Here's my code:

Private Sub Knop0_Click()

Dim Invoicenr As Long
Dim Invoicedate As Date

stdocname = "Invoice"
DoCmd.OpenTable stdocname, acViewNormal, acAd

Invoicenr = 111111
Invoicedate = Now

DoCmd.Save acTable, stdocname

End Sub

What am I doing wrong ?

 

[George Nicholson]

DoCmd.Save acTable, stdocname
Is used to save changes to the table object itself, not the data within the
table. Try:

DoCmd.RunCommand acCmdSaveRecord

HTH,

 

[Scott McDaniel]

I have a form with a button and if you click the button, a list of invoices
are generated and saved in the table 'Invoice'.
Problem is, the data isnt saved

Here's my code:

Private Sub Knop0_Click()

Dim Invoicenr As Long
Dim Invoicedate As Date

stdocname = "Invoice"
DoCmd.OpenTable stdocname, acViewNormal, acAd

Invoicenr = 111111
Invoicedate = Now

If Me.Dirty Then Me.Dirty = False

DoCmd.Save acTable, stdocname

End Sub

What am I doing wrong ?

You can use The Docmd method, but the preferred method is to set the Dirty property to False, which forces Access to
save pending changes.

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com

 

[Bauhaus]

Try:

DoCmd.RunCommand acCmdSaveRecord

Doesnt work :s
However, I found a solution with a sql insert.

Thnx anyway