<html><div style='background-color:'><DIV>
<P>This is definitely do-able. You would need to do just as you said (various levels of loops) and open the objects in Design-view, though. I would investigate the system tables first to see what's already available there. I don't have any code to help you with this project. It seems to me that in A2K and beyond M$ has done something similiar with their tracking of changes in the database (I don't use it - so I'm not sure....tooo scary - I'll wait till I'm sure it doesn't cause more problems than it solves) Once you have solved this...I'm sure there would be application for it...you could become famous!8-)</P>
<P>_d<BR><BR></P></DIV><BR><BR><BR>
<DIV></DIV>
<DIV><FONT face="Geneva, Arial, Sans-serif" color=#6666ff size=2><EM>"Things are only free to the extent that you don't pay for them." </EM></FONT></DIV>
<DIV><FONT color=#33cc66></FONT></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>>From: marcel.vreuls@achmea.nl
<DIV></DIV>>Reply-To: accessd@databaseadvisors.com
<DIV></DIV>>To: accessd@databaseadvisors.com
<DIV></DIV>>Subject: Betreft: RE: [AccessD] Looping through forms
<DIV></DIV>>Date: Tue, 27 May 2003 14:00:13 +0200
<DIV></DIV>>
<DIV></DIV>>Hi Mark,
<DIV></DIV>>
<DIV></DIV>>You are right then I have the documentation available. But than I have to
<DIV></DIV>>manualy compare the two documents on paper. That is something I do not want
<DIV></DIV>>because it takes up to much time and I can make mistakes.
<DIV></DIV>>
<DIV></DIV>>Thanks,
<DIV></DIV>>
<DIV></DIV>>marcel
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>"Mitsules, Mark" <MITSULES_MS@NNS.COM>@databaseadvisors.com op 27-05-2003
<DIV></DIV>>13:46:48
<DIV></DIV>>
<DIV></DIV>>Antwoord aub aan accessd@databaseadvisors.com
<DIV></DIV>>
<DIV></DIV>>Verzonden door: accessd-bounces@databaseadvisors.com
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>Aan: "'accessd@databaseadvisors.com'" <ACCESSD@DATABASEADVISORS.COM>
<DIV></DIV>>cc:
<DIV></DIV>>
<DIV></DIV>>Onderwerp: RE: [AccessD] Looping through forms
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>For your purposes, will Tools/Analyze/Documenter work?
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>Mark
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>-----Original Message-----
<DIV></DIV>>From: marcel.vreuls@achmea.nl [mailto:marcel.vreuls@achmea.nl]
<DIV></DIV>>Sent: Tuesday, May 27, 2003 5:43 AM
<DIV></DIV>>To: accessd@databaseadvisors.com
<DIV></DIV>>Subject: [AccessD] Looping through forms
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>Dear group,
<DIV></DIV>>
<DIV></DIV>>Does anyone know how I can achieve the following.
<DIV></DIV>>
<DIV></DIV>>I want to loop through all the forms and reports available in the database.
<DIV></DIV>>Then for each form loop through all the controls and save of each control
<DIV></DIV>>the controltype, caption, text, defaultvalue, format, fieldtype in a table.
<DIV></DIV>>I want to do this because I have weird things with controls that suddenly
<DIV></DIV>>behave strange. That way I can check the current controls properties with
<DIV></DIV>>their previous properties.
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>THanks,
<DIV></DIV>>
<DIV></DIV>>In advance.
<DIV></DIV>>
<DIV></DIV>>Marcel Vreuls
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>********************* DISCLAIMER *********************
<DIV></DIV>>De informatie in dit e-mail bericht is uitsluitend
<DIV></DIV>>bestemd voor de geadresseerde. Verstrekking aan
<DIV></DIV>>en gebruik door anderen is niet toegestaan.
<DIV></DIV>>Door de electronische verzending van het bericht
<DIV></DIV>>kunnen er geen rechten worden ontleend aan de
<DIV></DIV>>informatie.
<DIV></DIV>>************************************************************
<DIV></DIV>>
<DIV></DIV>>_______________________________________________
<DIV></DIV>>AccessD mailing list
<DIV></DIV>>AccessD@databaseadvisors.com
<DIV></DIV>>http://databaseadvisors.com/mailman/listinfo/accessd
<DIV></DIV>>Website: http://www.databaseadvisors.com
<DIV></DIV>>_______________________________________________
<DIV></DIV>>AccessD mailing list
<DIV></DIV>>AccessD@databaseadvisors.com
<DIV></DIV>>http://databaseadvisors.com/mailman/listinfo/accessd
<DIV></DIV>>Website: http://www.databaseadvisors.com
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>*****************************************************************
<DIV></DIV>>Dit bericht is bij binnenkomst gecontroleerd op de
<DIV></DIV>>aanwezigheid van virussen. Er zijn geen (bekende)
<DIV></DIV>>virussen gevonden. Active
<DIV></DIV>>*****************************************************************
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>********************* DISCLAIMER *********************
<DIV></DIV>>De informatie in dit e-mail bericht is uitsluitend
<DIV></DIV>>bestemd voor de geadresseerde. Verstrekking aan
<DIV></DIV>>en gebruik door anderen is niet toegestaan.
<DIV></DIV>>Door de electronische verzending van het bericht
<DIV></DIV>>kunnen er geen rechten worden ontleend aan de
<DIV></DIV>>informatie.
<DIV></DIV>>************************************************************
<DIV></DIV>>
<DIV></DIV>>_______________________________________________
<DIV></DIV>>AccessD mailing list
<DIV></DIV>>AccessD@databaseadvisors.com
<DIV></DIV>>http://databaseadvisors.com/mailman/listinfo/accessd
<DIV></DIV>>Website: http://www.databaseadvisors.com
<DIV></DIV></div><br clear=all><hr>MSN 8 helps <a href="http://g.msn.com/8HMVENUS/2743??PS=">ELIMINATE E-MAIL VIRUSES. </a> Get 2 months FREE*.</html>