Drew Wutka
DWUTKA at Marlow.com
Wed Mar 12 16:28:05 CDT 2008
Drop the parenthesis. So in code: GetAllTableRecordCount 1, True Or Call GetAllTableRecordCount(1,True) GetAllTableRecordCount(1,True) 'This will kick up an 'Expecting =' error Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte Sent: Wednesday, March 12, 2008 4:08 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Record Count for all tables PART 2 Drew, So far beautiful...but I'm having a problem calling the function and get the field names. I think intelisense has confused me...after I pick the table parameter...it drops down true/false:GetAllTableRecordCount (1,True)...but this does not work...says 'expecting ='. Thanks again, Mark A. Matte > Date: Tue, 11 Mar 2008 16:36:05 -0500 > From: DWUTKA at marlow.com > To: accessd at databaseadvisors.com > Subject: Re: [AccessD] Record Count for all tables PART 2 > > Darn, didn't keep the attachment, here it is: > > http://www.marlow.com/GetAllTableRecordCount.zip > > Drew > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Drew Wutka > Sent: Tuesday, March 11, 2008 4:21 PM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Record Count for all tables PART 2 > > The attached is a .txt doc with a modified version of that function I > posted earlier. The debug.print lines are commented out, instead, the > function creates two tables, one for table and recordcounts, and one for > table/query fields. > > Same function, so you have the option of selecting tables, queries, or > both, and the second optional argument, when set to true, will get you > field information too. > > I'm only getting the basic field type, if you want more information, > like if the fields are indexed, etc, it's just a matter of getting more > data out of the items in the Fields collection. > > Another FYI, this code, when placed in a module, is going to work on the > local database because of currentproject.connection. If you replace all > 'currentproject.connection' with a different (but valid) ADODB > connection object, it will do the same process for any database (Access, > MySQL, Oracle, etc.) (The beauty of ADO) > > Drew > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte > Sent: Tuesday, March 11, 2008 2:27 PM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Record Count for all tables PART 2 > > > Drew, > > Worked like a charm!!!...But I guess I didn't ask enough > detail...because I was thought I would get the same Documentor > functionality like in A97...anyway... > > Is there a similar way to get field names and types? > > (Sorry for having to ask twice) > > Thanks, > > Mark A. Matte > > > > The information contained in this transmission is intended only for the > person or entity to which it is addressed and may contain II-VI > Proprietary and/or II-VI Business Sensitive material. If you are not the > intended recipient, please contact the sender immediately and destroy > the material in its entirety, whether electronic or hard copy. You are > notified that any review, retransmission, copying, disclosure, > dissemination, or other use of, or taking of any action in reliance upon > this information by persons or entities other than the intended > recipient is prohibited. > > The information contained in this transmission is intended only for the person or entity to which it is addressed and may contain II-VI Proprietary and/or II-VI Business Sensitive material. If you are not the intended recipient, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. You are notified that any review, retransmission, copying, disclosure, dissemination, or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com _________________________________________________________________ Connect and share in new ways with Windows Live. http://www.windowslive.com/share.html?ocid=TXT_TAGHM_Wave2_sharelife_012 008 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com The information contained in this transmission is intended only for the person or entity to which it is addressed and may contain II-VI Proprietary and/or II-VI Business Sensitive material. If you are not the intended recipient, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. You are notified that any review, retransmission, copying, disclosure, dissemination, or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited.