Does anyone have example code of adding records in a database?

When I try to record a macro of the addition of database records within MS
Query, I don't get the desired results in a VBA Module. I only get the query
string.

thanks