Is there a way to detect....

[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

 

[Dirk Goldgar]

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?

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.

 

[Rolf Rosenquist]

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

 

[Dirk Goldgar]

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)?

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.

 

[Rolf Rosenquist]

With the help of your answer, I found this link on the net:
http://office.microsoft.com/en-us/assistance/HP010269091033.aspx
where everything seem to be listed.

Then it is another thing to really find it......
/ Rolf

 

[Dirk Goldgar]

With the help of your answer, I found this link on the net:
http://office.microsoft.com/en-us/assistance/HP010269091033.aspx
where everything seem to be listed.

Then it is another thing to really find it......

You can't find this in the regular Access help files? That's odd. What
version are you using? It's pretty sad when you have to go to the web
for things like this.

 

[Fred Boer]

Dear Dirk:

used objects. Actually, for this long-time programmer it has proved
worthwhile to read the Properties chapter from top to bottom.

Have you always struggled with insomnia? <g>

Fred

 

[Dirk Goldgar]

Dear Dirk:


Have you always struggled with insomnia? <g>

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