Hide a form

[DC CS]

I have a form that detects idle time. This was adapted from a forum.
The code when logging into the database, as follows:

        DoCmd.Close acForm, "Frm_Logon", acSaveNo
        DoCmd.OpenForm "Frm_DetectIdleTime", , , , acHidden
        DoCmd.OpenForm "Main"

When the "Main" form is opened, the "Frm_DetectIdleTime" is still visible and not hidden.




Thanks

[Welshgasman]

This is what I get from intellisense in the immediate window?

docmd.OpenForm "Form1",,,,,acHidden

acSaveNo is only if the form was opened in design mode.

[Bob Fitz]

I have a form that detects idle time. This was adapted from a forum.
The code when logging into the database, as follows:

        DoCmd.Close acForm, "Frm_Logon", acSaveNo
        DoCmd.OpenForm "Frm_DetectIdleTime", , , , acHidden
        DoCmd.OpenForm "Main"

When the "Main" form is opened, the "Frm_DetectIdleTime" is still visible and not hidden.


Thanks

In case you haven't noticed, you have four commas in the following line but Welshgasman has five commas.
DoCmd.OpenForm "Frm_DetectIdleTime", , , , acHidden

[Welshgasman]

In case you haven't noticed, you have four commas in the following line but Welshgasman has five commas.
DoCmd.OpenForm "Frm_DetectIdleTime", , , , acHidden

Yes, and I just used intellisense, as I do not know what goes where.

[DC CS]

Hi. You are correct. After using IntelliSense, I also had 5 commas and the form is hidden.

Thanks

[Welshgasman]

Hi. You are correct. After using IntelliSense, I also had 5 commas and the form is hidden.

Thanks

It is there for a reason. may as well use it.? I am not even sure how you can ignore it TBH, and why you would switch it off is beyond me.

switch off intellisense access

[isladogs]

I don't believe it is possible to switch off Intellisense in Access. It isn't wise even if it is possible
If you know better, please tell me how you did it so I can advise others how to re-enable it in future

[Welshgasman]

Colin, I would not do it, but I just googled as to how it might be done.
So please try that link. I leave it to the o/p's to follow up

Edit:
Just tried it myself, deselect AutoList members

Mind you I had to go and find this as something I would never do?

[isladogs]

Thanks Paul
Just checked the help documents for VBE options: Options dialog box | Microsoft Learn

Auto List Members: Displays a list that contains information that would logically complete the statement at the current insertion point.

Not the most obvious way of saying - tick this to get intellisense. Untick to lose it!
I can't think of any reason why anyone would ever want to disable this.
However, I just tried disabling it and Intellisense is indeed immediately switched off. I've immediately enabled it again!

Next time, someone tells me intellisense doesn't work I'll know what to tell them to enable it again