Recent content by Rjc8513

Sending e-mails Okay, I incorporated Russell's code into an Access function and have not been able to get it to work. Will it not run and can I not test it like all other Access functions in modules (F8 to step thru the code)? When I try, the step into/thru process will not start. What am I...

I'm confused by your post. Are you trying to use cc:Mail to send the message or Outlook? If you are using cc:Mail, use the DDE commands.

Main table: [DataTable] Table of files: [FileTable] I want to use Left([FileTable].[FileName],6) as the criteria in a query of [DataTable].[IDNo] and print the report [rpt FILE NAME] for the desired [IDNo]. Can this be done using code, i.e., QueryDefs? Thanks.

I am using a combo box on my main form so that the user can select a unit. The AfterUpdate property of the combo box creates a recordset clone and the results are displayed in a subform on the main form. This part works great. I would then like to have the user select a StartDate and an...

I'm stumped! I have a form named [frm ARCHIVE] that has the query [qry ARCHIVE] as it's record source. On the form I have a combo box [cbx UNIT] which uses Recordset.Clone to display the selected unit's data in a subform [frm ARCHIVE SUB] on the main form. The subform also has the query [qry...

I am brand new to subforms and just cannot seem to grasp the concept. Here's what I'm trying to do. I have a table of reports with an AutoNumber field named ID the fileds are [ID] and [REPORT NAME]. I have another table of e-mail addresses with a single field name [RECIPIENT]. I want to...