sort datasheet attempt crashes Access 2003 (error 3450 in Access 2

G

george1234

'add one textbox to form with Control Source = ID)
'here is simple form code:
'error 3450 - I can't find much info on this...
Private Sub Form_Load()
'2008-01-11
Dim rsx As ADODB.Recordset
Set rsx = New ADODB.Recordset
rsx.CursorLocation = adUseClient
rsx.CursorType = adOpenDynamic
rsx.LockType = adLockOptimistic

rsx.Fields.Append "ID", adDouble

rsx.Open

rsx.AddNew 0, 1
rsx.Update

rsx.AddNew 0, 2
rsx.Update

rsx.AddNew 0, 3
rsx.Update

Set Form_Form1.Recordset = rsx

End Sub
 

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

setting form's recordset property 3
Wildcard Filtering on ADO Recordset 1
Do i search or filter a query table 1
Can't get the code to sort the data properly. 1
Problem adding records via Datasheet 2
So disconnected means recordset can only be connected in same rout 1
Help with run-time error '2424' and '3265' 4
Stop some records sending table! 0

Top