Recent content by kwor

kjv1611. Thanks, I have been down that road. Even Microsoft can't get it right between Outlook and Outlook Express. I have tried all that and it doesn't work. I am thinking that perhaps an Access update has broken it but.. thefarg. The OutpuTo command is used to save a pdf copy to disk and had...

Sorry, you didn't list the thread....

That is the full message. to be specific: "<Database Name> can't send this email message" Not very helpfull. I have played around with the code and debugging trying to trap errors. I suspect that it may be runtime Error 2293 I have substituted CDO code as a workaround. This works but I have to...

I am running Windows 7 (64bit) and Office 2010 I have a database that creates a pdf document on disk and a button that calls my email program, attaches the docuemnt and leaves the new email open for edit. The code is: stEmail = Me.Parent!Email stFileName = "D:\documents\abc_" &...

I used the Application.FollowHyperlink method on various file types, including pdf, and have not had a problem with warnings. Thanks for the comment anyway.

Thanks for the replies everyone. PHV, exactly what I was looking for. Opening the folder/file dialogue was the easy part - launching the associated application of the selected file had me stumped.

I have a form that performs a function. There are times when users need to select and open other documents relating to the database. At the moment they must go to explorer, navigate to the directory and double click the appropriate file. The file could be a Word, Excel or other document. To make...

I have a parameter query to generate a report. Up to four parameters may be passed from the form to the query. Click a button on a form and the report works perfectly. I also have another button to email the report via Outlook. This works perfectly as an attachment, however, I need to place the...

Thanks everyone, the DLookup worked. I shall remember not to use DoCmd.RunSQL in this situation again.

I have two tables - tblAssets and tblAssetNo tblAssets is the main db table tblAssetNo has only one record that keeps track of the latest asset number. I have a form to add a new asset with a bound control called AssetNo. I am trying to use the following code to get the next asset number from...

Thanks for the replies. I had actually worked it out by a different method but PHV's method is far more elegant than mine. Thanks. My method was to calculate the start of week and end of week in unbound controls on the form that called the query SOW = Date - Weekday(Date) + 1 EOW = Date -...

I have a table with records that include a startdate and enddate field. The stardate and enddate for a record could be the same or differ by days, weeks or months. I have a query that will retrieve all records where the current day is on or between the startdate and enddate i.e...

I changed the select query as per your recommendations. No change. The "Report wizard" still has no data fields but they are available via "Report Design". My original report still returns the same error. "Like" or "=" makes no difference. "add all possible values of Area into the Column...

The form stays open. There is no code in the report. "Null value in the column heading" Hmmm.. I will check that for the original report because some "fixed" data may have changed. However, I would still like to understand why the report wizard would not display any data fields when trying to...

I have a couple of related tables. I have a form based on those tables that provides parameter input to a select query. I have a crosstab query based on the select query. This all works. I can select the required parameter on the form and view the results in the crosstab query. I used to have a...