I am using access a lot these days, and try to use keyboard shortcuts where possible (leave that mouse alone....), so does anyone know a way to get to the FILTER menu when viewing a form using the keyboard...i.e without having to right click on the field and then click in the FILTER FOR box.
In more detail, the form looks like a table, and I may want to filter on one field, then sub-filter on another etc.....
Then also a shortcut to REMOVE the filters would be good too.....
If I have to create buttons on the form with code behind that ok.
I am trying to build a simple form to add data to a table. One of the fields on the table is for Shortcuts to other documents held on the server / computer, but I can't seem to be able to either paste or add a shortcut to the relevant field in the Form.
Am I trying to do something which can't be done or am I missing something ?
I hope this is the right forum for such a question, if not I apologize in advance.
I have an application that is being used by six people. When the newest version of it was built, I altered the desktop shortcut on everyone's PC to point to the newest version. Four of these shortcuts still work, but two are behaving somewhat erratically.
In the case of these two, clicking on the shortcut sometimes opens the older version of the application. I have recreated the shortcuts and they work for a while, before reverting to the older link. Going to the application via Explorer works fine.
While I am getting more comfortable with VBA, this area is outside anything I know. Could someone advise me on what affects whether shortcuts work or not? Do they automatically 'refresh'? If so, when?
In case it's relevant, everyone here is using the same versions of both XP and Access and everyone has access to the same drives.
I'm beginning to think it is a windows issue and not access issue. I have a couple of users that weren't able to click on the form shortcuts on thier desktop. They had been able to use them earlier in the day, but later double clicking them would not bring up Access. I had them use Window's explorer and try to click on the MDB file to bring up access, but that also didn't work. But launching Access directly, then open existing files, would open up the database for them.
Rebooting let them use the shortcuts.
Any idea what might cause this? They have been using the application for a couple of months without mishap until today.
Has anyone seen this behaviour before. If so, how did you fix it?
Ok this is a weird issue that has been troubling me, On some computers that I have, Access refuses to open databases through a shortcut. The only way to open any databases is to first open access the go to file open.
I've tried creating new shortcuts, as well as mapping a drive and making a shortcut from there...but nothing is working. Is there a setting that access has to preven this? The same database can be opened on different computer without a hitch....
Is there a way to prevent users from making a shortcut to a database? I have my database split and I want users to copy the front end and paste it on their desktop. However, there is a high turnover rate among the people who will be using this database. As a result, I'm concerned that the instructions to copy and paste the database may not be passed along. I would like to avoid the possibility of someone making a shortcut to this database.
I would also like to prevent users from relocating the database by inadvertently dragging and dropping it in a new folder.The only person who should be able to move the database or work directly in the master copy of the front end is the person designated at the "admin" in my Users table (that would be myself and one other person). Is any of this possible?
I have form which looks the same as a keyboard, I am trying to figure out if the user clicks on the buttons, lets say A then S and so on, it will update the text box above it with AS and so on
I have a user who can't operate a mouse and I want to make it possible for him to select from an option group using only the keyboard.This is possible if a default button is stipulated, but can it be done when there is no default?
There is no event associated with the keyboard in an option group, only with the controls within it. I tried using the Got Focus event on an option Button, but entering the control doesn't cause the options to receive the focus, seemingly.
Any ideas, (they don't have to be fully formed) would be gratefully accepted.
I am using access 2010 and I created couple of buttons on my forms that do some stuff in vba, but beside triger them with mouse I would also like my users to be able to have shortcuts on keyboard so for example I have btnClose an I widh when user press ALT + that btnClose do the same thing as it is doing when you press mouse on it.
i want that when i press the space key on my keyboard oi will exit from the form. i searched on the interne t but i couldn't find the proper one. I don't know exactly what i have to write in vba.
Is there anyway to bring up the on screen keypad or on screen keyboard from Access when running Windows 8 on the desktop? It would really be useful if someone was on a tablet wanting to input data in a text box if could automatically invoke the onscreen keyboard. By default when running applications on the desktop in Windows 8, one has to manually bring it up. I would like to include a touch option so every time wanted to enter data, they would not have to manually touch display keyboard option. A number pad like in excel for iPad would be even better. If text field would bring up keyboard, if number field, it would bring up number pad.
Is there a keyboard shortcut that simulates the double click.
In my Sectionfrm I have a command button that opens my Ordersfrm. Because I use the Ordersfrm for reasons not always associated with the Sectionfrm I do not automatically populate the SectionID (textbox) in the Ordersfrm with the SectionID from the Sectionfrm.
When I want to link an order to a (building) section I double click the SectionID field in the Ordersfrm which in turn runs VBA code that copies the SectionID from the Sectionfrm to the Ordersfrm.
As I tab through my form I find it annoying to move away from my keyboard to the mouse to double click the SectionID, so the question is:
Is there a keyboard shortcut that simulates the double click to run the VBA code?
I'm looking for a keyboard shortcut to expand the columns in "design view" of a query.
What I mean by this is rather than selecting all of the columns and double clicking to see the entire text, I'd like to be able to a shortcut.
The entire process as I see it involves 3 steps so I will need thesolution to the 3rd step.
(1) [ctrl+spacebar] to select initial column (2) [shift+arrows] to select all of the columns I need (3) [keyboard shortcut] will expand all of the columns "field" names to the size of the column heading
Alternatively, if you know of a shortcut that will expand the columns without having to select them first I'll take it!!