Search results

Thanks, once again, for your help. I managed to trip over the boulder - it turned out to be a visit type that would normally result in skipping over that record to the next record but, in this case, it was the last record in the recordset. This would not usually occur, but the visit type had...

Thank you all for your help. I tried substituting 'On Error Resume Next' for the usual error code and the subroutine paused at the same point with the error message 'Automation error'. It then continued to format the Word file and print it to the screen, but with an additional formatted letter...

I have a routine that I use frequently to loop through visits on a particular date, building up a Word file of letters for each visit, in alphabetical order for each person visited and, finally, formatting that file and printing it to the screen. However, one one particular day, the routine...

Thanks. I hadn't realised that the 32-bit version of Office 365 would be OK in W11, but this has completely solved my problem and my application appears to be running normally. Thanks very much to everyone for your help.

Thanks very much for the help. I have managed to download and register 3 of the 5 .ocx files that I need. However, I have not managed to register ISCTRLS.ocx, although I have found and downloaded the 32-bit version and it is still a missing reference. I can't find a 64-bit version. I am also...

Thanks. How do I do that and do you know where I can get copies of the 64-bit compatible files?

I have an MS Access application that I use every day in my work and that I have been transferring from laptop to laptop for many years, with slight tweaks. Usually, the main issue is installing the various .ocx and .dll files in the sys or sys32 directories. My W10 laptop, on which it is...

Thank you. That's very helpful. I'll work through the suggestions and repost if I don't manage to fix the problem.

I have a W10 laptop on which I run my Access-based application, but it is several years old and running very slowly and I have acquired a new laptop running W11. In the past, on transferring the application to a new PC, I have simply transferred the appropriate .dll and .ocx files into the...

Compiles without problems and I'll check on commenting out code containing those functions. The references look the same as on the original laptop - there were several missing refs until I transferred the files.

No, just W10 Home

Thanks for your reply. Both laptops are using Office 365 and visual basic is Access 2013 or earlier. I've refreshed all the links.

I have just transferred an MS Access application consisting of a front end and back end to a new laptop. The directory structure is very similar and I have transferred all (as far as I can see) the necessary Active X files to restore 'MISSING' references. I don't know if it's necessary, but I've...

I am hoping to update an Access 2000 application to Access 2010 and, initially, I'm trying to run it on a PC with Access 2003. I have rectified several missing links to .ocx files, but the application contains a link to the smartcontrols.ocx, which I no longer have. Surprisingly, googling it...