Right-click filter

Topic

New Reply

If I open the db with the Return Key I can right-click an entry on a form and filter by form. If, however, I open the db without the Return Key this feature is disabled. I presume this is a settings issue somewhere (2007), but I can’t find it. Little help?

Reply | Quote

Replies

Did you mean the Shift key instead of the Return key?

You can view and change the startup options for the database as follows:
– Open the database with the Shift key held down.
– Click the Office button.
– Click Access Options.
– Click Current Database in the left hand pane.

Reply | Quote

Did you mean the Shift key instead of the Return key?

You can view and change the startup options for the database as follows:
– Open the database with the Shift key held down.
– Click the Office button.
– Click Access Options.
– Click Current Database in the left hand pane.

Ooops, yes I mean the Shift key and not the Return key. I did look through the options but didn’t see anything that would turn on or off the right-click functionality.

Reply | Quote

This was unchecked. All is well now. . .thanks!

Reply | Quote

I can’t open any databases in 2007 with the Return Key so I can’t investigate this properly. The Return Key opens them in 2003 on my computer.

But I can use right click filtering, and I don’t think I have done anything special to make it possible. I get a right click menu like this:

I only get it when the control is enabled.

If you don’t use the Return Key, how do you open the database? There are a number of ways of opening a database so I am wondering which method you use.

Reply | Quote

I can’t open any databases in 2007 with the Return Key so I can’t investigate this properly. The Return Key opens them in 2003 on my computer.

But I can use right click filtering, and I don’t think I have done anything special to make it possible. I get a right click menu like this:

I only get it when the control is enabled.

If you don’t use the Return Key, how do you open the database? There are a number of ways of opening a database so I am wondering which method you use.

Sorry John, I meant the Shift key, not the Return key. I hold down the Shift key and click on the db shortcut. If I don’t use the Shift key, I don’t get the menu you attached; if I do open the db with the Shift key held down, I get the menu.

Reply | Quote

Make sure that “Allow default shortcut menus” under “Toolbar Options” is ticked.

Added: too late!

Reply | Quote

Make sure that “Allow default shortcut menus” under “Toolbar Options” is ticked.

Added: too late!

Never too late. Thanks!

Reply | Quote