Recent content by RossWindows

If you have access to an SMTP server (gmail even), then you can use the CDONTS library. There are plenty of examples floating around. Check the code repository. In this case, your email code would probably go right after the 'Loop' tag, before the 'End With'. If sending large batches through...

Hi tnm, sorry, I've edited my last post. I may have edited it while you were posting your last response... just posting this to prompt any automated notifications for you.

Hmm, interesting problem tnm. First I want to clarify; what version of Word are you using now? (your initial post is a little ambiguous). Secondly (after thinking about it for a minute), it looks a lot like a missing library reference, but honestly it's been a while. Before you get too far...

In Word, the "<<subject>>" data field is added directly on your word document, not in the code. It's been a long time since I used merge but if you still need help, just let us know.

Still loading slowly for me. When I first logged in, I was taken to the "Successfully logged in (click here if your browser does not automatically redirect you)" landing page. It sat there for a minute before a 3rd party survey popup appeared. When I clicked the X on it, it took me to the survey...

Hello, Does anyone know of the existence of a script that does the following? Google is not my friend today and I don't have time to reinvent the wheel, unfortunately. A script that traverses the entire local network, logging the names of all files present on each user's desktop folder in each...

Well, I hope nobody used the code that I posted yesterday as it does not give valid results 100% of the time. My initial sample size was obviously not large enough so I didn't catch it at first. After more research, I found the following articles which helped me to correct my formulas. Please...

I'm a little late to the party but I would definitely agree with bob here. Since the order of the balls drawn during a draw is not important, there's no need to separate a set of balls into their respective columns. Unless you wanted to store other information about each drawing you could even...

So after some fiddling around, I've managed to create something that works within a stored procedure. I've tested approximately 15 valid tracking numbers with a 100% success rate. I've also tampered with the numbers before running them through and the stored procedure always returns the proper...

Thanks mdlueck, I'll have to consider how to convert those IF statements to CASE statements. Also, I notice that the sample code is using the mod function to test whether a value is odd or even, and again to calculate the final check digit comparitor. Upon checking the list of functions on SQL...

Yeah, it's pretty easy to get it working in VB or pretty much any language... but I'm trying to incorporate this on my SQL Server as a user-defined function and refer to it through a CHECK CONSTRAINT statement on a field that will be accepting these tracking numbers. I'm mostly just curious to...

I found this function online at gist.github.com/1371323 It was written for PL/SQL. I'm wondering if it can be adapted to work in MS SQL. I've tried a bunch of stuff, but I just can't get the validator to 'like' it. Any ideas? function ups1z(p_tracking_number varchar2) return boolean is trk...

That's exactly what I did, except I used a querydef instead of a tabledef. Here's the code on my subform. The subform is populated based on date range and other criteria entered by the user on the parent form. It's probably not perfect, but it's the closest thing I've got. Option Compare...

Exactly; I figured a report would have a recordset property too, but came to find out that isn't true. Well, I ended up getting it to work by creating a passthrough querydef object on the fly like vbaInet suggested. The report's recordsource property was set to the same name as the querydef...

That may be true with newer versions of Access but with '03, there is no recordset property on reports.