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
Click to expand...
 

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

Line Numbers Will Not Show 0
Input mask by VBA 0
Transport record value 10
Next record with keyboard letter (combination)? 2
Start mdb from mdb 2
Order/invoicenumber? 2
Field TAB color 2
DMax on existing record to increment serialized # fails 1

Top