@JaredBusch said:

@garak0410 said:

A lot of these VBA projects have many For/Next loops that take an eternity to step through (F8)...I thought STEP OVER (SHIFT-F8) would get me through these but alas, doesn't seem to do it...either I am impatient for these For/Next loops take forever to get through, even holding down F8. Is there a faster way to get through these?

Been a while since I was in VBA but I think it is F5 to run to cursor? Stick the cursor in front of the next line after the loop and hit F5 (or whatever run to cursor is).

@garak0410 said:

dteEnd = Application.Sheets("Report").Range("$J$27").Value

This is a logic error. A cell can always be converted to a date if it is 0. it converts to midnight like that if you dump it into a date variable.

I would need to see the logic to troubleshoot more. Been a while since i used VBA.

I'll give F5 a try.

What is interesting about this dteEnd thing, is at some breakpoints, it does show 1/6/2015 but near the end of the Macro, it gets assigned the 12:00 AM. And because someone else wrote this like 7 years ago and without knowing their logic, this has been a chore.

Glad to hear that it is all working well!

Makes sense.

Well, we use System Center Config Manager ad we slip in drivers, patches and Domain join

Well, at least it isn't a password expiry policy.

Something else that I have noticed is, at least from what I have seen, PDFs tend to be tiny compared to most other ebook formats.

I love the support/web dev companies that contact me with no opt out using gmail accounts. They change the from address each time but not the sales pitch.

@IRJ said:

Enabling Static Content fixed all the styling issues too. It looks like everything is working now

Cool

@technobabble said:

@GregoryHall does that also work for remote desktop users?

Yes, it pulls directly from AD. So it its in AD you will see it with this tool.

@milnesy

I have had to follow this type of procedure I believe called "side-loading" explained here: http://www.gizmag.com/how-to-install-google-apps-kindle-fire-hd-hdx/30736/

@technobabble said:

@scottalanmiller Thanks...I didn't think so, but with this client, I had to be 100% sure.

Most tools, like WordPress as an example, do an export for every backup operation.

Sorry everyone for a late response. Just been dealing with some family health crisis. As far as the personal files. I've learned that the IT team has locked down everything via group policies. My girl has to ask permission to do almost anything she needs to do for work. As for the type of Exchange server they are hosting, I don't know. I'm sure they're not going to give me that info. lol! Thank you for your support and feed back on the matter.

HAPPY NEW YEAR!

@MattSpeller said:

@lance Looks sweet man, but I promised myself long ago - no more non-standard keyboard layouts. Goes double for laptops; give me a proper keyboard layout or give me death!

Same here, has to be a standard keyboard. Except for replacing the caps lock. Make that a Sun-style control button!!

It's always best practice to disable root login over SSH, especially from the Internet; use su or sudo for root access. Another good practice is to disable password-based authentication; only use keys with a passphrase. The setup you're doing here is useful for allowing scripted/automated connections between machines (e.g. for backups, scheduled tasks, etc) but they should be accounts with limited access, not root. You should be creating layers that make it difficult for someone to gain access to your systems; root keys with no passphrase means you're solely relying on that one strong password (which is one keylogger away from being defeated.)

@JaredBusch said:

Especially since you only need one recursive query on one table. This is a basic org database query using a CTE.

Except you need some weird loopbacks and stuff. For those of us from severely inbred families it gets pretty complicated.

@Rob-Dunn Yup, I hope it helps!

The email interface is not even shown! They either haven't figured out how to make it yet or they are not too proud of it.

AWESOME!

@Nic said:

For anyone who is a satisfied customer, cast your vote here 🙂 http://community.spiceworks.com/spice_list/show/397

Done!