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!

Recent content by Oz1127

  1. Oz1127

    Trimming blank Space query

    You're the bomb PHV. That worked like a charm. I owe you 10, LOL. Thanks.
  2. Oz1127

    Split FirstName-MiddleName-LastName up

    Maybe this can help REVERSE NAME: Trim(Mid([NAME],InStr(1,[NAME],',')+1,50))+' '+Trim(Left([NAME,InStr(1,[NAME,',')-1)) FIRST NAME: Trim(Mid([NAME],InStr(1,[NAME],',')+1,50)) LAST NAME: Trim(Left([NAME,InStr(1,[NAME,',')-1)) The first one will put the first name first, or vice versa.
  3. Oz1127

    Trimming blank Space query

    I was trying to get the original (Doe , John) replaced with (Doe,John) just ommitting the blank spaces in the fields. Sry for not posting in the correct forum
  4. Oz1127

    Trimming blank Space query

    Tried it but it removes everything before the ,. Doe , John replaced by John. Thanks a lot though, you helped get me started PHV. I'll try playing with the replace function to see if that helps. Not sure whether the Trim function will do it or not. Thanks again.
  5. Oz1127

    Trimming blank Space query

    I've used the trim, left and Mid functions before but, I am having some trouble trimming blanks out of a field. The field is formated as such: Doe , John. Notice the blank spaces? I tried different variations (Mid([Wnab],InStr([Field4],',')+1) of functions and arguments but to no avail. Not...
  6. Oz1127

    Field format

    Thanks Gyz, Is it also possible to use modules in Access and do the following? Function ReverseString (MyString As String) ReverseString = StrReverse(MyString) End Function http://support.microsoft.com/?kbid=210439 I didn't have to much luck with it it, just wanna know if there is another...
  7. Oz1127

    Field format

    I have a field within a table like the following: Doe,John. Can someone help me with an expression that would switch it around? Like, John Doe. I'm getting everything but the result I want. Thanks in advance for the help.
  8. Oz1127

    Exporting/Importing Group Policy Settings

    MrTBC, I think you may be sol on this one. The only option for importing to the local security policy is an "inf" file. And when you export/backup the GPO from GPMC the exported files are placed in a folder and stored in .xml format. Here's an example from a template we apply to desktops at...
  9. Oz1127

    NT 4 Server Rebooting at Startup

    Install service pack 6a on both systems
  10. Oz1127

    XP and NT 4.0 Server

    First,Make sure that your Xp systems firewall is turned off. And on the local area connections authentication tab, make sure that the "enable IEEE 802.1x authentication for this network" box is checked. In the EAP type, select Smart Card or other Certificate. You may need to remove the system...
  11. Oz1127

    DNS Problems

    Today I had an interesting issue at work. For some reason our DNS server got screwed up and everything,(web,internal/external mail) was getting routed to myfamily.com. Has anywone experienced this issue before? we're checking logs on our firewall and log monitoring server to see what it might...
  12. Oz1127

    Need help Access

    Thank PHV, I'll try that and see if it works this morning. I appreciate your quick response.
  13. Oz1127

    Need help Access

    Empid FirstName LastName Supervisor "george adams" "" "" kelly Bundy" Dave Doe "" "Lisa Kudrow" "Billy Joe" This is how the table looks after it's imported, some fields have blanks, quote marks, or leading/trailing quote marks and the table I'm joining it to in...
  14. Oz1127

    Need help Access

    I have a thread that was answered before on this subject, but I've tried everything and my results are just not right. My question is: How do I get rid of blank space in a field(that I can't tell is there), and how do I get rid of quotation marks that preceeded and trailing data within the...
  15. Oz1127

    Need help Trimming Data

    Thanks for your help gyz.Both of those helped,saved me alot of time.

Part and Inventory Search

Back
Top