Trouble With Fieldnames Containing Spaces RESOLVED

Help! I need to write a SQL statement to INSERT a record into an Access table, which has an Autonumber field as its primary key. Sadly, many of the fieldnames contain one or more spaces in the name (eg. "field name").

When I try to write the insert statement with the fieldnames specified like this:
INSERT INTO tblOne ( fieldname1, fieldname2, field name 3 )
VALUES ( value1, value2, value3 )
the spaces in the last fieldname cause a problem.

When I try encasing the problem fieldname in brackets, like this:
INSERT INTO tblOne ( fieldname1, fieldname2, [field name 3] )
VALUES ( value1, value2, value3 )
SQL thinks I want to be prompted for a value.

When I try to use the fully-qualified name in the insert statement like this:
INSERT INTO tblOne ( fieldname1, fieldname2, tblOne.[fieldname 3] )
VALUES ( value1, value2, value3 )
I get a SQL syntax error.

Then I tried doing the insert without spelling out the fieldnames at all, like this:
INSERT INTO tblOne
VALUES ( value1, value2, value3 )
but I am required to provide a value for every field, including the autonumber field, which defeats the purpose of the autonumber.

Any ideas?