Problem with Append Query (1 Viewer)

R

RudeYute

Guest
Am trying to use a parameter query to append a record into a table.
7 or 8 parameter popups come up, for the user to insert the details. One which doesn't popup is supposed to insert the current time/date using the Now() clause (not sure if that is causing the problem).

When I insert items into the fieldboxes, I try to append, but then get the attached error, not sure why.

I was told that the error occurs when a primary key is used, but that is not the case.

Anyone help please?

Thanks
 

Attachments

  • accessappenderror.JPG
    accessappenderror.JPG
    28.1 KB · Views: 130

DocNice

Registered User.
Local time
Yesterday, 21:48
Joined
Oct 6, 2004
Messages
76
You don't have a primary key on the table you are trying to append?
 

Users who are viewing this thread

Top Bottom