How can I know number of tables in my data base using textbox

P

PC Datasheet

Put the following code in the Open event of your form:

Dim Db As Database
Set Db = CurrentDb()
Me!NameOfTextBox = Db.TableDefs.Count

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
[email protected]
www.pcdatasheet.com


How can I know number of tables in my data base using textbox in a form?
 
Top