Search results for query: *

Ok, worked like a charm. Not sure if Excel just takes longer trying to sort by highlighting or if something else was at play (had my formula bad or something). Now, on the off chance that this needed to be repeated multiple times, do you think this would be possible in VBA? Some of the...

I'll give that approach try. I tried a similar approach using a conditional formatting formula to find duplicates (as well as the built in one) then sorting by the format, but it froze up trying to sort that way for some reason. Since this is (hopefully) a 1 time deal, I'm fine doing it sans...

First, let me preface this by saying that I haven't done any VBA coding in more than a decade, so I'm pretty much flying blind (or working from some very faint memories). I've been searching around for ideas on this, but most of what I've found is either close (moves the duplicates but not the...

Hoping this is the right forum for this question. I'm trying to come up with a formula to delete all characters after the last occurrence of a delimiter, but I keep getting stuck. I have something to work with text after a delimiter, but ran into a problem when the string contained in more...

The Save As option was there and working, but apparently the piece that would work with the VBA call wasn't, or wasn't working right. Once I re-installed the add-in, it started working right.

Ok, apparently it doesn't mean it's installed (or at least installed right). Re-installing the add-in seems to be working now. Thanks!

But if I see Adobe PDF as an option under Save As, and it works, wouldn't that imply the add-in is currently installed?

First off, for the record, I am not a vba coder. I've taught myself enough over the years to be dangerous, but since I only need to script things once in a blue moon, have never had any official instruction. That said, I'm trying to automate saving an Excel file as PDF using the Acrobat...

Great, thanks muchly! It's painful that the longer I'm in a "non-IT" role (I'm now more of an HRIS Admin), the more I can feel any hint of coding skills draining away. A couple years ago, I might have come up with something close to what you have there. Today, I'm having to stare for half...

Here's a basic CSV dump with most of the columns (think there are about 340 ish in this one - thought it'd be helpful to go over the 255 to test with). Going to try to copy and paste, but if it's too big, I'll find a place to upload. Apologies for the ugly, I just don't have an online file...

Ok, first off I'm starting this in the Access forum as I'd just assume be able to do it locally rather than having to go through our DBA to create something on the SQL Server to work with. However, given the nature of what I'm trying to achieve (which I'm not even sure is remotely possible at...

Ok, this is mostly just a self educational project, but I'm trying to see if this could be streamlined. The field this is reporting on contains 3 statuses, 0,1, and 2 for not started, incomplete, and complete respectively. The idea is to output a count/total % style number for each. So the...

This is a bit odd to explain, but I'm looking to find records that have a one field that's duplicated, while a second field is different. It's proprietary data, so I can't post the exact thing, but here's an example: EmpID EmpName IncidentID 111 Bob Smith 123 111 Bob Smith...

Ok, considering the approaching holiday and severe braincramping as a side effect, I'm stuck on what I thought would be a very simple query. The table stores EmployeeID, EvalID, CompletionDate. I need to pull the record for each employee's latest completion date. i.e. if each employee has 4...

Ok, first off, hopefully this will be at least understandable - medication has my head swimming right now. Second, if this is really simple, it's the drugs making me miss it. :) Basically, I have a table (SQL 2000, not 2005) with a parent/child structure for three levels. Something like...

Perfect. I knew that was there somewhere, just couldn't remember to go to the parent section. Thanks!

Ok, first off, I've not really worked much with Crystal in many many moons. However, my new job does require maintaining and updating some Crystal 9 designed reports. The one I'm working on at present places a graph below a can grow text box. In order to keep them closely aligned, the report...

As far as we can tell, no strange happenings and nobody running any traces. To make matters more baffling, the problem seems to have resolved itself as scripts I'm creating today are showing up as User.

After some further investigation, I noticed that any new procs show up with a status of -536870912 in the sysobjects table. It appears all the system procs have a negative value there and user have positivie. Unfortunately, I still have no idea why they're happening that way. I can switch the...

I'm trying to track something down, but I'm not sure where to look. Basically, starting yesterday, any time I create a stored proc on any db on the server, it gets created as System instead of User. I've tried creating from QA and EM with the same result. Additionally, while QA will accept...