How about where instr(substr(xfield,1,3),'(') > 0 or instr(substr(xfield,1,3),')') > 0 or instr(substr(xfield,1,3),'/') > 0 or instr(substr(xfield,1,3),'%') > 0 or instr(substr(xfield,1,3),':') > 0 Can't remember if the % or : character need to be escaped. :) Chris Meech I am Canadian. [heard in a local bar] In theory there is no difference between theory and practice. In practice there is. [Yogi Berra] posting about Crystal Reports here is like discussing gay marriage on a catholic church’s website.[Nishant Sivakumar]

Member 4420534 wrote: the grid is empty and stays empty ColName LIKE '*test' I are Troll :suss:

We had the same problem, and finally decided to write a small AppVersion.exe that checks a local AppVersion.txt and compares it to the server's AppVersion.txt - if different, it shows a message informing the user that an update is being installed, installs the update from the server, and replaces the local AppVersion.txt from the one on the server. Whether an update was done or not, AppVersion.exe starts a process of the main application and then closes. The only implementation problem we had was changing all the desktop icons to point to AppVersion.exe instead of the main program.

Pleasure, glad it helped. Just be sure to make sure you set the OpenForm variable to nothing when the form is closed, else this will not work the second time. :-D Happy Coding

You can also subtract dates: If (RetrievedDate.Subtract(Now).TotalHours >= 1) Then End If

Member 4420534 wrote: Im just wondering now what would happen if this month has 31 days and 3 months back has only 30 Either reset your system clock to an appropriate date (not forgetting Feburary only has 28 days or 29 on Leap years). Define a DateTime varable and use the DateSerial function to populate it with your test date, then use the testing dateTime variable instead of the current system date, to test your code. Steve Jowett ------------------------- Real programmers don't comment their code. If it was hard to write, it should be hard to read.

Thanks guys, this helped alot.Thanks a million

Member 4420534 wrote: I have to use VB, its the company's policy.No Javascript This is either an idiotic statement, or you're writing a website, in which case you should have asked in the ASP.NET forum, and in which case, it's always been the case that you can't handle a keypress event, or a keydown, or anything like that. It would, of course, be utterly retarded for a page to do postbacks every time you press a key. Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Done a bit more hunting and there is an example on google that does exactly what you need (I think). Have a look at http://code.google.com/apis/maps/documentation/examples/geocoding-simple.html[^] and view the source.

Yes indeed

You could alsways try www.sqlite.org[^] I don't speak Idiot - please talk slowly and clearly I don't know what all the fuss is about with America getting it's first black president. Zimbabwe's had one for years and he's sh*t. - Percy Drake , Shrewsbury Driven to the arms of Heineken by the wife