Thank you for all the answers.
But no I can't get them work.
to spikepl: error code 3464 is "tyyppivirhe ehtomäärityksessä"
SQL code is highlighted yellow and arrow pointing last row.
I think this is here and I try to do it different way.
Don't know how but if someone got sugestions I'm...
Thanks.
I've been thinking about those quotations...
And I hoped that problem is somewhere there.
But still I get Run-time error 3464...
Does it got to do something with null values, error handlig or ...?
Something small but where to start look at...
Here is what i got now:
Private Sub...
Hi!
I started from forum thread t=225857 and tried to do some adjustments... Not working so good.
First part works:
Private Sub CmdLisääTyhjä_Click()
Dim iNewID As Long
DBEngine.BeginTrans
Dim rs As DAO.Recordset
Set rs = CurrentDb.OpenRecordset("tblTilaukset", dbOpenDynaset)...