Search results

If a transvestite goes missing, should you put their picture on a carton of Half & Half?

That did the trick. I did have to change ".count" to ".RecordCount", but that worked great. Thanks again. BeckieO

Thanks, boblarson. I'll play around with that. I should be able to get it, now. Again, Thanks for taking the time. BeckieO

PHOOIE!! I accidently left out this line: Set MailList = db.OpenRecordset("MyEmailAddresses3") I've edited the original post to include it. Doesn't this mean I've opened the query as a recordset?

This code runs a query and sends an email based on the records returned in the query, (thanks to a lot of help from the folks here). Public Function SendReminder3() Dim db As DAO.Database Dim MailList As DAO.Recordset Dim MyOutlook As Outlook.Application Dim MyMail As Outlook.MailItem Dim...

Works like a charm. Started out thinking "Why would that work?" After a couple of seconds the lightbulb came on. Thanks so much. BeckieO

This code is part of a module that runs a query and creates an Email based on fields in that query. I want this piece of code to loop through a query and place the results of some fields in the message body and make attachments based on another field. The attachments part works fine, but in...

Got It!! I hope this helps someone else a little bit. OK, finally got something that works. I ended up using bits and pieces from all over, so some of this may be redundant, but the important part is, it works. I made an AutoExec macro to run the code, so when I open the db it: Runs a query...

Thanks, all! I'll work with these suggestions and let you know how it turns out. Wish me luck!! BeckieO

Hi, Y'all, I've tried searching the site for help with this, but I'm still struggling with this email problem. Please take a look and see if you can spot what's wrong. With code provided on here, the module will now run a query and generate an email based on the query results. The TO...

Thanks for your input, Pat. I'm thinking I'm trying to make this thing wayyyyyy too complicated, or at least way above my skill level. (I'm prone to do that.) I think I'll just push button a macro that runs the query, prints the results and opens the email. Then I can manually attach the...

Hi all. I'm working on a db for Preventative Maintenance on equipment, and would like to add a little pizzazz. Other than the obvious tracking of PMs and problems, I would like to send the reminder notices (along with the necessary PM .doc) by using a macro to generate the emails. These PM...

I'm working on a Preventative Maintenance db. I have some formatted word documents that will be used as hard copies of the scheduled PMs. (You know, the kind of thing you hand to a mechanic that says, on MACHINE A, check oil pressure, water leaks, loose screws, etc and record findings here)...

Hi, all. I'm about to inherit a report (basically a weekly performance scorecard) that covers a wide range of data, such as budget, production performance, man-hours, safety, etc. Currently, the data is gathered in from several different places/people, entered into a multi-tabbed spreadsheet and...

Said by Granny, about a lady who was known to have a good time: She's no better than she ought to be.

A few of my favorites "There are two different kinds of people in this world: those who finish what they start, and" ...... Brad Ramsey "Always be wary of any helpful item that weighs less than its operating manual." ...

That's the Ticket Sorry, my timing's off. My second post was a response to Ken's first question. I followed the suggestion of Boblarson and it's working just great. Thanks so much. This is another one I'll keep in my "memory jogger" file. As always, you guys rock. BeckieO

Sorry, should have been clearer. Right now, I've kept the db very simple. Intention is to track loans of books or manuals. 3 tables, Books, Loans, Category Books & Loans =1 to many. Books & Category = Many to 1 In the form in question, Main form displays records from Books table...

Hi all. I have a problem with a form/subform. The main form is used to select the correct record. Only the subform will be used to add data. To keep this form user friendly, I need the main form to open up on a blank record. Then the user will select the correct record from a combo box, move...

That Did IT That did the trick--Thanks a bunch. BeckieO:p