Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Moebius01

    Excel Move Original and Duplicate Rows to New Sheet

    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...
  2. Moebius01

    Excel Move Original and Duplicate Rows to New Sheet

    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...
  3. Moebius01

    Excel Move Original and Duplicate Rows to New Sheet

    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...
  4. Moebius01

    Excel Formula - Delete after last occurrence of delimiter

    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...
  5. Moebius01

    Using Acrobat PDFMaker Add in from VBA

    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.
  6. Moebius01

    Using Acrobat PDFMaker Add in from VBA

    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!
  7. Moebius01

    Using Acrobat PDFMaker Add in from VBA

    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?
  8. Moebius01

    Using Acrobat PDFMaker Add in from VBA

    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...
  9. Moebius01

    Separate Columns into Rows

    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...
  10. Moebius01

    Separate Columns into Rows

    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...
  11. Moebius01

    Separate Columns into Rows

    ...a CSV style export. The challenge that their system exports 1 row per respondent, so the table has every person/question as the fields (130 people * 4 questions = 520 fields, plus the respondent data). What I ultimately need is a row per person rated with the respondent ID, the ratee ID...
  12. Moebius01

    Buried in a sea of Casts

    ...into the mix, I arrived at this: SELECT '(' + CAST(SUM(CASE STR.SelectionStatus WHEN 0 THEN 1 ELSE 0 END) AS VARCHAR(3)) + '/' + CAST(COUNT(*) AS VARCHAR(3)) + ') ' + CAST(CAST(CAST(SUM(CASE STR.SelectionStatus WHEN 0 THEN 1 ELSE 0 END) AS FLOAT) / CAST (COUNT(*) AS FLOAT)*100 AS...
  13. Moebius01

    Find Duplicates in one field, but not in two.

    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...
  14. Moebius01

    Selecting Grouped Rows With Max Value

    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...
  15. Moebius01

    Recursive Query - Find Grandparent

    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...
  16. Moebius01

    Prevent overlap when using Can Grow option

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

    Prevent overlap when using Can Grow option

    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...
  18. Moebius01

    Suddenly all new procs create as System instead of User

    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.
  19. Moebius01

    Suddenly all new procs create as System instead of 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...
  20. Moebius01

    Suddenly all new procs create as System instead of User

    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...

Part and Inventory Search

Back
Top