Recent content by JMan_1018

My Microsoft Excel 16.0 Object Library was unchecked. I checked it and it is working. Any ideas how it would have gotten unchecked? Can an update do that?

Hello All, I have had this Access database for many years and now when I click on a button which opens Excel, renames the Excel file and saves it in a specific folder. Then if the button is clicked on again, it reopens the file again. Now (I believe after an update) I get this "Compile error...

I would like to thank all of you, who's posts trying to help me resolve this issue. The workaround by creating a switchboard form to use in the startup and then going to my frmMain form works. I still hope Microsoft can resolve this issue, but for now I'm happy with the workaround. How this...

So with that information, I was able to create a Switchboard form, add a button to go to frmMain. I put the Switchboard form in my File\Options\Current Database\Display Form to startup and that worked, not error messages. It adds another step to get to my frmMain, but it works without...

Good point. I opened a different form (frmCAREnty) using the File\Options\Current Database\Display Form and it works without errors when I go to the frmMain from the frmCAREntry. Why would that be possible?

I doubt that Microsoft would be of any help. I'm ready to throw in the towel and rebuild my database that has been working since 2011.

Okay this is getting weirder. I just opened it on the 5th PC and it is working perfectly, even when I close it and reopen it. The only difference from all the other PC's is it is the versions of Access. Microsoft® Access® 2019 MSO (Version 2407 Build 16.0.17830.20056) 32-bit (Works) Microsoft®...

Is this where I set the timer interval (see attachment)? I apologize that I'm not sure where I add the Me.Timerinterval = 0? I also discovered when I tried opening on another PC that the first time I open it, it worked flawlessly. The second time, and thereafter, I start getting the error...

I saw little change in performance before and after opening. I have tried opening on 4 different computers and some of them have 32 GB of ram. All do the same thing.

I was just reading about how to properly do that. I have never done it befor.

Yes, I've tried it on 4 different computers and with the same results. Two were running 32bit and two were running 64bit versions of Access.

I'm still trying to understand why I can run this database perfectly if I manually open the form frmMain, but as soon as I open the form using the Access Options or in an Autoexec macro then I get the error message.

When I created the autoexec macro to open form frmMain, I removed it from the startup in the Access options. Still received the error message. Is there a way to open my frmMain after startup, other than autoexec or Access options?

Pat asked about an Autoexec macro and got me thinking maybe if I used an Autoexec macro to open the frmMain, that it would bypass something causing the issue. That didn't work.

To answer Pat, I have many Access database and there is no issue with them. Reboot every day in the morning. I have run the Compact and Repair Database, with no errors found. I set the initial startup under "File/Options/current Database/Display Form:". A little history. This database was...