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!

Search results for query: *

  1. erikhertzel

    Excel manipulation question

    I have a spreadsheet of data with some numbers associated with names. The primary number should be associated with only one name, but it currently is not. So, I am trying to figure out how to seperate the primary number out and then issue a new number to the rest of them (mostly husband and...
  2. erikhertzel

    Mail Merge Date field issue in Excel

    I have an excel spreadsheet that has a field of Date So, Column A is 5/15/2006 6/15/2008 etc... Anyhow, the dates exported from an external source and in excel show up like above but if you click on them it's showing the full date and timestamp. I need to do a mail merge in Word, and it's...
  3. erikhertzel

    Office 2003 Excel rounding issue when combining two numbers

    I have a columnA and columnB with numbers in those and want to have a comlumnC with the combination of A+B Column A is 16 digits and B is 6 digits So, here is what I have A B C 5511291000000000 230512 5511291000230510 C is almost right but is rounding the...
  4. erikhertzel

    Wireless hop to my home from neighbors link I had installed

    Hi, I live in a rural area without DSL, cable, etc and we do have a wireless Internet company that I tried to get access from. We did not qualify since our home sits in the valley, but our neighbors 1/2 mile up the hill can get excellent signal. So, they agreed to install it there, but it's...
  5. erikhertzel

    Excel IF question

    I have a Excel question, have this formula: IF(OR(E3>G3,F3>G3),F3 E F G H 0 35 41.44 FALSE 133 0 106.67 106.67 Basically, if E or F are greater than G (4%), I want it to return G -- which is working. But if E or F is less than G, then I want it to return...
  6. erikhertzel

    Remove command in XP with empty sub directories

    I have the following bat file I am running and it does not work quite right (it's a bat file that I want to schedule to run using Windows scheduler): del D:\directory\*.* /Q /S pause This works great except that I have a subdirectory in this directory called the date like this...
  7. erikhertzel

    xp winzip command line issue

    All, I have a small issue that I know is simple, but can't seem to figure it out and did not know where to post. I have Winzip 11 plus the command line add-in. Here is my issue, I should be able to go to a command prompt and type the following: "C:\Program Files\WinZip\WZZIP.EXE" -yp -v...
  8. erikhertzel

    Login Script question

    All, We have Windows Server 2003 AD and use login scripts to map drives (traditional batch files). I want to map a drive for users that fall in a certain group on the AD, otherwise, it does not map if they are not a member of this group. For example: User Adam is a member of Group AA If...
  9. erikhertzel

    IE open new instance/window problem

    Hi, I have a user who is using Internet Explorer and has his favorites on the left. He wants IE to open a new window instead of replacing his existing window of page information when he clicks on a favorite (i.e. he wants a new instance or window of IE everytime he clicks on a favorite so he...
  10. erikhertzel

    DVD Burn failing on NEC ND-2500

    Hey all, I am having a problem with my NEC 2500 drive. It will burn a CDR just fine, but we recently started getting errors when burning DVD's (Could not perform start of Disc-at-once ). I have messed with some settings to no avail. Also, I updated the firmware to 1.09 from 1.07 and also...
  11. erikhertzel

    mounting a new hard drive

    All I am a LINUX newbie and I have added a 80 GIG hard drive in a Linux box (redhat 8 server) and have used fdisk and formatted it in ext3 file system. I want to use it for file storage with SAMBA and would like to know how to create a mount point /dev/hdb (my new drive). Once I get this, I...
  12. erikhertzel

    Can't see SAMBA server

    ll, I am setting up a SAMBA server on a Redhat 8 Linux box. I have gotten it set up and can ping the server and do have SAMBA installed on the machine. I have gotten SWAT set up and can access the SAMBA server on a Windows PC on the network going through SWAT. But, I can't see the SAMBA...
  13. erikhertzel

    Filter by number of char's in field

    I am running CR 8.5 Progress 9.1D Database. I have the following: Job Number 12345 1234567 I have two classes of job numbers one with 5 char's and one with 7. I need to filter and want just the ones with 5 char's, so less than 6 to make sure. How do I do this, my field is a string and is...
  14. erikhertzel

    Boot error

    All, I am working on a Redhat Linux Server that is not booting and giving me some errors like this one (there are about three): Attempt to read block from filesystem resulted in short read while reading block 525 I have done some research on it on the Internet and have tried to run fsck and I...
  15. erikhertzel

    Excel Header/Footer Question

    All, I have an excel spreadsheet that I am using (Excel 2000) that is a simple spreadsheet that tracks a schedule (Months are in the columns with tasks in the rows. I have header and footer information that when you look at the print preview it looks great. But, I wanted to have some place to...
  16. erikhertzel

    parenthesis issue

    All Please have a look at my problem. I am sure it's easy, but I have worked on it quite a while now and can't quite get it right. I posted to correct myself and now my thread is slipping down the page, still an issue. Thanks very much Erik thread149-1226301
  17. erikhertzel

    Parenths...question

    All Progress Database CR 8.5 I had a similiar question a few days ago. I am trying a report that has three parameters: A product group Date range Customer ID Here is my formula {OrderDtl.UnitPrice} <> 0.00 and ( ( {OrderHed.OrderDate} = {?Month} ) or (...
  18. erikhertzel

    Getting two different results

    All I have a wierd problem. Using CR 8.5 and Progress database. I created a report using two parameters so that users could look up a City or a Zip in the database and the report would give them back the results based on their input. Here is my selection formula: {ShipTo.City} <> "" and...
  19. erikhertzel

    Ewido AVG article

    All AVG recently acquired Ewido....read about it below. Any thoughts or comments? Hope it's not like when MS got Antispyware from Giant. Just my 2 cents. http://free.grisoft.com/doc/28191/lng/us/tpl/v5 Best regards. Erik
  20. erikhertzel

    Great free program...

    All, Thought I would give you another tool for the warchest. Some of you may have heard of it. I was visiting personally with the creator of this program and thought you may benefit as well.... Here is the website of the free tool. Read about it before use. http://www.ezpcfix.net/ From...

Part and Inventory Search

Back
Top