Is there a way to detect....

  • Thread starter Thread starter Rolf Rosenquist
  • Start date Start date
R

Rolf Rosenquist

By deleting records, Access asks if so and so numbers of record(s) should be
deleted.

Is there a way to detect, if a user has marked more than one record to be
deleted?

/ Rolf
 
Rolf Rosenquist said:
By deleting records, Access asks if so and so numbers of record(s)
should be deleted.

Is there a way to detect, if a user has marked more than one record
to be deleted?
Click to expand...

Where and when? You can check if more than one record is selected by
examining the form's SelHeight property. In the course of a delete
process on a form, the form's Delete event will fire once for each
record that is deleted.
 
Thank you very much for the information. I did not know of the *secret*
SelHeight property but now I think I can do what I wanted.

BTW is there a list of these properties, perhaps on the internet, that are
not mentioned in the Help (or the Bible)?
Regards
/ Rolf
 
Rolf Rosenquist said:
Thank you very much for the information. I did not know of the
*secret* SelHeight property but now I think I can do what I wanted.

BTW is there a list of these properties, perhaps on the internet,
that are not mentioned in the Help (or the Bible)?
Click to expand...

Although there are some "secret" -- or at least, undocumented --
properties and methods, SelHeight isn't one of them. It's right there
in the help file, in the "Microsoft Access Visual Basic Reference" book,
which is under the "Programming in Visual Basic" header. It's listed in
the Properties section, and as one of the properties of the Form object
in the Objects section.

It's not always easy to find things in the help, in its current state,
but it pays to read through the properties lists of the more commonly
used objects. Actually, for this long-time programmer it has proved
worthwhile to read the Properties chapter from top to bottom.

Aside from that, I can't make any particular suggestions as far as
Internet resources are concerned. The _Access <version> Developer's
Handbook_, by Getz et. al., from Sybex, is a terrific printed resource
for any developer.
 
Dear Dirk:
used objects. Actually, for this long-time programmer it has proved
worthwhile to read the Properties chapter from top to bottom.
Click to expand...

Have you always struggled with insomnia? <g>

Fred
 
Fred Boer said:
Dear Dirk:


Have you always struggled with insomnia? <g>
Click to expand...

The excitement I feel when reading lists of properties and methods does
tend to keep me up at night, yes. ;-)
 
Back
Top