Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how to count the number of records

Status
Not open for further replies.
susu

susu

Technical User
May 15, 2001
5
US
Hi,
How do i get to show the number of records in a label or text box from a table selected in a combo box?
Thanks
 
Sort by date Sort by votes
Try this in a Form_Load

Dim rs As DAO.Recordset
Dim SQL As String
SQL = "SELECT count(table1.test) as TestCount FROM table1"
Set rs = CurrentDb().OpenRecordset(SQL)
Me.txtTest = rs("TestCount")
rs.Close
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

FrankMars
  • Locked
  • Question
Exporting Records to Excel 1
Replies
6
Views
463
Andrzejek
Andrzejek
Moss100
  • Locked
  • Question
Remove everything including the comma from the last comma of a string. 1
Replies
10
Views
606
Andrzejek
Andrzejek
feipezi
  • Locked
  • Question
How to get the macros back as they vanish somehow in a AccessDB?
Replies
8
Views
447
combo
combo
M
  • Locked
  • Question
display a calendar with appointments in body of html email with access vba
Replies
1
Views
2K
SoftwareRT
SoftwareRT
Drago1920
  • Locked
  • Question
Finding the lowest date
Replies
2
Views
321
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top