(Access) Close all open forms.

[xenofoob]

Hello,

tried to search the forum but no threads found. Is there a way to close all the open forms?

HAve tried something like this:

    Dim i As Integer
    MsgBox (Forms.Count)
    For i = 0 To i = Forms.Count
        MsgBox (i)
    Next i

but it didn't work like I expected to.

Thanks a lot!

 

[xenofoob]

-edit-
offcouse the msgbox(i) should be replaced for something like Forms(i).close but the value i is nog increasing. The first message box says there are 4 forms open.

 

[RoyVidar]

For Access, I'd recommend a forum search (top of the page), as there are 7 dedicated Access fora;-)

For this particular challenge, I'd visit TheAccessWeb for a good suggestion Close all open forms and "For Each" syntax

Roy-Vidar

 

[HughLerwill]

For i = 0 To Forms.Count

is worth a try

 

[johnwm]

A good general principal for any closing or deleting actions within a loop is to count downwards:

For i = Forms.Count to 1 Step -1

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

For tsunami relief donations

'If we're supposed to work in Hex, why have we only got A fingers?'

http://www.essexsteam.co.uk

for steam enthusiasts

 

[SonOfEmidec1100]

In VB I always use the forms collection, should work in VBA

Dim frm As Form
For Each frm In Forms
  Unload frm
Next