Recent content by eric_powell

OK, I've got it all squared away. Here's some more from the immediate window. It appears that it was a decimal issue. ?round(lhs,2)=round(rhs,2) True ?lhs=rhs FalseI went ahead and changed the data types to Currency and that took care of it.

Yes, I am using the decimals. I'm storing currency values, actually. It's just a coincidence that these are flat dollar amounts. On that topic, though, if it were a decimal issue, why in the world wouldn't it be showing any decimals? Is that because the discrepancy lies in the nth decimal...

I REALLY, REALLY hope I'm not making a dumb mistake here. Basically, I'm doing a standard if-then statement, and the conditional expression is being falsely evaluated - or, at least, so it seems. Here's the code: If lhs > 0 Then If lhs <> rhs Then MsgBox "Could not reconcile the...

OK, everyone, I seem to have struck upon the workaround/fix, although it doesn't provide a lot of closure about why this occurs. Basically, I had originally installed access and created the database under a different windows user, one which later got a little messed up (long story)...

Thanks for the suggestion, Bob. Unfortunately, I DEFINITELY have a trusted location set. I appreciate the suggestion, though. Does this seem like an issues I should try to take to Microsoft? Is there anyway to actually take an issue to them?

I can give that a shot, but I already tried creating a new database and filling a single table with a couple records, and even that I could not back-up. So it seems to be a setting or bug that isn't specific to my one database. Oh, and I tried saving, compacting & repairing, etc., and I could...

I, too, am experiencing this same error. I am working on an HP laptop running Vista and Access 2007. The database is in 2007 format (.accdb). I have also found that this behavior occurs even when I create a new database and try to back that up, which makes me think corruption is not the...