If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Access 2007 Form Datasheet
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 |
#3
|
|||
|
|||
Access 2007 Form Datasheet
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? |
#4
|
|||
|
|||
Access 2007 Form Datasheet
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. ================================================== ======= |
#5
|
|||
|
|||
Access 2007 Form Datasheet
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? |
#6
|
|||
|
|||
Access 2007 Form Datasheet
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? |
#7
|
|||
|
|||
Access 2007 Form Datasheet
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. ================================================== ======= |
#8
|
|||
|
|||
Access 2007 Form Datasheet
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. ================================================== ======= |
#9
|
|||
|
|||
Access 2007 Form Datasheet
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. ================================================== ======= |
#10
|
|||
|
|||
Access 2007 Form Datasheet
"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 ---------- |
|
Thread Tools | |
Display Modes | |
|
|