Coding for shortcut keys
in [Forms]
|
From: Rose B on 21 Apr 2010 14:01 I have an Access application that was written by someone else (in Access 2003) which has a form with various checkboxes on. The checkboxes can be set to true/false by using some shortcuts - for example Alt + P. The user wants a new checkbox to be added, with a new shortcut to toggle the setting. The problem I have is that I cannot see how the shortcut actions have been done! I can find no customised ribbons, VBA attached to the form and/or controls on the form, macros etc. etc. Can anyone help????
From: Beetle on 21 Apr 2010 14:52 If you look at the file extension for the application in question, is it .mdb or .mde? -- _________ Sean Bailey "Rose B" wrote: > I have an Access application that was written by someone else (in Access > 2003) which has a form with various checkboxes on. The checkboxes can be set > to true/false by using some shortcuts - for example Alt + P. The user wants a > new checkbox to be added, with a new shortcut to toggle the setting. The > problem I have is that I cannot see how the shortcut actions have been done! > I can find no customised ribbons, VBA attached to the form and/or controls on > the form, macros etc. etc. > > Can anyone help????
From: Rose B on 21 Apr 2010 15:00 mdb - I have full access to the design of the form, and have also searched through the VBA code "Beetle" wrote: > If you look at the file extension for the application in question, > is it .mdb or .mde? > -- > _________ > > Sean Bailey > > > "Rose B" wrote: > > > I have an Access application that was written by someone else (in Access > > 2003) which has a form with various checkboxes on. The checkboxes can be set > > to true/false by using some shortcuts - for example Alt + P. The user wants a > > new checkbox to be added, with a new shortcut to toggle the setting. The > > problem I have is that I cannot see how the shortcut actions have been done! > > I can find no customised ribbons, VBA attached to the form and/or controls on > > the form, macros etc. etc. > > > > Can anyone help????
From: Peter Hibbs on 21 Apr 2010 17:54 Rose, I believe you are describing the built-in short cut facilities of Access (and every other Windows program for that matter) where the ALT key can be used as a short-cut operation. To create a short cut for a control (usually a button) you just precede the relevant letter in the label with the ampersand character. So if you have a button (or Check box) which has the caption (or attached label) showing as, say, Print, if you insert the ampersand character before the caption text so that it now shows &Print the letter P will be underlined and when the user presses ALT + P the code attached to the button will be executed. If your extra Check box has a label you can just insert the ampersand before a letter in the label (that has not been used elsewhere on the form) and then pressing the ALT key plus the letter will toggle the Check box. Does that fix the problem? Peter Hibbs. On Wed, 21 Apr 2010 12:00:01 -0700, Rose B <RoseB(a)discussions.microsoft.com> wrote: >mdb - I have full access to the design of the form, and have also searched >through the VBA code > >"Beetle" wrote: > >> If you look at the file extension for the application in question, >> is it .mdb or .mde? >> -- >> _________ >> >> Sean Bailey >> >> >> "Rose B" wrote: >> >> > I have an Access application that was written by someone else (in Access >> > 2003) which has a form with various checkboxes on. The checkboxes can be set >> > to true/false by using some shortcuts - for example Alt + P. The user wants a >> > new checkbox to be added, with a new shortcut to toggle the setting. The >> > problem I have is that I cannot see how the shortcut actions have been done! >> > I can find no customised ribbons, VBA attached to the form and/or controls on >> > the form, macros etc. etc. >> > >> > Can anyone help????
From: Rose B on 22 Apr 2010 02:37
Peter, as ever.... you are BRILLIANT!!! I had looked at just about every property of the form and of the checkbox.... but hadn't thought of looking at the label! Never come across this before - another one for my tool box. Thanks, Rose "Peter Hibbs" wrote: > Rose, > > I believe you are describing the built-in short cut facilities of > Access (and every other Windows program for that matter) where the ALT > key can be used as a short-cut operation. > > To create a short cut for a control (usually a button) you just > precede the relevant letter in the label with the ampersand character. > So if you have a button (or Check box) which has the caption (or > attached label) showing as, say, Print, if you insert the ampersand > character before the caption text so that it now shows &Print the > letter P will be underlined and when the user presses ALT + P the code > attached to the button will be executed. > > If your extra Check box has a label you can just insert the ampersand > before a letter in the label (that has not been used elsewhere on the > form) and then pressing the ALT key plus the letter will toggle the > Check box. > > Does that fix the problem? > > Peter Hibbs. > > On Wed, 21 Apr 2010 12:00:01 -0700, Rose B > <RoseB(a)discussions.microsoft.com> wrote: > > >mdb - I have full access to the design of the form, and have also searched > >through the VBA code > > > >"Beetle" wrote: > > > >> If you look at the file extension for the application in question, > >> is it .mdb or .mde? > >> -- > >> _________ > >> > >> Sean Bailey > >> > >> > >> "Rose B" wrote: > >> > >> > I have an Access application that was written by someone else (in Access > >> > 2003) which has a form with various checkboxes on. The checkboxes can be set > >> > to true/false by using some shortcuts - for example Alt + P. The user wants a > >> > new checkbox to be added, with a new shortcut to toggle the setting. The > >> > problem I have is that I cannot see how the shortcut actions have been done! > >> > I can find no customised ribbons, VBA attached to the form and/or controls on > >> > the form, macros etc. etc. > >> > > >> > Can anyone help???? > . > |