[AccessD] Open all forms

Mark A Matte markamatte at hotmail.com
Mon Jul 21 10:15:46 CDT 2008


Rocky,

I did something similar a few months ago.  I searched every form for a text box that had a ControlSource LIKE "*MySearch*" and Updated the ControlSource to "SomethingNew".

I think this is what you need.  I Have it at home and can send it this evening (about 3:00 your time)

Thanks,

Mark A. Matte




> From: rockysmolin at bchacc.com
> To: accessd at databaseadvisors.com
> Date: Mon, 21 Jul 2008 07:11:26 -0700
> Subject: [AccessD] Open all forms
>
> Dear List:
>
> I am trying to write a quick module that will open all the forms in turn in
> design view, change one property (in this case the background color of the
> detail section), save and close. But I can't seem to get the syntax right
> to open each of the forms in turn.
>
> Does anyone have a snip to do this?
>
> MTIA
>
> Rocky Smolin
>
> Beach Access Software
>
> 858-259-4334
>
> www.e-z-mrp.com 
>
> www.bchacc.com 
>
>
>
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com

_________________________________________________________________
With Windows Live for mobile, your contacts travel with you.
http://www.windowslive.com/mobile/overview.html?ocid=TXT_TAGLM_WL_mobile_072008



More information about the AccessD mailing list