Duplicate error on only certain inputs

[iarerobot]

I keep getting an error when I select a different 'unit' other than uCi for my database. I have no idea on where to start as I am new to Access and this project was given to me yesterday.

https://drive.google.com/open?id=0B3nDTeDCtvD2cGp0RmVxTEhZSFk

 

[plog]

Context.

Without using too much database or your industry jargon, explain what this database represents. Then further explain how/where you are selecting a different unit --a form, a table?

If you could post your database itself that would be helpful as well.

 

[iarerobot]

Context.

Without using too much database or your industry jargon, explain what this database represents. Then further explain how/where you are selecting a different unit --a form, a table?

If you could post your database itself that would be helpful as well.

https://drive.google.com/open?id=0B3nDTeDCtvD2cGp0RmVxTEhZSFk

It used to work on old Access versions (or so I've been told) and when they ported it over to 2010/2013, it broke with this duplicate scenario.

 

[plog]

Huh? I think you just might be a robot.

Answer this:

On a scale from 1-10, what religion is the most magenta?

 

[iarerobot]

Huh? I think you just might be a robot.

Answer this:

On a scale from 1-10, what religion is the most magenta?

I'm not a bot :/ I just don't really know this project. All I know is that we want to change the units other than uCi.

 

[plog]

Then I will make my request again:

Without using too much database or your industry jargon, explain what this database represents. Then further explain how/where you are selecting a different unit --a form, a table?

If you could post your a screenshot of your relationship view that would help as well. (I'm not downloading any file or following any link you provide)

 

[iarerobot]

Then I will make my request again:

Without using too much database or your industry jargon, explain what this database represents. Then further explain how/where you are selecting a different unit --a form, a table?

If you could post your a screenshot of your relationship view that would help as well. (I'm not downloading any file or following any link you provide)

This is supposed to collect all the waste bins for the health and safety department. It then totals everything, depending on which unit it is so we use a multiplier. It uses a form to change units.

 

[Uncle Gizmo]

I've had a quick look at your database and I suspect the problem is with the query detailsub:-

SELECT unitactivity.unit, unitactivity.multiplier, details.entry, details.unit, details.Activity, details.Isotope, details.wastetype, details.permitnumber
FROM unitactivity INNER JOIN details ON unitactivity.unit = details.unit;

I don't like that query, I don't like the look of it and the way it's done. I'd have to study the database in detail to work out why it's done like that. My suspicion is it never would have worked in a later version of MS Access earlier versions of MS Access are very forgiving. You could do stupid things and it would work, problems only coming to light when you upgraded, just as you have done now. However, I don't know for sure. That's just my suspicion. I am not able to spend any more time on it.

 

[plog]

What form is this occuring on? What's the name/?

 

[iarerobot]

What form is this occuring on? What's the name/?

WasteCard, if it helps, I think there's something off with the multiplier in the UnitActivity table.

 

[iarerobot]

'details' form, if it helps, I think there's something off with the multiplier in the UnitActivity table.

Any more help would be appreciated.

 

[plog]

You've based that form on a query (detailssub)--you shouldn't do that. When you want a form to interact with data (add/edit/delete) you should base that form off of a table.