Message box with number of records?

H

Harmannus

Hallo,

Is it possitble to make a button on a form attachted to a message box that
shows the number of records?

e.g. There are 7 records present.

with ok to cancel

Thanx for any tips!

Regards,

Harmannus
 
S

Steve Schapel

Harmannus,

MsgBox "There are " & Me.RecordsetClone.RecordCount & " records
present."

- Steve Schapel, Microsoft Access MVP
 
H

Harmannus

Thanx!

Works great.


Regards,
Harmannus

Steve Schapel said:
Harmannus,

MsgBox "There are " & Me.RecordsetClone.RecordCount & " records
present."

- Steve Schapel, Microsoft Access MVP
 

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

Start mdb from mdb 2
Unbound listbox 4
Extract housenumber from address 7
Time 08.00 in stead of 08:00? 7
Order/invoicenumber? 2
Copy record by clicking a button? 3
Remove default menu- and toolbar? 1
Newsbar? 3

Top