Search results

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...

Not exactly sure what is replication, but when I looked it up it was confusing to me so I guess we have never used it. Thank you. The question remains is if I continue to operate in Access 2010 but some people have Access 2019 on their workstations, can they open the DB? Or should I get a...

Apparently the outside tech convinced them to installed Office 2019 for Word, Excel, PowerPoint using the subscription based service. So I don't know if there were any problems installing Office 2010 on the new computer.

At our office we have 5 desktops running Windows 7 that are getting old and need to be replaced. One is used as the remote link from which I can connect to the server at work from home. The new ones will have Windows 10. The first one to be replaced had a problem installing Access 2010. Not...