Recent content by ferociousllama

I'm having a problem with my database. I have an "invoice" table and a "vendor" table. The vendor table has two fields, a vendor number and vendor name. The invoice table looks up the vendor number but displays the vendor name. I created a query to show me all outstanding invoices. The query...

There is nothing there that would filter to the email address. I wasn't understanding for sure what you were saying about filtering but after a short break I figured it out. It works perfect now. I just need to put in some code to open the form before the loop starts then close it when it's...

So I need to create a form that will have a text box populated by the address the code is currently on? I'm sorry if I'm just not getting it. I ended up using some other code I already had in my database that I used to send emails. Here's what I ended up using: Sub WeeklyReport() Dim MyDB...

That helped a lot. Thank you! I almost have it. The only thing I'm having trouble with is getting the filter to work properly. I can filter the report with the On Open event but I don't know how to reference the address that the loop is currently on. Any guidance on this?

You all have been great on my previous question and i appreciate the help! I'm working on creating code to run a query to get a list of mail addresses. Then loop through the mail addresses sending a report to each one. I got that to work but I want to use this with a report with parameters. The...

Works good. Thanks!

That code worked great in my test database. Unfortunately the name for the "Sentdate" field is actually "Sent date". It has a space and the space causes an error. how do I reference a field name with a space in it below. The situation is the Sentdate field is actually Sent date with a space...

I will use that! You're a life saver!

That worked like a charm. Thanks! There is a query that combines the email addresses with pretty much all the other information. The status field is included in the query. Set qdf = MyDb.QueryDefs("Table1 Query")"Table1 Query" is the name of the query where the recordset is coming from. The...

Hi Everyone. I have been a lurker on this forum for a very long time and I've gotten much great advice and information. I'm happy there are communities like this one! I'm not that new to Access but my skill level is certainly novice. I have been using it for a couple years for mostly simple...