Software

Ask something
Discussion Locked

Explain this anomaly

0 helpful
19 replies

by tink!

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have an Access 2003 database. When you enter a Raw Material Cost on the form, it automatically figures out whether the new price is lower or higher than the previous value that was in the field.

Now it works great. Been for over a year now. However, on 2 occasions (1 being today) I have encountered an anomaly where it refuses to say that a particular price has increased. Today's magic number is 10.09

No matter what lesser number I put in, from zero to 10.08 [i](no I didn't try EVERY single number)[/i] it will NOT say Increased when I enter 10.09

It WILL say Decreased if I enter a larger number and then put in 10.09

But I need it to say Increased. Ok, NOW it says it! If I put in a lower amount. Then go to the previous record and come back. Reenter 10.09 it FINALLY says Increased.

Weird. :)

19 replies

by tink!

:D

I don't remember what number it was for the 1st time. But to enter over 350 records, and have the database work fine for a year, THEN encounter this - it's gotta be something weird!

by boxfiddler

black hole, named MS. :D

I'm only half kidding. The oddest things - minor glitches - occur in virtually all MS offerings for no apparent reason, and only after the software has been behaving so well for so long!

by the scummy one

too much un-needed garbage in the code! A few examples
Open Word, if you have a few network connections that are unavailable, but you are connected to the network -- your system can completely hang for everything, for several minutes!
Put in a bad cd/dvd. WTF -- in the old days, it would say the drive/disk was unreadable, however CD's/DVD/s will hang a system for upwards of 10 minutes????
Hiding temp folders (think OLK* folders), where even if you mark for show protected OS files, it cannot be found unless you browse to the path and type in the folder name!
just a few key examples of MS SW stupidity

by tink!

I examined and re-examined my VBA scripting over and over. But nothing was out of place.

Today I knew it wasn't my coding. So I just tried different numbers and other things til it finally worked. LOL! :D

by tonythetiger

that many people won't question the results, even if they don't look right, then end up making life-altering decisions "because the computer said..."

I just switched from OfficeXP to 2007, and a chart in one of my worksheets was looking 'funny'. It wasn't anything important, or fancy, just a graph of disk space used on the server over time. A real simple X-Y graph with area shading. After the version change, the shading had a conspicuous "missing area" in the lower right that I spent far too long trying to find what was wrong and not finding anything.

I ended up deleting and re-creating the chart.

Gremlins, I guess....

by jmgarvin

Access is a mess, it does so many freaky things, that I tend to think MS does it on purpose ;-)

by tink!

I've done several Access databases for different purposes, and this one is the first to have an anomaly. Of course, notably, this is also one of my most "complicated" with alot of coding.

This is also the first one I created with Access 2003. My others were with Access 2000. :)

But I don't really find it surprising - we've all come to know these strange anomalies of Microsoft. If they disappeared altogether - would we miss them?

by the scummy one

Hmmm, would I miss random BSOD for no apparent reason sometime every 4-5 months (apart)?

Would I miss spending an hour or two trying to figure out why something simple just fails to work right, but re-creating the template fixes the issue?

Would I miss 'file not found' errors, when I can look right at it?

Would I miss extra 'features' that are not beneficial, or really even 'features'?

Answer that and you may find why I have been using Linux at home!

Well, to be truthful, I still use XP at home a lot too...

by jmgarvin

Recently, I went to print a PPT. It was about 50 slides and about 8mb (images and various notes and stuff) is size.

When I went to print it, it ballooned out to about 400mb in size (in the printer queue) and BSODed my machine....BUT, if I printed it without borders, it was fine...

Go figure...

by tink!

have had similar weirdness. :D

Hey JM, the movie in your avatar - was it any good? Have seen it at the video store and was curious. :)

This discussion is closed to new replies.