Search results for query: *

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

...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 Microsoft VBScript Regular Expressions reference in...

...with the <a href=URL> tags. See, the problem is that the 'a' tags vary in length and content so unless there is some way to use wildcards (like * and ?) in the replace function and just say: Replace(MyString, &quot;<*>&quot;, &quot;&quot;) To remove all html tags in the text. Here's an...

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

I hate to bring up something like this on this forum but I feel that you guys are my peers in the field. I've recently been screwed by my recuiter. I've been working under contract (read: no benefits) for 2 months now for a recruiting company. I've been doing work for a major company in the...

benlinkknilneb: I wish I could go that route, but my programs control production testing in an industrial, electronic manufacturing environment and, by some strange fate, could possibly injure someone. RUN FunnySignatureMessage

sleipnir214: Wow! Now that's an original thought on this subject. I like that. RUN FunnySignatureMessage

CCLint: That was the answer to my question. I've never seend that toolbar before. Just never toyed around with the IDE enough to know. Thanks! But I do suggest that VB programmers check out the mztools! RUN FunnySignatureMessage

Quick steps to test function: 1 Create a new form - (Make sure you have the module I supplied as part of the project) 2 Add a command button and 2 text boxes DO NOT RENAME THEM OR COPY ONE FROM ANOTHER. 3 Copy this code and paste it into your form. Private Sub Command1_Click() text2.text =...