My problem is the following:
I am adding a new record to a database, where the field 'ID', which is also the Primary Key, will be automatically increased by one.
Right after adding the new Entry to the DB, I need to know the newly created ID number.
How can I retrieve the newly created ID number.
I tried to make a SELECT statement, selecting all the same fields I've just entered, although, as there may be some empty fields (nulls) I do always get the following Error: Data type mismatch in criteria expression
Does anybody have a solution or had a simular problem
Thanks.
Patrick
I am adding a new record to a database, where the field 'ID', which is also the Primary Key, will be automatically increased by one.
Right after adding the new Entry to the DB, I need to know the newly created ID number.
How can I retrieve the newly created ID number.
I tried to make a SELECT statement, selecting all the same fields I've just entered, although, as there may be some empty fields (nulls) I do always get the following Error: Data type mismatch in criteria expression
Does anybody have a solution or had a simular problem
Thanks.
Patrick