Search results

I have not shown the setting of the recordset I do know understand that it needs to be set! I will check that it has been set using If Not RecordsetName is Nothing Then RecordsetName.Close Set RecordsetName = Nothing End if

I often have procedures that contain multiple recordsets. Rather than writing a line of code to close each recordset I want to write a module to do it. In my procedure I may have the following: Dim rst1 as dao.recordset Dim rst2 as dao.recordset When I want to close these I want to run a line...

I have added the reference to Mapi32.ocx through the VBA reference library dialog in the VBA editor, but this does not help. I am also worried about Windows version control! The version of Mapi that I have is from VB6. I am using Windows 7 Let me try something else! How can I send E-mail from...

Please look a tthe attached .jpg file This is a screen shot when, in form design view, I click Insert, Active X control. Please notice the two Microsoft Mapi controls. These two controls are only avialable AFTER I install VB6 on my PC. They are not avialable on a standard Access 2000...

In Access 2000 I have a records that contain the following strings: ### RECEIVING FILE PROCESS TOOK 295 MILLISECOND(S) ### ### RECEIVING FILE PROCESS TOOK 50 MILLISECOND(S) ### ### RECEIVING FILE PROCESS TOOK 600 MILLISECOND(S) ### I want to find the first instance of a record contianing this...

I use the following code to send e-mail using cdo: Public Function SendMail() Dim cdoConfig Dim msgOne On Error GoTo Err_Handler: Set cdoConfig = CreateObject("CDO.Configuration") Set cdoMessage = CreateObject("CDO.Message") Set cdoMessage.Configuration = cdoConfig With cdoConfig.Fields...

Thanks Trevor The problem with "send object" is that you can't add attachments

I am new to CDO and can't find the available options for: cdoSendUsingMethod eg sample code I have found uses cdoSendUsingPort or 2 cdoSMTPAuthenticate. eg sample code I have found uses cdoBasic or 1 Can someone tell me where I can find a list of, and explanation for, these? Many thanks

I currently use Windows 7 and Access 2000. I use mapi to create / send e-mails. I also use Thunderbird as my e-mail client. Mapi works for me, but I understand that I am about to run into problems with persons using Windows 7 and Outlook. What is the alternative method to adopt to create /...

I have a database that includes an itinerary. I need to build a query that returns the first record in the itinerary for each guardian. I have attached a sample database which has two tables tblData = the data tblResult = this is what I want the query to return How do I build such a query?

I have a main form with a sub form Inside the sub form is a tab control When the user clicks a command button on the main form I want the code in the tab controls On change event to run. How do I do this? If I enter: Me.frmStudentCurriculumJunction.Form!TabCtlCurriculumMenu.Enabled = True...

about 10000

No there is not

In Access 2000 I have two tables, table1 & table2 table1 contains the fields: Id, RecordingId, RecordingDate table2 contains the fields: FirstRecordingDate, LastRecordingDate I want to run a totals query that shows me the sum of RecordingId in table1, between FirstRecordingDate &...