Access form in Office 365 is minimized when opening from Excel using Docmd.Openform (1 Viewer)

[BBest]

Hi, I could use some help with this. Just ran out of things to try. I am opening a form in dialog mode from an Excel spreadsheet in Office 365 and it always opens minimized. I have done this many times and it has always opened on the screen without additional clicks. When I make the call to DoCmd.Openform in Office 365 you can see Access is open in the taskbar minimized and you have to click on it for the form to show. I don’t want my users having to click on the app to open it, actually it is hard to even notice it is there. The code I have works fine in Access 2024, 2021 and 2019 but not in Office 365. The Access form is set to PopUp = Yes, Modal = Yes, Auto Center = Yes and Auto Resize = Yes. In Access I have added code to the load event on the form attempting to make it show but nothing is working. Added Docmd.Maximize, DoCmd.Move both work only after icon clicked in taskbar.

I also made a blank form with one field and no code and that gives me the same result when it is opened from Excel.

I tried this on 3 different win11 machines with Office 365, one just reloaded and only office 365 added, and have the exact same results.


Am I missing something that has been added to Office 365 or does something need to be changed in my code?



Code in Excel
Dim accApp As Access.Application

Set accApp = New Access.Application

With accApp
.Visible = True ' false would be preferable but it doesn’t even show on screen in 365, true works fine in all other versions.

.OpenCurrentDatabase AccessDbFilePath
.DoCmd.OpenForm FormName:=FormReportStr, WindowMode:=acDialog, WhereCondition:=WhereStr, OpenArgs:=ArgsStr ' Open form in dialog mode
End With

Since the form is being opened in acDialog mode this code stops after the DoCmd.Openform and sits there until the form running in access is closed.

Any help would be appreciated!

 

[isladogs]

Crossposted at https://www.accessforums.net/showthread.php?t=91221

 

[Gasman]

I thought I had seen it before.

 

[isladogs]

To be fair, new users can’t post links but they should still inform us of cross posting. The OP has had several responses at the other forum

 

[BBest]

To be fair, new users can’t post links but they should still inform us of cross posting. The OP has had several responses at the other forum

I'm just trying to find a solution to my problem. I'm sorry I posted this question on 2 sites. I was unaware that putting it on two different forums was a problem. My thinking was that different people are going to the different sites and maybe someone could help me. I have been using access since it first came out and this is the first time I reached out for help. I haven't found a solution to my issue. I have created a new access db with one form and only the call to it in excel. It actually worked, no minimizing! Tried making the call to original access db and it worked then in my testing it was minimized again with no changes made. Just opening and closing access from the spreadsheet. I then went back to the test, it is now minimizing in the test and I can't get it to work again. Made a new DB and spreadsheet like the first time and it is still minimizing. There is something in the registry or in some setting causing the issue. I could still use some input as to why this is happening. Thanks

 

[isladogs]

The issue isn't specifically about cross posting itself but not stating you have done so.

Please read this article about the etiquette related to cross posting.

A Message to Forum Cross Posters

Do you know why you're here? If you have been pointed to this page, it is not because someone is mad at you, but rather because we want to curb your posting habits before people start ignoring your posts. Online … Continue reading →

excelguru.ca

Then please go to the other forum and add a link back to this thread

 

[isladogs]

Can you upload a simple repro database and example Excel file that demonstrates the issue

 

[Gasman]

Then please go to the other forum and add a link back to this thread

I have already advised the other forum.

 

[BBest]

The link was already there. So here is a very cutdown version of what is happening. There is an access Db and an excel spreadsheet. The path in excel to the access db is c:\ONP. Thanks for any help and sorry for the confusion with the posting. I would appreciate any help with this. More info in readme. Thanks