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

    Formatting an Excel cell to add dot separators for mac address

    Thanks guys.
  2. jimdevon

    Formatting an Excel cell to add dot separators for mac address

    Thanks kjv1611. I have another question, just curiosity. If I concatenate a cell, can the contents be made permanent. In other words, can the concatenated data be fixed so it is no longer dependend on the parent cells? Thanks for the help on this one. It worked beautifully,
  3. jimdevon

    Formatting an Excel cell to add dot separators for mac address

    That is it! What the deal is I just rolled out about 50 new laptops. I need to create a sharepoint document with the IP, mac address, etc. The mac address field should normally look something like 23.rt.45.3g.45.gj (not a valid address, but the format is right), what I got is more like...
  4. jimdevon

    Formatting an Excel cell to add dot separators for mac address

    I could, of course, use left * starting at, etc. but I would think you could just create a cell format with the . and paste the cells, but apparently not, at least as far as I can tell.
  5. jimdevon

    Formatting an Excel cell to add dot separators for mac address

    No, just letter and number combinations all together.
  6. jimdevon

    Formatting an Excel cell to add dot separators for mac address

    I am trying to take a cell with a text format and add dots between each set of 2 characters for showing a NIC mac address. Thanks in advance.
  7. jimdevon

    Cancelling Reinstall of Windows XP

    Thanks again Linney. I finally decided to keep my new installation on the new drive and reinstall my software. It allowed me to start with a clean drive, since I install some software temporarily, which slows down my system. JS
  8. jimdevon

    Cancelling Reinstall of Windows XP

    Linny, Thanks for the info. It helped me to access my files on the hard drive. I can now import them to my new drive. I wonder if you know how I can access the boot.ini file on my old drive. This would allow me to repair it, which would mean I would not have to reinstall my programs. Thanks...
  9. jimdevon

    Cancelling Reinstall of Windows XP

    I have looked, and could not find a solution for the problem I have. I was having problems with Windows XP Pro on my laptop. I decided to reinstall XP. During install, on reboot, I received an error message. Everytime it reboots, it reverts to install, then reboots, in a loop. I know I can...
  10. jimdevon

    2000 Server Directory Services Restore

    Help!! A company I do work for has had a crash in the Domain server. Here is a brief background. This is a nursing home in a small town. Noone knows who set up the network. The system has a domain controller (W2000Server), and a database server (NT4 Server). They called me and said the computer...
  11. jimdevon

    Finding ", " in a field using an expression

    I cannot get this to work. IIF([wholenm] = "," , 1, 2) also tried IIf([wholenm]= *","*, 1, 2) no luck always get "2". The field wholenm has this format (Smith, John), problem is some people at this company just entered (John Smith). I need to use instring and lenght to pull first name...
  12. jimdevon

    hardware diagnostics

    Help, I am a network and database consultant. Problem is that some of my clients are small, so I have to be everything. Hardware troubleshooting is my weak suit, and I normally tell my clients that they would be better off buying new equipment rather than paying me to fix older systems. I would...
  13. jimdevon

    Corel vs. Adobe... Should I switch?

    Wow, this thread has grown to Biblical proportions. In case any one is still interested; I think the raster vs. vector discussion has been run into the ground so to put in my two cents, CorelDraw is equivalent to Adobe Illustrator (drawing (vector art)). Corel PhotoPaint is equivalent to Adobe...
  14. jimdevon

    How do I show query results in a form?

    Ooops, my bad. I didn't pay attention to your code. I see that you are saving the results to excel. You could of course still follow my suggestion, and then analyze in excel. Sorry for the bad, Jim
  15. jimdevon

    using vbcr in query

    Thanks, Duane. Worked perfectly. Where can I find a list of such objects?
  16. jimdevon

    How do I show query results in a form?

    I am assuming that your only reason for doing this is so that you can view individual records at once, and that you are doing this from MS Access. If so, do you need to use code? or is it ok for your needs to create the query and click the new object button and create a form based on the query? Jim
  17. jimdevon

    using vbcr in query

    I have a query which I use as a recordset for a report. In this report, there is a text field where the report needs to return only the items on the first line (ie. everything left of the first carriage return). I had created a field using x:= Left([fieldname],InStr(1,[fieldname],&quot...
  18. jimdevon

    Damaged database

    Help! I manage a client server dbase with the tables split to the server, and each client with his/her own specialized application. One day last week, I came in to the office and someone informed me that there was a problem with the computers. I found corrupt data is one record in the table. I...
  19. jimdevon

    archiving old data

    thanks all.
  20. jimdevon

    archiving old data

    Thanks for the response Heather. Yes you are correct on all counts. I did use autonumber to creat unique records and used this autonumber field to link the two tables. The problem is that the archived customer records no longer are linked (related) to the services once they are moved. I have...

Part and Inventory Search

Back
Top