Search results

I have been experiencing three different slowness problems with my Access 2010 database since I upgraded to a Windows 10 operating system. Yes, it has a lot of forms, queries, sub forms, etc., but when I ran it on Windows 7 it was always fast. At least fast enough for me. The DB is split and...

Couldn't resist. It works. At least on my home computer running Windows 10

I'm all Accessed out right now but will try it tomorrow.

The following post gave me the hint to use the CStr() function. https://access-programmers.co.uk/forums/showthread.php?t=290214. It was on this forum!

DBGuy: Thanks. I tried it but it threw the same error as mine. So I changed it to: With olMail .To = CStr(Me.txtTo) .Subject = CStr(Me.txtSubj) .HTMLBody = CStr(Me.txtBody) .Display End WithAnd it works. Perhaps there is just something wrong with my Access Program.

Thank you for the last two replies. The question remains that this problem of needing the CStr function did not occur until I chose to use Late Binding. Does that have anything to do with it? No other part of the code was changed. As I said before, I have to wait until Monday to test it...

And I amended the other code to include the CStr function and now all is OK. The big test will be on Monday to see if it functions correctly on the miscreant new machine. Hopefully it will and I can go back to my golf game. I don't want to jinx this by thanking everyone just yet, but the...

OK, after much research – my favorite thing to do on a Saturday afternoon – I found the following "fix". It was to add CStr([item]) to the code as follows and now it seems to work OK on my home machine (not yet tested on the machine causing the problem in the first place). Dim olApp As...

The first code in Post #20 runs with no error but it does not seem to transfer the appointment to my Outlook. I check my old code on the non-Test Db and it works fine. The second two codes throw the following error message: Run Time Error 1-2147417851 (80010105) Method of To of object' _...

The code in #16 above is my old code. Yet when I search for Late Biding it seems the same to me. Am I wrong? Very confused at this point.

OK, this is what I have now on the DB in various locations. How do I convert this to late binding? I've done some research and all it has done is left me confused. Dim outobj As Outlook.Application Dim outappt As Outlook.AppointmentItem 'An Outlook Appointment Item Set outobj...

DB Guy: That was what I was planning to do this weekend.

Before I delve into this morass of changing all my code to late binding, I would like to know if the problem is because there are two versions of Outlook on the miscreant computer. Office 365 and Outlook 2010. If I remove either the Outlook 2010 or the Office 365 version would this solve the...

ok! thanks

I have the References open but so not see any reference to "missing" items. Just checked and unchecked items.

Does this mean that I have to go through all the code and change any reference from early binding to late binding? I would hope that there is some code to insert at the beginning of the DB startup. Oh my, what a mess I seem to have gotten into. Why does MS do this to us simple minded users?

I am sorry but you have lost me. I do not know what you mean by removing the reference. The error message says the reference is missing. I regularly debug the code. Is this what you mean by compile. I do not get any errors.

Using Access 2010 on a new Windows 10 computer. Previously I had no problems updating and distributing a full version (not Runtime) to the all six users of the DB. All had Windows 7. One has a new computer with Windows 10 I assume the latest version. At first our outside tech consultant...

I'm using 2010, so they are in accdb format.

OK, one more question. If I already have Access 2010 (as part of the Office 2010 Suite) installed on my computer, can I install Access 2019 on the same machine? I have researched this but all the answers are very confusing. What I want to do is as per my previous post. Test the current DBs...