By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,827 Members | 2,277 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,827 IT Pros & Developers. It's quick & easy.

Subform header in Datasheet view

P: n/a
I have an Access 2000 form with a subform in Datasheet view.
When I click on an item in the header of the subform (the title at the top
of one of the columns), I'd like to be able to capture the fact that I'm
clicking in the header and not somewhere in the detail section.

How can I learn this?

TIA
- Turtle
Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Datasheet view is just a view. It doesn't expose sections like that.

If you work in Continuous Form view, you can detect that the label you
clicked on is in the Form Header section.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"MacDermott" <ma********@nospam.com> wrote in message
news:Hz******************@newsread3.news.atl.earth link.net...
I have an Access 2000 form with a subform in Datasheet view.
When I click on an item in the header of the subform (the title at the top
of one of the columns), I'd like to be able to capture the fact that I'm
clicking in the header and not somewhere in the detail section.

Nov 12 '05 #2

P: n/a
Thanks, Allen!

My client wants to be able to order and size the columns -
I'd hate to have to program THAT functionality in Continuous forms.
I've found that I can check the y value on the MouseDown -
if it's less than 255, I'm in the "header".

I still haven't figured out the question in my other post, though.
Even if I set the application's Shortcut Menu to my custom menu, when I
right-click on the "header" of the subform, I get the default shortcut menu.

Any ideas on that one?
- Turtle

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:3f**********************@freenews.iinet.net.a u...
Datasheet view is just a view. It doesn't expose sections like that.

If you work in Continuous Form view, you can detect that the label you
clicked on is in the Form Header section.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"MacDermott" <ma********@nospam.com> wrote in message
news:Hz******************@newsread3.news.atl.earth link.net...
I have an Access 2000 form with a subform in Datasheet view.
When I click on an item in the header of the subform (the title at the top of one of the columns), I'd like to be able to capture the fact that I'm
clicking in the header and not somewhere in the detail section.


Nov 12 '05 #3

P: n/a
Nah.

Actually I rarely use datasheets, precisely because the client can resize
and hide columns. Ever had users asking where the column has gone, and how
to get it back?

"MacDermott" <ma********@nospam.com> wrote in message
news:al******************@newsread3.news.atl.earth link.net...
Thanks, Allen!

My client wants to be able to order and size the columns -
I'd hate to have to program THAT functionality in Continuous forms.
I've found that I can check the y value on the MouseDown -
if it's less than 255, I'm in the "header".

I still haven't figured out the question in my other post, though.
Even if I set the application's Shortcut Menu to my custom menu, when I
right-click on the "header" of the subform, I get the default shortcut menu.
Any ideas on that one?
- Turtle

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:3f**********************@freenews.iinet.net.a u...
Datasheet view is just a view. It doesn't expose sections like that.

If you work in Continuous Form view, you can detect that the label you
clicked on is in the Form Header section.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"MacDermott" <ma********@nospam.com> wrote in message
news:Hz******************@newsread3.news.atl.earth link.net...
I have an Access 2000 form with a subform in Datasheet view.
When I click on an item in the header of the subform (the title at the top of one of the columns), I'd like to be able to capture the fact that I'm clicking in the header and not somewhere in the detail section.



Nov 12 '05 #4

P: n/a
Al*********@SeeSig.Invalid (Allen Browne) wrote in
<3f**********************@freenews.iinet.net.au> :
Actually I rarely use datasheets, precisely because the client can
resize and hide columns. Ever had users asking where the column
has gone, and how to get it back?


Why not have the form set all columns to a certain width in the
datasheet's OnLoad event? Then if the client has the problem, they
can close and then open the form to see all the columns.

I don't use datasheets much, either.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.