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...
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 = "<a*>"
txtData.Text = objReg.Replace(txtData.Text, "")
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
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 now own, I'm gonna have somebody to write down every thing that is said at all times! -lol
"I'm not Barky the Dog, kid. I'm just a man whose made a lot of mistakes."
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.