Search results for query: *

VBslammer, Thanks for this. I am able to run the code without error, except, where do I control the email addresses?. When I step through the code and I get to the following section: .To = strRecips and I slide the cursor over this section, the text tip displays the the attached document...

Thanks VBSlammer, The program gets hung up on "Dim ol As Outlook.Application" I get an "Compile error User-defined type not defined" Thanks

VBslammer; My code is shown lower down. I am able to, using a form and checkbox, determine if a certain ttemplate should be sent to a distribution list. My problem is that although I can create an email with my template attached, I still have to manually list the the e-mail addresses. I guess...

I am completing a Word template from a form in Access. I am able to fill and save the new document. I want to be able to send the just completed document via Outlook to a predetermined list of e-mail addresses. I am able to open outlook and attach the document using the...

Ken Thanks for the input, I have found my solution. I am creating a tabledef with all the textbox.controlsource (see below) strSQL = "Create table " & tbltemp & " ( TAG_NO TEXT " For Each ctl In rpt.Detail.Controls If ctl.ControlType = acTextBox Then...

KenReay, Thanks for the input, this is giving me exactly what I was looking for. However, I thought I would be able to transpose the table, like with excel. Do you know how to take the records produced by this and turn them into field headings. Thanks

I want to gather a listing of all the controls on a specific report on the detail section. Is it possible to do, as well as gathering the data source properties of these controls. The end product is to create a table comprised of these control data sources.

I have a table with a field of descriptions that are quite long. These descriptions need to be replaced with an abbreviated value. For example: a description may contain "Socketweld". This would be replaced with "Sw". I need to create a new table that will contain the...

I have one report layout that I want use to produce two reports (documents). Each report will require a different SQL statement. I know how to setup a checkbox on a form to tell which statement to run. What is the syntax to represent the select query. As a secondary step I need to be able to...

I want to use a checkbox to display a list box on a form, I am able to set the default value of the checkbox to false upon loading the form, once I click on the checkbox, the list box becomes visible As I turn on or off the checkbox, I want my list box to appear or disappear. Thanks Ken

The document is in Word. I would prefer to use Word VBA to do the work.

I have a document that is produced as a result of an output from access. there are a series "text form field" in the document that receive the info from access. What I want to do is go to a text box and extract the value into a variable, then remove the text box and paste the variable...

mp9 thank you for the insight, I am back on track with my report. A little clarification goes a long distance. Thanks again Ken

I am building a report in access that will require a front page. This report will carry a document number and will be revised many times. I believe this is a good application for main and Sub reports. The main report will contain the front page and the detail of the data, the sub report will...