I edit a lot of posts every day. I often run across posts with 'Hi' and 'Thanks' on the top and the bottom of the post respectively. I also run across things like:
Should these items be removed during the editing of the post by an editor?
@RoryAlsop My bad, I didn't read it close enough. I worked for a German company that loved it, so I should have remembered it. I do remember Waste Management suing the heck out of them too. It's a nightmare to deal with.
@RoryAlsop Small companies often make the mistake of assuming that since they don't know how to do something, a bigger company does. Not often the case. I can tell you a few nightmares about a publishing application that was so awful that we had to create over 150 applications to support it.
@RoryAlsop I swear, I should write a book. I know a company that took four months and two dozen meeting to change one line of code to add a line in a drop-down menu for a form that was only used for reporting, no processing involved at all, other than printing out the form. The drop down menu item was for a product that had already been in production for over a year.
I've led a very unusual life, and a career to match. I should publish it as fiction because nobody would believe it otherwise ;)
@Trickylastname I once lost a job because the higher ups wanted my director to quit, so they forced him to lay off 1/3 of his staff. He loved all of us, so it hurt him more than it did us. When we were sitting across the table, his face was longer than mine. There is no reason for a firing or a laying off that I will not believe at this point.
He's an hypocrite. The manager as well. The day after my manager broke me the news they talked sh*t of the ones they fired, in plain sight of the rest of the team while sipping coffee. I took the trouble of telling my team mates what happened, before they lie about it.
Anyhow, I wrote an Address class that takes the attributes of a unique index on the corresponding table and provides a function to look up the surrogate ID. The issue is that I made the ID column an AutoNumber and from what I can tell there's literally no value in the LongInteger range that AutoNumber can't potentially take on
Anyhow, everything I'm reading online about how to approach "find a value if it exists" functions is that if it doesn't exist, you just pick some value outside of the range of good values and return that instead.
Which I hate in general, but in particular, it doesn't look like there is such a thing for AutoNumber
I don't have any problem checking within the function whether the result set is empty, what frustrated me is that when I returned from the function without assigning any return value it didn't give me an empty integer - it gave me a default (0)
I guess I'm just going to have to guess at the lesser evil between returning -1 or using Variant so I can return Null
Only other thing I can think of is to create a Type holding the return value and a flag
And then check the flag to decide whether the return value is BS
I'm curious if the term "Power User" has outlived its usefulness. There are several different definitions. Some include nothing more than knowing keyboard shortcuts for Microsoft Word, while others involve maintaining advanced hardware and having at least some programming capability.
Is the ter...
Air, could you make a test system where you start from INT_MAX instead of 0? That way you could quickly see what happens on overflow. The Wikipedia page for AutoNumber doesn't sound like it'd go negative but like you say it's hard to be sure.
I have been working on multiple projects as of late. A few are in my job description others are not. I expect this and have no problem helping out by doing some other projects.
My boss came to me two weeks ago with a project to acquire the missing documents from several employees (we were at app...