Recent content by Jamesss

:oAfter an hour of google trawling. The problem appears to be with the email client. It appears that lotus notes stores a temporary file of the same name as the report in its temp folder. It would appear that when Access crashed the file was not deleted (assuming that it is done...

I have been using the following code to send a report to lotus notes email client as an embedded html in the body of an email. It has been working well until this morning when Access was forced to shutdown. When I run this piece of script the report is not embedding as an HTML but instead...

After some further digging. I saw that the directory location required a "\" after the colon. That seems to have allow the file to be attached to the email. But there is another problem I have found. In lotus notes the file instead of being embedded, is instead attached at the end of the email...

Searched the forum and found a useful thread: http://www.access-programmers.co.uk/forums/showthread.php?t=131103&highlight=email+lotus+notes The code provided allows emails to be automatically send via Lotus Notes. However I am having an issue with embedding the HTML format report before it is...

Hello, Have created a form with an imbedded listbox query containing a list of records. In the same form are a set of bound textboxes linked to the data table containing the records. The selected record in the listbox will subsequently be updated in the bound textboxes. Problem: I deleted...

Below is a simple for loop I am running on an open excel worksheet. I get "Compile Error: Next without For" at the line highlighted. Can figure out where the syntax has gone awry :confused:. My IF statements appear to be closed. Advice? For c = 17 To iCol rs.AddNew If...

Thanks Leigh. The problem appears to be fixed :) I'll continue to try and break it to see how it goes.

Checked. That has already been done, and have checked that all variables are dimensioned.

I've been trying to debug a piece of VBA code which opens an Excel file from Access and selects certain data to record into an table. I have been receiving an intermittent "Object Variable or With Block Variable not set" Error for quite some time now. It was difficult to find where the error...

Sorry for not updating you earlier. Thanks Evan your solution works great! I also used the wildcard on the left hand side in my search too. It provides for a more robust search tool!

I tried that previously and it while it does include Null entries in the unfiltered query it also inlcludes them even when I enter a search within another field. It the same when I enter "Is Null" in the Or Field below the Criteria box it will include Null entries in the default search...

I have generated a search form that calls a query to filter only values in a field that are similar (LIKE) to the field entered into a textbox/combobox. In the criteria for any given field I have used: Like [Forms]![FormName].[TextboxName] & "*" The default value of the Textbox is "". But...

You guys are right... I had a closer look at the field headings and indeed "Task Code" NOT "TaskCode". Incredible how stoopid I can be. Thanks Paul and Bob!

The error is isolated to the line: rs("TaskCode") = cTaskCode The error reads: "Run Time Error '3265': Item not found in collection."

Function LoadExcelSpreadsheet(xlfilename) Set oExcel = CreateObject("Excel.Application") Set oBook = oExcel.Workbooks.Open(xlfilename) Set oSheet = oBook.Worksheets(1) Dim rs As DAO.Recordset Set rs = CurrentDb.OpenRecordset("EOTaskDefInitStatus") iRow =...