Is it possible to have a message or a flag of somesort pop up when a specific numbered record is entered? Say I want something to happen after record # 10 is entered.
thanks
Is it possible to have a message or a flag of somesort pop up when a specific numbered record is entered? Say I want something to happen after record # 10 is entered.
thanks
Do you know how to determine how many records are in your RecordSet?
Other than opening up the table alot...no.
If you are talking about entering records by opening the table directly, then the answer is *no*. There are no triggers in Access tables. You can however do what you suggest by entering your records through a form.
Yes..I am suggesting through a form. Can a form keep track and "flag" memon a specified record number?
If you do a .Movelast in the RecordsetClone, the RecordsetClone.RecordCount will tell you how many records are in the Recordset.
Just curious if you were able to resolve your issue.
If you are still looking/working on a solution, can you elaborate further on your above quote?
I don't quite understand what you are checking (i.e. field's value, AutoNumber, record count in Recordset) against (i.e. LIST of predetermined Record numbers, every 10th record in Recordset, etc).
Thanks.
-RC
I got some real good ideas from some folks but I don't know if the issue is resolved because I haven't gone "live" with the database yet. When I find out if there suggestions worked or didn't work, I will let you know.
thanks for checking!
Cheers
No problem...take care!
-RC