Using Access 2002 - VBA
How could I add a new record in the table in my database? I want to input information from a form, but it doesnt have enough rows to handle the information.
It keeps saying file is at EOF or BOF.
Printable View
Using Access 2002 - VBA
How could I add a new record in the table in my database? I want to input information from a form, but it doesnt have enough rows to handle the information.
It keeps saying file is at EOF or BOF.
*edit*
just look at above post, all over problems have been fixed
Why even issue a MoveFirst? When a recordset is opened, it is always at the first record unless there are no records (obviously). But if you insist, just make sure there are records in the recordset.
VB Code:
RsStorage.Open "Splits", cn, adOpenKeyset, adLockPessimistic, adCmdTable If Not (rsStorage.BOF And rsStorage.EOF) Then 'ie the table is empty RsStorage.MoveFirst End If
*edit* just look at the first post -- everything else has been solved
EOF or BOF is not an issue that should matter if you are adding a record.
Post your code so we can see the problem.