If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Open all forms on startup
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 |
#2
|
|||
|
|||
Open all forms on startup
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. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "swarfmaker" wrote in message ... 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 |
#3
|
|||
|
|||
Open all forms on startup
Many thanks Allen
"Allen Browne" wrote in message ... 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. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "swarfmaker" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|