There about 30 forms in my Access app.
In all forms, I want to setup the same property, such as AUTOSIZE=NO, POPUP=NO.
How to use VBA to loop all forms to do this job once open mdb file?
There about 30 forms in my Access app.
In all forms, I want to setup the same property, such as AUTOSIZE=NO, POPUP=NO.
How to use VBA to loop all forms to do this job once open mdb file?
Use the Forms collection to iterate through all forms.
http://msdn.microsoft.com/en-us/libr...ffice.11).aspx
However, I don't know if properties can be set while forms are closed and not in design view.
http://msdn.microsoft.com/en-us/libr...ffice.11).aspx
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.