Working on converting some old MS2000 access applications to MS2007. I have many datasheets in the application and I have noticed that on all of them the column headers have a down arrow with sort/filter options. This arrow is covering up some of the letters on the column descriptions. I have built-in listboxes on my forms that allow the users to select the criteria they need so I do not need the drop down sort/filters on the columns. My users will be using 'Runtime Access' to run the application. I was told that it does not show the drop down arrow on the column header, but when I ran the access app in Runtime, the arrows are present. Is there some way to turn these off?
Thanks!!
7 30603
You can do it if you don't need the shortcut menu feature. Here is how thanks to Jeff Conrad aka the Access Junkie:
If you don't want to display these arrows, here's a quick workaround to disable them. Open the datasheet form in Design View and then open the Property Sheet for the form. Look for the property called Shortcut Menu on the Other or All tab of the Property Sheet. Change that property to No, save the form, and now switch back to Datasheet View. Access now removes the arrows from the top of the column headers.
Thanks... this is exactly what I needed!
I have lots of forms in my application if I have to do this for each form, would be time consuming. I see on the 'startup' options for the application there is a setting "allow default shortcut menus", I removed the checkbox from this option and the down arrows still how on the forms. I thought that this option handle it at an application level so I would not have to do each form.
Unfortunately, you have to turn "ALL" shortcut menus off, and "Default" is close, but not quite the same as "ALL".
You should be able to get around having to manually open and change each form by using a vba code routine to loop the open forms, and change the property setting for the shortcut menus. In doing so, you need to keep the following in mind:
The forms collection only contains <<<open>>> forms, so you will need to code a routine that works around that limitation and opens each form in design view, changes the property setting, and then closes that form and moves to the next form. It is my understanding that in order to "persist" the changes to the form property settings, the change has to be made in design view.
In Access 2000 or newer, you can use something like this: -
Dim oForm As AccessObject
-
Dim oDatabase As Object
-
Dim strFrm As String
-
-
Set oDatabase = Application.CurrentProject
-
For Each oForm In oDatabase.AllForms
-
strFrm = oForm.Name
-
DoCmd.OpenForm strFrm, acDesign
-
XXXX Code to change Shortcut menu property goes here
-
DoCmd.Close acForm, strFrm, acSaveYes
-
Next oForm
-
-
oDatabase.Close
-
Set oDatabase = Nothing
Thanks a lot to puppydogbuddy : I add that you can also keep shortcut menu by changing the property of the form on its Open event. Basically, you have to :
- turn off Shortcutmenu in Property menu of the form
- add the code below : - Private Sub Form_Open(Cancel As Integer)
-
Me.ShortcutMenu = True
-
End Sub
Then the form in datasheetview mode will open without builtin sort/filter in headers and still keep its shortcut menus : magic, isn't it ?!!!
To my mind, this workaround is very important because builtin sort/filter functionnality is not reliable at all with numerous datas (>20000 records) : it is very slow (and doesn't show hourglass !) and it bugs with complex filters ('OR' condition for example).
SAMIFROMFRANCE your input was actually exactly what I needed, as I wanted to still have filter options available on the right-click menu but didn't want the user to see the column pulldown options. @SamiFromFrance Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Cliff Benoist |
last post by:
I have a case where I would like to add a textbox to a datagrid column
header. I would like to use a user control or custom control to create a
reusable control. The textbox will filter the results displayed in the
datagrid.
Is there a way to get at the column information of a datagrid as I described
above?
|
by: VMI |
last post by:
My Windows datagrid has two columns: one with the data that the user will
see (col_X) and the other one (a hidden one: col_sort) that'll be used to
sort data. When a user clicks on col_X's column header, I'm intercepting the
header click and "telling" it to sort the dataview using col_sort. But for
some reason, the "return" is not being executed. When I press the mouse key,
it'll sort correctly (by col_sort), but as soon as I release the...
|
by: Gas |
last post by:
Hi,
I am just wondering is there a way to add an up or down arrow in the column
header of a list view control to indicate that the row are sort by that
column?
Gas
|
by: Steve |
last post by:
I have windows form with ListView control. The ListView control has few
columns which user can sort by clicking the column header.
I want the column header have the small triangle indicator of sort order.
How can I implement that?
Thanks
|
by: DigHazuse |
last post by:
relative noob.
i'm trying to get/display the column Header name that the user clicks
to sort on the DataGrid.
I know that i could take the e.SortExpression and spin through the
Columns on the DataGrid until I found the value that matches the
e.SortExpression and then grab the Header Name ... but I keep
thinking/hoping there is an easier way. I have searched through all
the e.* possibilities hoiping to find the Index # or something...
| |
by: djohnson |
last post by:
My listview will sort but I would like the column headers to contain up
or down arrows to indicate the sort direction. I have an image on the
column header, but I'm having a heck of a time figuring out how to
programmatically change it. I can't find the property. Someone
suggested it is impossible to change the column header index in .Net
and that native Win32 API calls have to be used. Is this true? Isn't
there a more straightforward...
|
by: Gary Brown |
last post by:
Hi,
It is common to place a little triangle in a column header to indicate
both which column is sorted and the direction of sort. Setting an
image (icon) almost works but displays the icon before the text.
I want the icon after the text or, better yet, centered.
How is this done?
Thanks,
|
by: DBLWizard |
last post by:
I posted a message on the topic earlier and thought I had it solved
but in testing have found problems. I have a Templated GridView
control on a webpage bound to an ObjectDataSource. There are 3
columns that are "Sortable" That sorting works fine until I add the
dropdown with a "refresh" button into the mix. The only way that I
have found to sort the grid from the dropdown requires the following
code.
When I set the...
|
by: clarkp73 |
last post by:
Hi
In VBA I populate an unbound subform (datasheet view) via a recordset that can be changed using filters selected by the user. The only problem I am having is that due to the unbound nature of the subform the sorting function activated by the column header click only works once, the second time the user tries a sort an error occurs ("Data provider could not be initialized").
Is there any way I could handle the column header click in code...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |