Recent content by Cleis

pwise (Programmer)and bubba100 (TechnicalUser) Thanks for your input and help! Two stars!!

Hi Bubba100 The code will go through the 1st time and send the e-mail. However on the loop I only get to .To = rs!Email Should I be declaring the fields of the query??? I've tried that as well to no avail? Thanks for any input

Can someone please tell me what I'm doing wrong? I'm getting "Object Variable or With Block Variable not set" Thanks!! Dim db As Database Dim rs As DAO.Recordset Dim objOutlook As Outlook.Application Dim objEmail As Outlook.MailItem Set db = CurrentDb Set rs =...

Thanks dhookom and skipvought! I got my answer from RuralGuy although I would up creating a modual. http://www.tek-tips.com/viewthread.cfm?qid=1414049&page=1

Hello group! I have created a query that allows me to calculate how long it takes for me receive payments from my suppliers (via a crosstab query). Now I want to use the following w/o hardcoding the 7/31/2007. How do I make the year a variable without using the DateSerial() function? Take a...

Thanks Remou!!!

Actually what I was referring to was the pop-up dialog box that tells me when I’ve got a new e-mail. In Outlook 2003, the parameters are located under Tools/Options/Advanced e-mail options/desktop alert settings. From here I can set the duration (time) of the message as well as transparency of...

Does anyone know if this can be done? Just one of those little light-bulbs going off over here? Thanks!

Thanks! Sometime I get too close to the trees to see the forest. Here is a star!!

Okay: Lets say that I have a contact record stored in a table called "tblContact" and the field names are as follows: Last Name First Name Title Categories This record can have multiple categories assigned to it such as: Cat1 Cat2 Cat3 Cat4 My question is, what is the best way to store this...

Zor! Thanks for taking the time to answer my question!! What a work around!! Although. . . . you have to admit, ya' should'nt hafta'! Here is a star!

Okay folks now I'm confused! I have put the following "Me.cmdResetFilters.Enabled = False" on the "On-Click" event for individual page as well as the tabCtl itself. In both cases, it did not work? I even highlighted the code to see the value when the code steps through. You guessed it, the...

Thanks Zor! Where do I put it? You cannot put this on the On-Click event of the page within the tab control. Further, I've not been able to figure out what the correct sytax should be on the Tab Control property sheet. I'm assuming that I need to use an if then to determine which page within...

Group: How would I disable a command button based on what page I'm on within a tab control? I have a series of cmd buttons across the bottom of the form (below the tab control). Which event would I use on the Tab Control? Thanks!

Group: I have an A/R database that has a front end (5) users and one back end on a local server. I have created MDE's and placed one on each users machine. I have disabled the f11 key and prevented my users from gaining access to the Access container on their desktops. One additional point...