Recent content by leo.clifton

This problem has been recurring for a long time but this morning when we tried to replicate the symptoms for the benefit of our IM&T department it did not occur (typically). I cannot explain what the change is as I haven't adjusted anything other than the two solutions mentioned above which...

Hello I have a VBA program which is stored in an Access database. The program creates letters using Word template documents as well as new Excel sheets. When one of the users in my team undertakes this process she is unable to create the files (although she could before). The following error...

Hi Pr2 Just tried the compact and repair to no avail. I've also tried to add the control in a brand new database with a brand new form (no relation to the old database).

Thanks for that info. I've managed to add the control to the toolbox but now have another problem; every time I try to insert the control into a form (within Visual Basic) it shuts Access 2010 down. I'm getting the standard "Microsoft Access has encountered a problem and needs to close. We are...

Hello I am trying to incorporate an OLEDragDrop procedure into a VBA form which is part of an Access database. When I try to select the OLEDragDrop event from a Listview object I get an error "User-Defined type not defined". When I have entered the following code manually...

Sorry, not up on SQL in VBA

Just remembered that a find first function would work a lot quicker here than running through all the records, not going to write the whole thing out again but: For CurrentRecordA = 1 to TotalRecordsA RecordSetB.FindFirst "[Key] =" & RecordSetA.Fields("Key") Call...

Ah I see. Well this shouldn't be too difficult but it depends on how you are handling the data at the moment. Is there one piece of data in table B which relates to the recipient in A? Here's an example which uses two recordsets and a couple of loops to run through the data, if there are more...

Hello I'm assuming that you are familiar with the code required to send the email itself through an Outlook application. Therefore, the method I would use would be to combine the separate email addresses in a single string and then use this following the 'To', separating each entry with a...

Hello I've recently created a new Access 2010 Database which I'm developing an interface for in VBA. I've created a new Userform in the Visual Studio (this required me to add the Userform button). I'm finding that when I insert the Multipage object which I need to use on the form I can no...