Search results for query: *

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

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.

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

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.

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

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

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.

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

Install service pack 6a on both systems

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

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

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

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

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

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

Does anyone know how to trim data in a particular field using a query I'm not proficient with Access yet and I've used the trim function before but never to trim dat in an existing table using an update query. ex. *****\crajo01 (*****\COR1S007_Operations)is the data currently in the field. * =...

Here's what you've gotta do: in the design view of your report there is a header and footer section,(I'm sure you know this).Use your mouse and drag the section for the header down, you'll see a blue line which if your mouse is placed on it will change to an arrow.Drag the line to the left to...

Quest software makes a domain migration tool which we're using in an AD migration currently and though you may be already fully migrated, (and I don't know whether your using a single or multiple domain AD model) it can help you accomplish what your trying to do and report if there are errors so...

Does anyone know why numbers in a column in Excel change when imported to an Access2K table? Ex.I have numbers 1.10,1.30,etc but when I import them into Access it changes the data to 1.1 and 1.3 respectively. I've tried the advance import menu, changing table properties,damn near everything but...