Open all forms on startup

  • Thread starter Thread starter swarfmaker
  • Start date Start date
S

swarfmaker

Crossposted as I'm not sure which is most appropriate group.

Using Access 2003
I'd like to be able to open all forms with prefix "frm" when the application
is first started up. All to be opened in hidden state.
I know I've seen the code for this somewhere, but can't find it now.
Can anyone help?
TIA
Iain, in Pudsey, UK
 
Loop through the AllForms collection, checking the Name of each one.
DoCmd.OpenForm, using hidden as the window mode.

To loop through AllForms, declare your variable as an AccessObject.

BTW, it's probably not a good idea to have all those forms open in the
background with records loaded and (potentially) edits happening in all of
them.
 
Many thanks Allen


Allen Browne said:
Loop through the AllForms collection, checking the Name of each one.
DoCmd.OpenForm, using hidden as the window mode.

To loop through AllForms, declare your variable as an AccessObject.

BTW, it's probably not a good idea to have all those forms open in the
background with records loaded and (potentially) edits happening in all of
them.
Click to expand...
 
Back
Top