Access 2007 Form Datasheet

Access 2007 datasheet view for forms has a dropdown in each column header
for sorting.
Is there any way to remove it?

Thanks,

--

AG
Email: npATadhdataDOTcom

Good question, i think it's by design so as far as I know there's now ay to
ger rid of that in datasheet view.
--
Maurice Ausum


"AG" wrote:

Access 2007 datasheet view for forms has a dropdown in each column header
for sorting.
Is there any way to remove it?

Thanks,

--

AG
Email: npATadhdataDOTcom

See this page on my site:
http://accessjunkie.com/faq_53.aspx

--
Jeff Conrad - Access Junkie - MVP Alumnus
SDET - XAS Services - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------

"AG" wrote in message:
...

Access 2007 datasheet view for forms has a dropdown in each column header
for sorting.
Is there any way to remove it?

Hi Ag,

Thank you for using Microsoft MSDN Managed Newsgroup. My name is Mark Han.
I am glad to work with you on this issue.

From your description, I understand that you would like to remove the drop
down arrows that show up with a datasheet form to filter the columns
If I have misunderstood, please let me know.

After checking the link http://accessjunkie.com/faq_53.aspx; there is a
workaround for you and I have tried it. it works. however if the workaround
works depends on several elements. For example, the scenario; the software
enviroment. Since the issue is by-design, if the workaround doesn't work, I
will help to apply it to our dev team. and also we welcome you to send
feedback to us.
http://support.microsoft.com/contactus/?WS=Wish

If you have any other questions, please let me know.

Have a nice day.

Best regards,
Mark Han
Microsoft Online Community Support
================================================== =========
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: .
================================================== =========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.

Note: MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or
a Microsoft Support Engineer within 2 business day is acceptable. Please
note that each follow up response may take approximately
2 business days as the support professional working with you may need
further investigation to reach the most efficient resolution.
The offering is not appropriate for situations that require urgent,
real-time or phone-based interactions. Issues of this nature are
best handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/en-us/subs.../aa948874.aspx

================================================== ==========
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======

Hi Jeff,

Thanks for posting this. Always good to know that something which is by
design can be altered ;-)
--
Maurice Ausum


"Jeff Conrad [MSFT]" wrote:

See this page on my site:
http://accessjunkie.com/faq_53.aspx

--
Jeff Conrad - Access Junkie - MVP Alumnus
SDET - XAS Services - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------

"AG" wrote in message:
...

Access 2007 datasheet view for forms has a dropdown in each column header
for sorting.
Is there any way to remove it?

Thanks Jeff,

I knew I saw something somewhere, but could not remember.
That will suffice in many instances, but sometimes I would like to be able
to use a custom shortcut menu.
Any way around that?

--

AG
Email: npATadhdataDOTcom


"Jeff Conrad [MSFT]" wrote in message
...
See this page on my site:
http://accessjunkie.com/faq_53.aspx

--
Jeff Conrad - Access Junkie - MVP Alumnus
SDET - XAS Services - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

----------
This posting is provided "AS IS" with no warranties, and confers no
rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------

"AG" wrote in message:
...

Access 2007 datasheet view for forms has a dropdown in each column header
for sorting.
Is there any way to remove it?

Thanks for the reply Mark.

Jeff's solution works if I don't want ANY shortcut menu.
What if I want a custom shortcut menu, but not the one on the column header?

Access 2007 has some good new features. However, they are designed for the
'power user' and do not provide enough control for developers.
Many of us build applications for users that know little more than how to
use a mouse and keyboard, never mind filtering, sorting, queries, design,
etc.
We need a method of controling 'by design' features.

I guess the 'wish' part of the feedback link you provided refers to
'wishing' Microsoft would make it easy to provide feedback. Have you tried
it?

--

AG
Email: npATadhdataDOTcom


"Mark Han[MSFT]" wrote in message
...
Hi Ag,

Thank you for using Microsoft MSDN Managed Newsgroup. My name is Mark Han.
I am glad to work with you on this issue.

From your description, I understand that you would like to remove the drop
down arrows that show up with a datasheet form to filter the columns
If I have misunderstood, please let me know.

After checking the link http://accessjunkie.com/faq_53.aspx; there is a
workaround for you and I have tried it. it works. however if the
workaround
works depends on several elements. For example, the scenario; the software
enviroment. Since the issue is by-design, if the workaround doesn't work,
I
will help to apply it to our dev team. and also we welcome you to send
feedback to us.
http://support.microsoft.com/contactus/?WS=Wish

If you have any other questions, please let me know.

Have a nice day.

Best regards,
Mark Han
Microsoft Online Community Support
================================================== =========
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: .
================================================== =========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.

Note: MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or
a Microsoft Support Engineer within 2 business day is acceptable. Please
note that each follow up response may take approximately
2 business days as the support professional working with you may need
further investigation to reach the most efficient resolution.
The offering is not appropriate for situations that require urgent,
real-time or phone-based interactions. Issues of this nature are
best handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/en-us/subs.../aa948874.aspx

================================================== ==========
This posting is provided "AS IS" with no warranties, and confers no
rights.
================================================== =======

Hi Ag,

Thank you for the update.

Based on your description, I understand that you would like to remove the
drop down arrows that show up with a datasheet form to filter the columns
and still save the shortcut menu fuction. Based on my research, currently
it seems that there is not a workaound for that.

I understand your concern. we welcome you send the feedback to
us:http://www.microsoft.com/office/comm...?type=suggesti
on

Besides, I have consulted the issue with our dev team. if anything updated,
I will public it.

Have a nice day.

Best regards,
Mark Han
Microsoft Online Community Support
================================================== =======
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: .
================================================== =======
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======

Mark,

Thanks for the reply.
I sort of figured that would be the case. Hopefully, the dev team will open
their minds and try to include a bit more control for developers.

The link you provided, however, is useless. It offers to search the
discussion groups for my 'suggestion'. Then when it doesn't find it offers
to post it to the group - duh - that is where I started!

--

AG
Email: npATadhdataDOTcom


"Mark Han[MSFT]" wrote in message
...
Hi Ag,

Thank you for the update.

Based on your description, I understand that you would like to remove the
drop down arrows that show up with a datasheet form to filter the columns
and still save the shortcut menu fuction. Based on my research, currently
it seems that there is not a workaound for that.

I understand your concern. we welcome you send the feedback to
us:http://www.microsoft.com/office/comm...?type=suggesti
on

Besides, I have consulted the issue with our dev team. if anything
updated,
I will public it.

Have a nice day.

Best regards,
Mark Han
Microsoft Online Community Support
================================================== =======
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: .
================================================== =======
This posting is provided "AS IS" with no warranties, and confers no
rights.
================================================== =======

"AG" wrote in message:
...

Thanks Jeff,

I knew I saw something somewhere, but could not remember.
That will suffice in many instances, but sometimes I would like to be able
to use a custom shortcut menu.
Any way around that?

Hi AG,

No, unfortunately this is the only way to hide the sort/filter options on
the datasheet.

This issue has been discussed by the team.

--
Jeff Conrad - Access Junkie - MVP Alumnus
SDET - XAS Services - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------