Gary Croxford
asked on
Access Form Display Without New Record
Thank you for looking at my question,
I have a form pulling data directly from a table. Is it possible to not display the new record IE to only display those records from the table containing data.
I have a form pulling data directly from a table. Is it possible to not display the new record IE to only display those records from the table containing data.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Should users be able to edit data? If not, then consider setting AllowEdits to false, or the dataset type to Snapshot.
I would not set the dataset type to snapshot unless you really need it.
"snapshot" sounds fast and it is a light weight cursor in the end, but it can be expensive to execute depending on the size of the resultset.
When you tell JET/ACE to do a snapshot, your asking it to create a copy of all the records in the resultset at a given point in time. Few hundred records won't matter, but if it's in the tens of thousands or larger, you will notice the difference.
Jim.
"snapshot" sounds fast and it is a light weight cursor in the end, but it can be expensive to execute depending on the size of the resultset.
When you tell JET/ACE to do a snapshot, your asking it to create a copy of all the records in the resultset at a given point in time. Few hundred records won't matter, but if it's in the tens of thousands or larger, you will notice the difference.
Jim.
ASKER