message when just viewing a report

[Jessica]

Hi Everyone,


I have a database that when opened goes to my main switchboard that list
UPC numbers in a list box. These numbers come from a table I have
called UPC. Anyhow when I click on a UPC number in the list box a report
opens up. Every time I close out of Access I get this error message



The message includes the following instruction: Change the data in the
field or fields that contain duplicate data, remove the index, or
redefine the index to permit duplicate entries, and try again.


I am not entering any records and can't understand why this message
comes up. Any ideas? If there is duplicate records wouldn't Access of
stopped me then? Is there an easier way of finding duplicate entries?



TIA,
Jess

 

[David Lloyd]

Jessica:

I cannot say for certain from the information given that the following KB
article is the source of your issue, however, it deals with the same error
message you are receiving, so I thought I would pass it along.

http://support.microsoft.com/default.aspx?scid=kb;en-us;884185

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


Hi Everyone,


I have a database that when opened goes to my main switchboard that list
UPC numbers in a list box. These numbers come from a table I have
called UPC. Anyhow when I click on a UPC number in the list box a report
opens up. Every time I close out of Access I get this error message



The message includes the following instruction: Change the data in the
field or fields that contain duplicate data, remove the index, or
redefine the index to permit duplicate entries, and try again.


I am not entering any records and can't understand why this message
comes up. Any ideas? If there is duplicate records wouldn't Access of
stopped me then? Is there an easier way of finding duplicate entries?



TIA,
Jess

 

[Dirk Goldgar]

Hi Everyone,


I have a database that when opened goes to my main switchboard that
list UPC numbers in a list box. These numbers come from a table I
have called UPC. Anyhow when I click on a UPC number in the list box
a report opens up. Every time I close out of Access I get this error
message



The message includes the following instruction: Change the data in the
field or fields that contain duplicate data, remove the index, or
redefine the index to permit duplicate entries, and try again.


I am not entering any records and can't understand why this message
comes up. Any ideas? If there is duplicate records wouldn't Access of
stopped me then? Is there an easier way of finding duplicate entries?

Check your "main switchboard" form, the one that has the list box you're
clicking on, and verify that it is an unbound form -- that is, that its
RecordSource property is blank. From your description, it should be,
but maybe it isn't. And if it isn't, then if your list box is bound to
a field in the form's recordsource, then clicking on the list box would
be trying to change that field, and *maybe* that is giving rise to a
duplicate-key error when Access attempts to save that record as you
close the form and database.

 

[Jessica]

That was it Dirk. That form some how was bound to that table. I cleared
the recordsource and so far have not had that duplicate message. Thanks
so much.

Jess