<sigh> hoped I was just missing something as this is my 1st time in 2K8... it would be SUCH a useful feature right now.

thanks for the reply.

I am with Paul on this one - store each piece of the name in it's own field (even though this leaves a lot of empty fields for the suffix)....

not a problem... I've been lurcking in this forum for quite awhile and people usually beat me to the draw when I see a post I can actually contribute to...

I didn't put any counters on it but the program is still in use and the form definately opens sub 2 secs.

edit: I guess I should also say that the...

this should give you some hints. This is a function that I wrote several years ago to dynamically create a form based on a cross-tab query. written for...

installation of the software is just like any other - if autorun doesn't start it, find the setup.exe and double-click. Follow the prompts. This will give a default setup...

the contributer was my first guess/assumtion... but then I made another "assumption" and figured they had to go through some kind of review before going live

hmmmm.... hope other...

Glad ya got it... there's always more than one way to skin a... file sytem 😉

look at date and string conversion functions. You can Getdate() convert it to a string in the format YYYYMMDD the concantenate it to the static part of the string...

I believe this can also happen if the user does not have NTFS rights to the folder on the remote server. If you're running under a local account you might...

I could REALLY use something like this... do you have a version that will run on SQL 2000?

I have a DB that has 5 jobs that send about 300 emails on the 15th of each month. These would fail occasionally and it would drive me nuts...

allowing a user to insert free form text is generally not a good idea. From the original post it sounds like you also want to parse out the string....

it would be nice if you would post the solution to the forum so that others could benefit also 🙂

wow... tough question actually, since we're dealing with Microsoft Office product and I hate to 'assume' anything 😉 MY opinion is that all probably went well, but I'd try...