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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by michbell

  1. michbell

    How to split out the Windows Event Log Description field with formula

    That's a bit less complicated! hahaha. Thanks CoSpringsGuy!!!!
  2. michbell

    How to split out the Windows Event Log Description field with formula

    There might be a better way to do this, but I was able to get the fields out by using a combination of trimming left and right. For Source Address, this is what I did: trim( left( trim(right({Security.Description}, length({Security.Description})- 16 - instr({Security.Description}, "Source...
  3. michbell

    How to split out the Windows Event Log Description field with formula

    I'm trying to use CR to run more manipulate-able reports of the windows event log. The problem is that most of the info I need to be able to split out is in the field "description". Here's an example of what's contained in this field: The Windows Filtering Platform has blocked a connection...
  4. michbell

    Extract registry subkeys using Powershell for all users

    Is there a way to use Powershell to get a list of all users (at least all logged in users) on all computers on the network and what subkeys each one has under HKEY_CURRENT_USER\Printers\Connections? I'm wanting one list that shows all the mapped printers all users have, and I thought maybe I...
  5. michbell

    How to get list of all mapped printer connections to all users in domain

    I have been looking for a script (or an actual free program) that I could run that would show a list of all users (that are logged in) and all of the printers they are mapped to. Although I'm concerned more with printers mapped through the network, it would be doubly nice to find a script that...
  6. michbell

    Are Only Domain Admins Allowed to Log In to XP Mode?

    Nevermind - I found the culprit. The default domain policy was specifying only a couple groups with the permission "Allow logon through Terminal Services". Got there by following these instructions from this site: http://forums.techarena.in/small-business-server/623448.htm 1. Click Start...
  7. michbell

    Are Only Domain Admins Allowed to Log In to XP Mode?

    Anybody know why I can't sign in to XP Mode with anything other than a domain admin account. I have a pc with Windows 7 Professional that I'm setting up for a user. In order to continue to use a really old program that they need, I set up XP Mode (while I was signed in to the computer under...
  8. michbell

    Excel field coming through as a Number when really a String

    Thanks Synapsevampire! Creating a link in Access worked perfectly!!!!! I appreciate it!!
  9. michbell

    Excel field coming through as a Number when really a String

    I'm using CR9. I have a report that uses a table from Excel 2003 and one from Informix. These two tables are linked by the field {part_nbr} which is a string. It had been working fine for more than a year, but just recently it stopped recognizing the link. It says that the data types are not...
  10. michbell

    I want a not-so-shared shared border!

    I'm using FP 2002. I am using a top and left shared border. I have inserted a table within each of these borders. In one of the tables, I used a photo for the background of one of the cells. But I would like different pictures on the different pages. I know this kinda goes against the...
  11. michbell

    Display previous group's summarized field

    Thanks for the help, Scott. It worked great! I appreciate it. :-)
  12. michbell

    Display previous group's summarized field

    I'm using CR 9 with Linux. Sample data (grouped by Process): GH: Process Start Date End Date A 8/1/05 8/3/05 B 8/2/05 8/6/05 C 8/7/05 8/8/05 D 8/11/05 8/12/05 start date = minimum({datefield}, {process}) end...
  13. michbell

    Data selection

    Not sure about what you want to display. Could you write a longer example of what's displayed right now and what you want it to display?
  14. michbell

    TopN of Multiple Field Totals

    Thanks for the help, Lbass! The formulas worked great. However, with these formulus, I don't know what code (c1, c2, ... C30) the number corresponds with: whileprinting records; numbervar top1; (and then the one for top2 and top3) So, from the example in my first post, what I need to see...
  15. michbell

    Calculate a date from number of months

    You should be able to create this formula: dateadd("m", {mths}, {DTPurchased})

Part and Inventory Search

Back
Top