Search results

I meant that once the message appear in Outlook, I was happy. Sorry for the misunderstanding. Yes, the thread and the 70 plus posts are sometimes hard to follow. Not sure what I should do next. I have been thinking about getting a spare machine and testing out my old DB on Office 2019 with...

I meant to add, what version of Access did you test it on and what version of Outlook? It works fine for me as I am on Windows 10 but have Access 2010 and Outlook 2010. The other workstation has Windows 10, Access 2010 and the newest version of Office 365.

Sending the message has nothing to do with it. As long as it appears as an outgoing message on Outlook, it works. I am using Access 2010. So if it works for others, what should I look for on the miscreant machine? Is it possible that the machine is the problem and not my code? I cannot...

I decided to make a sample DB with my mail app which was the primary cause of the failure. Dim olApp As Object Dim mItem As Object Set olApp = CreateObject("Outlook.Application") Set mItem = olApp.CreateItem(0) If Me.AttachFile = "" Or IsNull(Me.AttachFile) Then With mItem...

The users at work are going to install Office 365 instead of the stand alone versions of Office. So if I can get Access 2019 to work or get my old Access 2010, do you meant that with the next update of Office 365 the problem might occur again? If I understand it correctly, the problem occurs...

I was going through the errors and whenever one occurred, changed them to the one above. I now realize that I should have been checking each and every one to see if it worked before proceeding with the next. I regret to say that my old DB has so many of these errors that I am disheartened...

Will leave it unchecked as you said. I now have the following which does not throw any error when compiling. Want to make sure I have this correct. Dim db As Object Set db = CreateObject("Access.Application") Dim rs As Object Set rs = CreateObject("ADODB.recordset") Not sure about either...

Will start work on this tomorrow. After I correct the all, do I check that reference on again?

I figured out how to do it. Hold down the shit key and then open the DB. Unchedkced the reference and the first one that came up was: UpdateBackup: Dim db As Database Dim rs As Recordset Dim BUB As String Dim DBU As Date Dim BUD As Boolean this is some code that sets up an automatic backup...

Cannot uncheck it. Says it is in use.

The attached is the screen shot of my references:

yes that is correct. .value works.

Opened DB, got the LogIn Form, used ALT then F11, took about a minute for the VBA window to appear. Typed in olNoteItem, hit return and got 5. This is on my home machine. Windows 10. Have not yet had confirmation of the DB opening yet on the Windows 10 machine at work. The following...

Opened DB, got the LogIn Form, used ALT then F11, took about a minute for the VBA window to appear. Typed in olNoteItem, hit return and got 5. This is on my home machine. Windows 10. Have not yet had confirmation of the DB opening yet on the Windows 10 machine at work.

Found this: https://sourcedaddy.com/ms-access/understanding-module-load-demand.html So, the code module code does not load automatically, only "On Demand". And I had it checked as per the article: "Fortunately for all Access developers, this complete loading of a potential call tree has...

That being the case, then why did the error code that appeared in my first post occur. It was not called on the first form that opened. It occurred when the database opened and the log in screen appeared. Just trying to figure out why the error was called if the code was not called. The three...

I was updating more of my code to late binding and realized that the actual culprit may be in the modules section. Did find one or two modules there fortunately that I do not use any more that had early binding and are now deleted. Am I correct the the modules code load when the database is open...

I'll try this tomorrow when I have more than a few minutes to work on this. Appreciate your input

OK, my virtual memory says Automatic manage right now. Says it has 5120 MB of virtual memory. So I should uncheck it and go to custom and now I have to add an Initial and Maximum sizes. And suggestions? I have never even gotten into my system this far before.

Thanks to everyone. Mike375, yes I already put the Control Panel Icon on the task bar. Learned that a long time ago. I am going to try some of the simpler "fixes" firs, but am loath to do a complete reset. Way beyond my level of expertise.