Recent content by malxvc

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