Arthur Fuller
fuller.artful at gmail.com
Sat Jul 2 12:06:08 CDT 2011
I know that I've written this code before, but due to a plethora of backup CDs and my habit of pruning what is not currently necessary from the current situation(s), I can't find the relevant code. And besides, I'm currently semi-retired, and working in hobbyist most not billable mode. Here's what I need, in ADO format if possible: <pseudo vba> For each t in CurrentDB( Tables ) For each f in t.fields For each a in f.Attributes ' could be Properties not Attributes Debug.Print a.Name, a.Value Next Next Next </pseudo vba> TIA, Arthur P.S. For years and years and years, I have used Rick Fisher's FindAndReplace, but now it's failing on me due to (I think) the fact that I'm running a 64-bit Windows, which doesn't like what he offers to install. In my retirement mode, I cannot afford to purchase more software. Maybe I could run a Windows 32-bit version of everything, then run F&R, then do what I need to do, then import the results back into 64-bit. Yuck.