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
(e-mail address removed)
www.pcdatasheet.com


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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Requery control in (main form) from (subform) 1
Delete Tables 2
printing a form 1
Automatically reattach SQL backend tables 1
pulling data as a label 1
Opening another form from a combobox selection 2
The 3 Newes records 1
Protect your data base by Processor Serial Number Question 2

Top