In access create a row using only default values

Question

I want a new entry created in table Moments using the predefined defaults for each field.

I've tried the following lines and I'm getting a syntax error for both. What would be the correct method to do this in Access?

INSERT INTO Moments VALUES ()

Access highlights the end bracket after clicking ok on syntax error.

and

INSERT INTO Moments () VALUES ()

Access highlights the first bracket after clicking ok on syntax error.

and

INSERT INTO Moments default values

Access highlights default after clicking ok on syntax error.

Does it have to be a query? You can easily do this using VBA. — Erik A
– Erik A, Commented Jun 21, 2018 at 14:29
No it does not have to be a query. How would you go about doing it in VBA. — Tolure
– Tolure, Commented Jun 21, 2018 at 14:30

Erik A · Accepted Answer · 2018-06-21 14:32:22Z

2

In VBA, this can easily be achieved with recordsets:

Dim rs As DAO.Recordset
Set rs = CurrentDb.OpenRecordset("Moments") 'Open table
rs.AddNew 'Add row
rs.Update 'Commit to table

answered Jun 21, 2018 at 14:32

Erik A

32.8k13 gold badges49 silver badges75 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

How would you get the id of the record newly created?

That's a different question. See this answer. Alternatively, you can use rs.MoveLast and then rs!ID (if ID is your id column)