Search results

In a form, I have a button that creates a number of email drafts for multiple recipients, attaching a file unique to each of them. The reason I have Access (2003) draft the email rather than send it is because a few individuals will need content added to their email message. After clicking...

In an Access form, I have a command button that shoots out an email to a list of people with the voting option "Yes;No". When the user casts their vote, their response comes into my inbox, and I manually record their response in the database. Is there a way to have those email response...

I would like to design a loop of some sort to iterate through a listbox, print a report as a PDF, and save with a unique name. Currently, I am clicking a name in a listbox and then clicking a button to run the code below. The listbox selection passes the value to the textbox...

I have a single column listbox (lstEmployees) populated with names in a "Last, First" format. I would like to have a command button loop through this list and save an email for each name in the listbox with a unique PDF attached to each. I need each name to be selected individually and then the...

I have a query that displays sales totals by market: Market (Group by), Sales (Sum), Goal (Sum) How can I modify the query to display the results in a manner that groups the markets? For example, if the query returns results for six markets, and three of them are NY, NJ, and PA; how can I...

On a form, I have a subform that requeries a table based on the criteria entered in by the user. The table this query is running through is quite large, and in some instances, could return thousands of records. Rather than having the user sit there for 2 hrs and wait, is there a way to stop...

-Using MS Access 2003- I have a command button set up to execute a select query. The select query performs the search based on the criteria entered in a text box. Here is how it looks in query design view: Field: AccountNumber Table: CustomerTable Criteria...

I have the following code to save a report as a PDF from my Access form: Private Sub btnPrint_PDF_Click() Dim strDefaultPrinter As String Dim stDocName As String strDefaultPrinter = Application.Printer.DeviceName stDocName = "Sales_Incentive_Report" Set Application.Printer =...

-Operating in MS Access 2003- On a Form, I have a Text Box (txtName) that is populated with a name selected from an unbound List Box. I would like a separate Text Box (txtReport) to perform a DLookUp to return a value from a table based on the string displayed in txtName. DLookUp(Field...