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

    How to split 2nd delimiter in string? CR 9.0

    I have some data such as the following: L41-0080H1/H1-18X24 L43-0050H1/H0-9X12 I'd like to be able to split it at the second hyphen so that it reads... L41-0080H1/H1 L43-0050H1/H0 I have the following formula, but it splits at the first hyphen, not the second. Stringvar array MatCode :=...
  2. Digitalcandy

    Text fields in CR XI are being compressed

    I just installed XI and then put SP4 on. I immediately notice all of my text fields are compressed. Anyone see this happen? Even creating a new report, text fields come out looking compressed. In the image below, the text box contains "Hello World," but as you can see, it is unreadable due...
  3. Digitalcandy

    Where to get updates for CR XI?

    I have a copy of version XI, but I don't know where to get the updates for it. SAP only has updates for XI R2. Does anyone know where to get updates for XI? Does XI become R2 from an R2 patch, or is XI R2 a version of it's own?
  4. Digitalcandy

    MAS90 vs MAS200....what is the major difference?

    I may be taking a job where I'd have to administer and draw reports from MAS200. I'm familiar with MAS90, but I can't find a whole lot of difference on the internet between the two. At my current employer, we use MAS90 among 10 networked users, but it seems MAS200 tries to sell itself on being...
  5. Digitalcandy

    How to convert mail.yahoo.com into yahoo.com?

    On MS SQL 2000, I have a field that stores host names from Microsoft ISA logging. I want to pull out the domain name portion of the host for .com and .net domains only. Sample data would end up looking like so... US.f840.mail.yahoo.com --> yahoo.com www.yahoo.com --> yahoo.com...
  6. Digitalcandy

    Reinstall NAV 8.1 on reimaged server...what to do?

    I have ~80 clients on version 8.1 connecting to one physical server. I need to reimage the server for various reasons, and I'd like to know if I need to back any of the NAV data up on the server. Do I need to do anything in regards to the NAV server software such as backup and restore any type...
  7. Digitalcandy

    MAS90 integration with our SQL MRP package

    Hopefully someone can give me some insight. We have an MRP system that runs on MS SQL 2000, and we are running MAS90 for accounting, purchasing, sales orders...etc.. We'd like to synchronize applicable data between the two systems, but the software vendor for our MRP says he can't do it...
  8. Digitalcandy

    Visual Basic noobie...calculator question VB2003

    For my VB class I have to make a simple calculator. One of the inputs is percentage discounted. If someone enters .10 into the percentage discounted text box should I treat it as .10% or convert it to 10%? Here is my VB code for reference...
  9. Digitalcandy

    Windows VPN...Secure?

    I've got a smallish network with no routers on the LAN. I want to setup Windows VPN to allow some of the laptop users access to resources while they are out of the office. Is the Windows VPN solution secure and used commonly, or do most people buy 3rd party software with hardware keys (RSA)...
  10. Digitalcandy

    2 DHCPs for redundancy?

    I've got a single site LAN with no routers and ~120 DHCP enabled computers/devices. I would like to implement DHCP on my second of two AD servers, but I am very low on IP addresses due to Windows VPN and Dial-up access (20 total reserved). I inherited a LAN that leases out IPs from...
  11. Digitalcandy

    Robocopy...."Extras"... what are they?

    Below are my summary statistics for my session of Robocopy last night. Command usage: Robocopy /E /copyall /R:5 /LOG:D:\robolog.txt /FP /TEE ------------------------------------------------------------------------------ Total Copied Skipped...
  12. Digitalcandy

    Active Directory tool for mass changes?

    I once used a tool that would open a GUI that looked similar to a user object. If you made a change with this tool, it would make the change to all users in the Directory (might only affect the container and subs, not sure). I can't remember the name. Anyone?
  13. Digitalcandy

    User rights to add computers to domain?

    I have a desktop support person working underneath me, and I want to give him the ability to add workstations to the domain. Without placing his user object in the "Domain Admins" group, how/what settings do I need to change to make this happen?
  14. Digitalcandy

    Check Group members

    Is there a way to emulate Group members all at once without supplying the full path to the OU the group is in? Right now I'm using the sample code from Microsoft, but it requires the exact location in AD, and it also lists each user one at a time. Sample code I'm using: Set objGroup =...
  15. Digitalcandy

    How to choose Top 1 of all records?

    I have a table that has ~20 columns of various types such as boolean, nvarchar, and numeric. Is it possible to select the Top 1 of all records for each key? Sample: TravLotID(key) Gold(boolean) Status(Nvarchar) 2 1 today 2...
  16. Digitalcandy

    Stuck in a loop, how to counteract it?

    I am calculating business days using Ken Hamaday's code below, but I get an error stating that I've exceeded the maximum number of loops. How do I fix it? //Subtracting Business Days: WhileReadingRecords; DateVar Target := Date({Table.DateTime}); NumberVar Add := -20; NumberVar Added := 0...
  17. Digitalcandy

    Code help please...gathering logical disk information.

    Below is the code I'm using; strComputer = "Computer Name" Set objWMIService = GetObject("winmgmts:" _ & "{impersonationLevel=impersonate}!\\" & strComputer & "\root\cimv2") Set colDisks = objWMIService.ExecQuery _ ("Select * from Win32_LogicalDisk") For each objDisk in colDisks...
  18. Digitalcandy

    Installing and setting default printers via .VBS

    I am using an edited version of markdmac's LoginScript.vbs, Thanks Mark, and I am having trouble with some code. I want to install and set default printers based on group membership. Below is my edited version which isn't creating or setting the default printer when I specify the correct UNC...
  19. Digitalcandy

    How do you remove a mapped drive with VBS script?

    Currently I'm using the following to disconnect map drives; WSHNetwork.RemoveNetworkDrive "G:" But all this does is "disconnect" the user from "G:" The user can still go into "My Computer", see the disconnected drive, double click it to go right in. Also, when the computer is restarted, "G:"...
  20. Digitalcandy

    CALs, How many do I need?

    I've searched through the archives on this site, but I'm still a little unclear. * 10 WinXP workstations * 3 Win2003 servers * All 10 workstations will connect to all 3 servers at the same time. In this scenario, how many Win2003 CALs do I need? From my understanding, I need 10 CALs. Is...

Part and Inventory Search

Back
Top