Recent content by nexcar

I'm writing an app in vb6 that uses an Access 2000 db to store info. When running a stored procedure and trying to put the results into an ADO recordset, the EOF flag is always TRUE. I had similiar problems on some SQL projects until I found the wonderful command SET NOCOUNT ON. I use it in...

I work in the eastern and central time zones. I use Outlook calendar in my personal folders on my laptop. Whenever I change timezones, all of my scheduled "all day events" on my calendar change to timed events and shift up one hour. This makes events on my calendar move from day to...

It does work, albeit lengthy, but you get a star for your effort. Thanks! RUN FunnySignatureMessage

YES!!!! EUREKA!! And whatever else you say when experiencing an apiphany. For anyone else who wants to know the solution, here it is: Dim objReg As New RegExp objReg.Pattern = &quot;<a*>&quot; txtData.Text = objReg.Replace(txtData.Text, &quot;&quot;) You must include the...

I have raw html code for a news story. I've used the Replace(MyString, ReplaceWhat, ReplaceWith) as String function to replace all the <p> and </p> tags, but I'm having trouble with the <a href=URL> tags. See, the problem is that the 'a' tags vary in length and content so unless there is...

I am so, so sorry guys. I meant to post this in the VB6 forum.. My mistake. I can't figure out how to delete posts to Tek-Tips. But if you do know the answer to my question, please post it, I'll be monitoring this post. Sorry again. RUN FunnySignatureMessage

I've created a program with an address text box, and Inet control, and an output text box. When I enter an URL into the address textbox, the (multi-line=TRUE) output text box fills with the raw HTML code. I would like to analyze this raw code line-by-line. The only thing I don't know how to...

And if anyone wants to know what Tarwn's signature means, it says 'Got Coffee?' in Binary. Sorry, Tarwn, the geek in me couldn't resist converting it to ascii. RUN FunnySignatureMessage

Its kinda like finding a chick that likes football or stockcars. They are one in a million! RUN FunnySignatureMessage

You can. Here is a SQL code example: SELECT * FROM [yourTable] WHERE weekday([dateField] = 3 RUN FunnySignatureMessage

There is a function that you can use to enter a date and it will return the day of the week example: Dim MyDate, MyWeekDay MyDate = #February 12, 1969# ' Assign a date. MyWeekDay = Weekday(MyDate) ' MyWeekDay contains 4 because ' MyDate represents a Wednesday. Here is the syntax...

If you are in Access, just use an Input Mask. Input masks allow you to pre-determine what is a valid text box entry without using any run-time code. Refer to the MS Help document. It has all you need for creating input mask and even how to change the mask during run-time if needed. RUN...

From what I've read, the benefits seem pretty good, but I don't think they are work 7k a year! RUN FunnySignatureMessage

From now own, I'm gonna have somebody to write down every thing that is said at all times! -lol &quot;I'm not Barky the Dog, kid. I'm just a man whose made a lot of mistakes.&quot;

See there, this is why I'm mentally challenged. He told me over the phone, the only salary in writing was what they paid me while contract working. I'm currently scouring my email logs for any mention in an email message. This was my first job change in 5 1/2 years! I didn't go through one...