DISABLE printing by Ctrl-P
in [Forms]
|
From: aw on 19 May 2010 00:04 How can I DISABLE the printing function (under current report) by pressing Ctrl-P. Actually I would like to allow printing ONLY by pressing my 'print' button that have already placed control. -- aw
From: tony on 19 May 2010 06:15 On 19 May, 05:04, aw <a...(a)discussions.microsoft.com> wrote: > How can I DISABLE the printing function (under current report) by pressing > Ctrl-P. > > Actually I would like to allow printing ONLY by pressing my 'print' button > that have already placed control. > > -- > aw Create a macro called AutoKeys (the name is very important). Make sure in the design view of the macro you can see the title Macro Name and in this field enter ^P and save it (just that and nothing else). Now when the database is opened it should have effectively disabled the keystoke Ctrl+P. Hope this helps.
From: david on 20 May 2010 03:23 However, the menu shortcut keystrokes which take you to the same place will still exist. We last tried this many years ago, and at the time it was not possible to alternate access keys. (david) "tony" <tony.atack(a)googlemail.com> wrote in message news:0b718e94-d931-4c78-b407-0a419fe80f8b(a)q8g2000vbm.googlegroups.com... On 19 May, 05:04, aw <a...(a)discussions.microsoft.com> wrote: > How can I DISABLE the printing function (under current report) by pressing > Ctrl-P. > > Actually I would like to allow printing ONLY by pressing my 'print' button > that have already placed control. > > -- > aw Create a macro called AutoKeys (the name is very important). Make sure in the design view of the macro you can see the title Macro Name and in this field enter ^P and save it (just that and nothing else). Now when the database is opened it should have effectively disabled the keystoke Ctrl+P. Hope this helps.
From: tony on 20 May 2010 06:49 On 20 May, 08:23, "david" <da...(a)nospam.au> wrote: > However, the menu shortcut keystrokes which take you to the > same place will still exist. We last tried this many years ago, > and at the time it was not possible to alternate access keys. > > (david) > > "tony" <tony.at...(a)googlemail.com> wrote in message > > news:0b718e94-d931-4c78-b407-0a419fe80f8b(a)q8g2000vbm.googlegroups.com... > On 19 May, 05:04, aw <a...(a)discussions.microsoft.com> wrote: > > > How can I DISABLE the printing function (under current report) by pressing > > Ctrl-P. > > > Actually I would like to allow printing ONLY by pressing my 'print' button > > that have already placed control. > > > -- > > aw > > Create a macro called AutoKeys (the name is very important). > > Make sure in the design view of the macro you can see the title Macro > Name and in this field enter ^P and save it (just that and nothing > else). > > Now when the database is opened it should have effectively disabled > the keystoke Ctrl+P. > > Hope this helps. Hi David, Not entirely sure what you mean by 'the menu shortcut keystrokes' but if you mean the user can still use the menu options then the answer to this would be to disable the menu as well. You can do this in 2007 under the options, current database, ribbon and toolbar options and unticking Allow Full Menus. I pretty sure you can do something similar in earlier versions. Opening the database by holding down the shift key renables the menus.
From: david on 20 May 2010 08:30 I have not tested this in any current version. Autokeys does not have a key combination for ALT P In report preview mode, ALT P brings up the print dialog. (david) "tony" <tony.atack(a)googlemail.com> wrote in message news:bfbbe19e-1823-44c7-9bfd-ac358f10961d(a)v37g2000vbv.googlegroups.com... > On 20 May, 08:23, "david" <da...(a)nospam.au> wrote: >> However, the menu shortcut keystrokes which take you to the >> same place will still exist. We last tried this many years ago, >> and at the time it was not possible to alternate access keys. >> >> (david) >> >> "tony" <tony.at...(a)googlemail.com> wrote in message >> >> news:0b718e94-d931-4c78-b407-0a419fe80f8b(a)q8g2000vbm.googlegroups.com... >> On 19 May, 05:04, aw <a...(a)discussions.microsoft.com> wrote: >> >> > How can I DISABLE the printing function (under current report) by >> > pressing >> > Ctrl-P. >> >> > Actually I would like to allow printing ONLY by pressing my 'print' >> > button >> > that have already placed control. >> >> > -- >> > aw >> >> Create a macro called AutoKeys (the name is very important). >> >> Make sure in the design view of the macro you can see the title Macro >> Name and in this field enter ^P and save it (just that and nothing >> else). >> >> Now when the database is opened it should have effectively disabled >> the keystoke Ctrl+P. >> >> Hope this helps. > > Hi David, > > Not entirely sure what you mean by 'the menu shortcut keystrokes' but > if you mean the user can still use the menu options then the answer to > this would be to disable the menu as well. > > You can do this in 2007 under the options, current database, ribbon > and toolbar options and unticking Allow Full Menus. I pretty sure you > can do something similar in earlier versions. Opening the database by > holding down the shift key renables the menus.
|
Pages: 1 Prev: =Len(Nz(Me.txtAuthor, 0)) is returning 1 even when the field is blank ! Next: Actioning Icon |