AutoKeys??? 1

[KarloZ]

Hello everyone, I'm trying to work on using functions keys as shortcuts because the program requires the use of keyboard only. im pretty successful using F2,F3,F4,F5,F6,F8,F9,F10,F11 with the use of keypreview and keydown event . but im having problems with the default keys of access like F1, F7, F12 and other access shortcuts like when ctrl P is pressed, it shows the print window and many more...
the question is how can i disable these access shortcuts so i can use them too as my own shortcuts and so, i can assign my own combination keys like Alt+O, Ctrl+F1 without problems. please do consider that i'll be using all these functions keys and combination keys in all forms but they have to perform different actions for each form.

thank you very much in advance....

 

[Francescina]

The method you use is not useful for the re-assigning of the function keys.
You definitely need the Autokeys macro. By doing so, each keystroke will call a certain function which should check the screen.activeform and .activecontrol and trigger the desired function accordingly.
Have a look at the Online help or the ACCESS ONLINE ENCYCLOPEDIA (

http://www.unsoftwareag.com)

for details.

 

[KarloZ]

hey, you get a star! it worked! thank you i created one separate module and created a public procedures for each Functions and for all shortcuts that i will use. then each procedures test which is the active form and then execute the right function or procedure...im planning it to work for one form only then im gonna use again the keypreview and keydown for the other forms so it wont slow down the program. it worked with the trial i made. i dont know if it will create problems in the future. what do you think?

 

[Francescina]

I think that you should avoid the keypress etc. methods. Since the autokeys macro is executed application-wide you can not speed up the execution.
I use the autokeys macro since Access 2.0 (on a 80486 with 33 MHz and 32 MB RAM) and I have always been very satisfied with the performance of my apps.
Happy programming!

 

[KarloZ]

ok, i'll take the suggestion from the expert . and also you might have an idea on printing. aside from designing report using templates, are there other functions, methods of printing? coz i have this data, actually i'm doing a program for invoicing that uses small printers. the source are three tables.

table1rtMsg for the report header and footer; table2:OrdHead for the page header; and
table3: OrdDetl for the details that holds 10 fixed fields.

the problem is, access cannot join the PRTMSG table to the other two related tables becoz it has no relation to them. but i need it as a head because its part of the setting to change headers and footers. is there any way i can do it? kindly give me some idea.

again, thanks in advance..

 

[KarloZ]

i think i have a solution for my question. i used a query to get the data but right now the problem is the printing. the report is not generating a receipt that should stop printing or using the paper when it reaches the end of the record. and also, in the detail section, it includes its remaining portion before it prints the footer. so what happens is the report is long with a big blank in between detail and footer. is there a way to solve it. i badly need your help. thanks guys in advance!

apcarlos