Search results

  1. RossWindows

    Mail Merge - Dynamic subject line?

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

    Mail Merge - Dynamic subject line?

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

    Mail Merge - Dynamic subject line?

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

    Mail Merge - Dynamic subject line?

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

    Site a pain today

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

    Scan All Desktop Folders Of Network Computers

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

    MS SQL - UPS Tracking Number Validation Function

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

    Lottery number-tracking table structure

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

    MS SQL - UPS Tracking Number Validation Function

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

    MS SQL - UPS Tracking Number Validation Function

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

    MS SQL - UPS Tracking Number Validation Function

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

    MS SQL - UPS Tracking Number Validation Function

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

    Set Report Recordsource to ADODB Query

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

    Set Report Recordsource to ADODB Query

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

    Set Report Recordsource to ADODB Query

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

    Set Report Recordsource to ADODB Query

    I was originally trying to use a stored procedure that resides on our SQL Server. How would you go about using the sp identified in my original post? ("dbo.spCoachingPrintOut...")
  17. RossWindows

    Set Report Recordsource to ADODB Query

    Essentially, that's what I'm trying to do. I have a form that lists records with two or three fields. I have a Print All button on that form's footer. What I want to happen is when the button is clicked, it loops through each record and puts it on a report along with 10 other fields and prints...
  18. RossWindows

    Set Report Recordsource to ADODB Query

    I have the following code on a report. When the report opens, I would like to set the recordsource to that of the ADODB query, however I am encountering the error: "This feature is not available in an MDB." I understand why the error is appearing, but I also know there has to be a way around it...
  19. RossWindows

    Can't enter data into form -Access linked to SQL

    Hi Jeasdale and welcome to the forum! Thank you very much for taking the time to write about the issue you are experiencing. I'm positive we can shed some light on the subject and get your application running as intended. It sounds as though your particular situation is much different than the...
  20. RossWindows

    Energy, now and in the future.

    I'll be the devil's advocate for a moment, for the sake of healthy debate: You may be treading close to a logical fallacy; assuming that an increase in carbon emissions is a bad thing and/or causing some sort of consequence. :p
Top Bottom