SendKeys problem

[Mike]

I want to be able to open the printer popup screen while a report is on
the screen.

I would like to have a button on one of the menus that sends the
"control P" combination.

In the past, I used a macro with SendKeys and ^P as the key
combinations. This seemed to work in the past but does not now. I have
changed to XP operating system but I would not think this is the
problem though I am using Access2000.

I have read the documentation and tried all sorts of combinations
unsuccessfully.

Would like advice on how to send a control P using Sndkeys.
Thanks for the help in advance.

[Jan Jørgensen]

"Mike" <mf***@aol.com> skrev i en meddelelse
news:11**********************@z14g2000cwz.googlegr oups.com...

I want to be able to open the printer popup screen while a report is on
the screen.

I would like to have a button on one of the menus that sends the
"control P" combination.

In the past, I used a macro with SendKeys and ^P as the key
combinations. This seemed to work in the past but does not now. I have
changed to XP operating system but I would not think this is the
problem though I am using Access2000.

I have read the documentation and tried all sorts of combinations
unsuccessfully.

Would like advice on how to send a control P using Sndkeys.
Thanks for the help in advance.

Check in the menu what your actual shortcuts are ..... mine are in danish
!!!! :-)
SendKeys "%{F}" ' Send ALT + F for File Menu
SendKeys "{æ}" ' Danish for Page-setup

Jan

[Jan Jørgensen]

"Jan Jørgensen" <xx***@pc.dk (fjern xx)> skrev i en meddelelse
news:42*********************@dread11.news.tele.dk. ..

"Mike" <mf***@aol.com> skrev i en meddelelse
news:11**********************@z14g2000cwz.googlegr oups.com...

I want to be able to open the printer popup screen while a report is on
the screen.

I would like to have a button on one of the menus that sends the
"control P" combination.

In the past, I used a macro with SendKeys and ^P as the key
combinations. This seemed to work in the past but does not now. I have
changed to XP operating system but I would not think this is the
problem though I am using Access2000.

I have read the documentation and tried all sorts of combinations
unsuccessfully.

Would like advice on how to send a control P using Sndkeys.
Thanks for the help in advance.

Check in the menu what your actual shortcuts are ..... mine are in danish
!!!! :-)
SendKeys "%{F}" ' Send ALT + F for File Menu
SendKeys "{æ}" ' Danish for Page-setup

Jan

Guessing that they would be :
SendKeys "%{F}" ' Send ALT + F for File Menu
SendKeys "{p}" ' Page-setup

:-)
Jan

[Mike]

Incredible. Thanks for the help.

[Mike]

Thanks for the help.

[Jim Allensworth]

SendKeys really ought to be avoided unless absolutely necessary.

For what you want there is a RunCommand method - acCmdPrint.
From a procedure call it like...

DoCmd.RunCommand acCmdPrint

- Jim

On 5 Mar 2005 15:09:10 -0800, "Mike" <mf***@aol.com> wrote:

I want to be able to open the printer popup screen while a report is on
the screen.

I would like to have a button on one of the menus that sends the
"control P" combination.

In the past, I used a macro with SendKeys and ^P as the key
combinations. This seemed to work in the past but does not now. I have
changed to XP operating system but I would not think this is the
problem though I am using Access2000.

I have read the documentation and tried all sorts of combinations
unsuccessfully.

Would like advice on how to send a control P using Sndkeys.
Thanks for the help in advance.