The table t_add_information starts with an autoNumber. How do I create a new autonumber with this statement, but leave all the other fields in the row empty?
DoCmd.RunSQL "INSERT INTO t_add_information" prompts a syntax error
strSQL="INSERT INTO t_add_information" prompts no error, but neither is the record created
DoCmd.RunSQL "INSERT INTO t_add_information (Product_name)VALUES(Insulin)" creates a new record, but is not what I am after - I do not want to enter values.
I have tried to create an append query using design view, however it seems to require that I specify fields. Which fields do I specify? All? Just one? If I do specify a field, I run into various. If no previous records are existent, the append query can't create a new record. If previous records exist, every time and append query is executed, the number of records created grows exponentially 2, 4, 8....
How can I specify DoCmd.RunCommand accmdrecordsgotonew to be executed for a particular table, e.g. DoCmd.t_add_information.RunCommand accmdrecordsgotonew?
The Command: DoCmd.GoToRecord , , acNewRec
Doesn't just take you to a new record, it actually records / adds a new record to the Table to which your control is bound.