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...

The only issue with linking the Inbox (shared, departmental mailbox) to the Access database is that the responses will be archived in a folder unique according to the response date in a "YYYYMM" format. Establishing the link on the head folder does not capture all of the subfolders within...

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...

The textbox was necessary to set the caption of the report, since the caption determined what name the PDF would be saved as. The use of the multi select listbox negates the textbox entry, so the reports will have no unique identifier automatically assigned, unless the code were to read...

ListBox: lstEmployeeNames - not multi select I am not using the OnClick property of the ListBox to set the value of the TextBox, instead, the TextBox's Control Source property is =[lstEmployeeNames]

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 knew I had to use the 'AS' operator, just didn't know how to approach the conditional part though. Thank you much.

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...

The appropriate code is SendKeys ("{BREAK}") - works like a charm. Thank you for your help.

I'm fine with ctrl break, but is there a way execute that keyboard shortcut with a command button?

Thanks for clarifying that 3 seconds is not a substantial amount of time. Now back to the original point of the post - the amount of time and the amount of records the query is pulling are insignificant, they were only added to help explain what I want the functionality of the button to do...

The amount of records and the time it takes to run the query are in no way related to the functionality I am looking to add to the form. What I said there isn't even true - I just thought it would help me find help if I were to explain what I want the "Abort" button to do, i.e. a query takes a...

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...

The wildcard portion with the "*" is exactly what I was looking for, but I do not understand what the proceeding OR portion is doing. Perhaps I should have mentioned that this select query is populating a subform based on the value entered in the textbox, which is querying on a table with...

-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 figured it would be a setting in the PDF Printer properties, but couldn't find anything going through the program itself - however, changing the properties through Device Manager looks to have done the trick. Great stuff, boblarson Thanks

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 =...

The text box name is txtName - both fields and tables do have underscores, not just spaces. Removing the "me." that preceeded txtName seems to have solved the issue. Thanks for your help, Bob. :)

Still getting the #Name? error using your solution, Bob. Scouring the internet looking for a solution, I was seeing instances where it was necessary to use a single quote ( ' ) when performing a DLookUp on a string generated in a Text Box. Is that the case here?