Recent content by Schroeder

Just keep in mind this method does not copy other attributes of your source table - no indexes (including Primary Key) or foreign key constraints (if you're into that kinda thing), etc.

No time to post an example right now but, I believe you can use the PostMessage API, passing WM_CLOSE (&H10) for the wMsg parameter. Use EnumWindows along with a callback function that uses GetWindowTextLength and GetWindowText to identify and acquire a handle for the appropriate window. There...

I'm retrieving a string using the MSHTML.IHTMLTxtRange.getBookmark function. This returns an "opaque string" representing the IHTMLTxtRange of a WebBrowser.Document object. I'd like to store this string to use at a later date to return to the same range. The problem is, when I move the value...

Thanks for your help folks. This was just something I never understood about my router and I didn't like having that hole in my knowledge. My logs, going back a year and a half show zero scans for either ports 500 or 1723.

IPSec. Not sure I've heard of PPTP.

I'd think you'd have to fire up that secont WAN port on your 200 and connect it with the second IP. Otherwise, maybe you could work a deal with your ISP to forward port 21 traffic on the second IP to some other port on the first IP. You could then set your 200 to forward that port's traffic to...

Well, the router itself is the VPN server. I presume that even with the router acting as the VPN server, it has to leave some port open somewhere. The vast majority (by a large margin) of the scans that hit us are for 135. Although most of the others are on well known ports, we do receive more...

I think it relates to this: faq463-2520

We don't run any services from our location and hence have set our gateway router to ignore all incoming connection requests. We do use a VPN though. Is our router listening on some port for VPN connections? If a scanner hit the right port, would it receive an answer from our router?

You can use the Mid and InStr functions to accomplish this.

This seems to work for me blnInRange = CDate(txtUserInput) >= "5:30 AM" And CDate(txtUserInput) <= "2:30 PM"

Also workable methods if you just want to make sure it's a whole number - the dictionary definition of an integer. GerardMcL seems to want to make sure the number is of the Visual Basic data type Integer which does not include all possible whole numbers.

Good advice. The biggest concern that DoEvents causes me is that you must manually control user interaction when you use it. Basically any other actionable control has to be manually disabled because their events will fire if a user happens to click on them while your loop is running. If you're...

Maybe it's a matter of semantics but the Err.Clear has never worked as I hoped it would. I think you need to try errorhandler: skip (increment file name) to the next file () Resume start

As far as the improperly drawn forms or controls go, try throwing in a few DoEvents or Refresh statements. Give it a Refresh just after you've made a change to something but right before you call a processor-intensive operation. If you're looping, a DoEvents inside the loop is a nice way of...