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!

  • Congratulations Mike Lewis 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: *

  • Users: jollyreaper
  • Order by date
  1. jollyreaper

    Display full contents of database with a simple script

    I know that there's a way to do this, I know my pseudocode should be close (hopefully) to correct. I want to be able to take a given table from the database and display all records for all fields without having to manually type in the field names. I remember that you're supposed to be able to...
  2. jollyreaper

    Excel won't accept formatting of numbers

    Ok, so I have a cell that shows 38718. That should be a date. Ah, so it's obvious I should format the cell and say "number is date", right? You followed my line of thinking. Wrong! It refuses to take that formatting. I checked on one of the other sheets in the workbook and it has no problems. If...
  3. jollyreaper

    Insert Line Break into Concatenation

    Ok, I sussed out the problem. It's called "Crystal Reports is buggier than a Windows Beta." I designed the original report months back and everybody was fine with it. Now all these months later, they want to make a change. No problem, right? I run the damn report from Crystal Server and I...
  4. jollyreaper

    Insert Line Break into Concatenation

    Well, this is pretty weird. Looking through the site more, it says chr(13) or (10) should work. I made a test formula and it worked ok, still not sure why it's not working in my big formula.
  5. jollyreaper

    Insert Line Break into Concatenation

    I need to change the way a formula is working. Right now it's taking variables and making them look like this: "variable 1, variable 2, variable3" I need to make it look like: "Variable 1 Variable 2 Variable 3" I'm using logic to remove variables that are blank. dim text as string if...
  6. jollyreaper

    AD and Permissions and Insanity

    Anybody have good recommendations for learning up on Active Domain and how permissions work? It's kicking my butt right now with inexplicable craziness. I'm trying to lock down certain directories to make them more secure. I have administrator as owner for everything so I can make sure the...
  7. jollyreaper

    Excel / Sever 2003 permissions problem -- cannot access file

    Not sure whether I should post this in the Office forum or here. Hopefully here is more applicable. We're running an intranet and keep our important company forms on pretty little pages. The company is growing in an ad hoc fashion so we're implimenting some security features a little later...
  8. jollyreaper

    Smartest way to align text

    Well, the reason why I think the separate objects isn't the easy way is because they can be a pain to align properly. Crystal has a ton of stuff it can do that Excel can't even dream of but for other areas, Excel is much faster. The dreaded trade-offs.
  9. jollyreaper

    Smartest way to align text

    Grr, curse of the stupid fonts. The editing window fonts are serrifed, the post renders with arial. How I wanted it aligned was with the right-side zeroes aligned vertically, just like you'd have on an accounting report. The problem with the right aligning is that it will affect everything...
  10. jollyreaper

    Smartest way to align text

    I have a report that is trying to present several calculations lined up properly. What I'm trying to do is something like this: Units: @unitformula Options: @option formula ======================== Total: @total formula When I first started using Crystal, I would have done that by making...
  11. jollyreaper

    VSS for backups

    And we can set permissions on exactly who can do what kind of restore? I can see letting a department head do the restore but I wouldn't want to let Dizzy the Plucky Intern do the same thing and overwrite the most current version of the file with an old one. Or would that current version also be...
  12. jollyreaper

    VSS for backups

    Cool! We'll start testing that out.
  13. jollyreaper

    VSS for backups

    Neat! How much space will it tend to eat up? Say I have a folder that has 100mb of data, 10mb per file, that's constantly accessed and revised. How much bloat are we going to see from the shadow copies? Would each copy be 10mb a pop, max of 64 copies = 64x10mb = 640mb per file? Or am I...
  14. jollyreaper

    Backup Procedure Recommendation

    I have nothing to add to this aside from "ditto!" We have a lot of tools at our disposal here but it's hard to detemrine the smartest/best approach. We have a tape drive and Vertias and full backups take ages. We also run out of space when we try to do fulls on a biweekly basis with...
  15. jollyreaper

    VSS for backups

    How reliable is VSS? On paper, it sounds more convenient for the end user than Veritas but I'm ascared of the hell that could happen if it decides to stop working in a typical Microsoft fashion.
  16. jollyreaper

    What to do about those garrish intelitxt ads?

    Very annoying. I assume they're using javascript to make these ads pop up in the discussions. Do we have to disable javascript to make them go away? It's like the bizarro world cousin of hyperlinks -- hyperlinks link to good and useful information, these intellitxt links bear no relation to the...

Part and Inventory Search

Back
Top