Certain data values not appearing for my users - but it's OK for me

[AndrewB]

Can anyone help with this? It will sound weird to you and you probably will think I'm pulling your leg but it is all true!

I look after an Access 2000 Database. There is an existing report to which I added two new columns - one shows the results of a text box (where the values are H or S or blank) and the other shows the results of a tick box. in the report, the latter says "If True, then display A else blank"

On my screen, when I run the report, I get the values as expected - H or S in the first column, and A in the second as appropriate.

However, my users rang to say they weren't seeing the values - firstly some of (the four of) them were OK and others weren't...then none of them were seeing the values.

I went up to see them and, sure enough, they can't see the values. I checked the underlying query...it is pulling the values in but the report won't show them. The other fields for the detail line display fine but not these two.
To be precise, it would show S in the first column but not H.

I changed the H values in the underlying table to be X - and they displayed OK! A, B etc were no good but X was fine.

Similarly, for the text box column, A or D or P or W wouldn't display if the condition was True but Y does display.

So, what on earth is going on?

Andrew

 

[boblarson]

Here's a longshot for you. Try opening the database on the other user's machine and go into a module and then go to Tools > References and check to see if there are any references marked as MISSING. I wouldn't think that there would be, but if there are that could potentially be why it works on yours and not on theirs.

 

[AndrewB]

Here's a longshot for you. Try opening the database on the other user's machine and go into a module and then go to Tools > References and check to see if there are any references marked as MISSING. I wouldn't think that there would be, but if there are that could potentially be why it works on yours and not on theirs.

Bob

Thanks for the suggestion. I haven't had a chance to check this out (users are at another location) but will hopefully do so soon and let everyone know.