The function you are looking for in Access would simply be 'Now()'

INSERT INTO mytable (user_id, subject, message, message_date)
      VALUES ('Bob', 'Lunch', 'Anyone want lunch?', NOW())
[download]

--Glenn