Search results

I checked the laws in Michigan, and the OT baseline is 80 hours over two weeks OR 8 hours in one day. That last part is never, ever enforced, however. Keep in mind that IANAL and it's written in legalese, but the baseline is 80/8. It's the exceptions that get hard to decipher. I used to...

Wow, you literally just called education 'weaponizing of children'. Well, now we know were you stand on that whole new-fangled 'fire' thing.

Riiiight.

The @ is a character placeholder. It shows the appropriate character if that position in the string is filled, and a space otherwise. Note that it 'fills' placeholders from right to left, so spaces will be added to the start, not the end. Basically, if the format is '@@@@@' and the data is...

Oh, and let's not forget the blatant hypocrisy in claiming you couldn't vote for Clinton because of her emails, but being perfectly fine with the Trumps (and, I believe, Kushner) using private email servers and unsecured cell phones for government business, not to mention Trump overriding the...

I've followed the climate change fight for half of my adult life by now. As with my political beliefs, I've moved from the conservative 'it's a hoax' stance to the liberal 'it's a threat to all life' position in the late 90's and early 2000's. I regularly check up on the for and against...

Doc, I really don't want to pile on, but in the time I've been here, you absolutely have shown a pronounced habit of arbitrarily discarding any and all facts and arguments that don't match your preconceived beliefs, be they political or scientific. If you don't already agree with or believe it...

Okay, figured it out. I had to move the AcroDoc opening and assignment inside the do loop, so that a fresh one was created each time. This was happening because some of the fields are flagged as 'required', and while Adobe would let me assign an empty string to an empty required field, it...

Nulls in PO Number for all three: No error encountered Values in PO Number for all three: No error encountered Change the order of field assignments: No change. Export 3 always fails on PO no matter where in the list it appears. (Except, of course, when 1 and 2 already exist and were skipped.)...

Okay, so I'm exporting the results of a query to a fillable PDF and saving them to a different folder. Null sweat, right? The problem I'm running into is this: My first two files generate just fine, but the third one kicks back a Type Mismatch error. I've determined which line it is (the PO...

The word you want is 'hasten'. 'Fasten' means something completely different. :) Indexes covering your WHERE clause *MIGHT* speed things up - it depends on whether the search speed enhancement from the WHERE clause is greater than the reindexing speed penalty the index itself imposes...

Sorry, Colin, I'd have replied if I had examples of any of them laying around. I HAVE seen both MSysCompactError and MSysRecoveryErrors before, but they were at previous employers so I can't get my hands on the files. The other three are new to me.

After checking on Colin's suggestion, let me ask you this: did you actually import the clsMeter module from my files into your database? If you copied the code from it instead and just pasted it, then you need to make certain that you saved it in a class module, not a regular one. I bring...

You know, I think you're right. It should be -1, not +1.

Damn, I left the backslash out. Updating my original post.

Try this: Format$(DateAdd("q", 1, [Hours].[WeekEnding]), '\Qq yyyy') Edit: Accidentally left out the backslash.

You could write VBA code that cycles through every table, identifies any memo fields, then builds and executes SQL on the fly to delete the contents of those fields. Whether that's faster than just doing it by hand will depend on the number of tables and your skills at VBA.

In fact, now that I think about it, you're never going to get it updatable until you include the fourth part of that key (REGION_ID) in your join, because the only way it works is if you join on a unique index. Think of it like this: For some reason, you have an app where you need to look up...

Okay, I've done some testing on this for you, and here's what I got to work: I created one table called ThirdPartyData with the three fields you mentioned above (ROUTE_DATE, ROUTE_ID, and INTERNAL_STOP_ID) created as a primary key, as well as three other fields Stuff1, Stuff2, and Stuff3. I...