RE: SendKeys Problem



Tim,

I didn't see your post before putting up mine just a few minutes ago. We're
having a problem with SendKeys in Office 2003 and ours also worked in Office
97.

What exactly is happning? Is it just not working? When I step through my
code I can see that it is generating the "keys" but the timing is off. Is
that also happening to you?

"Tim" wrote:

> Hi folks,
>
> My default printer is PDFWriter. I have the following code to export my
> report to pdf format. The code is working perfect in Access 97. It gave me
> a hard time when I used in Access XP (2002). It output my report to
> c:\temp\rpt1.pdf and then it output my report again and have a pop up window
> for the file name. Could anyone tell me the way to fix it?
>
> Thanks in advance.
>
> Tim.
>
> Public Sub test()
>
> SendKeys "c:\temp\rpt1.pdf" & "{ENTER}", False
> DoCmd.OpenReport "rpt1", acViewNormal
>
> End Sub
.



Relevant Pages

  • Re: SendKeys Problem
    ... I see you are both suffering the same problem, I hate SendKeys, what I can ... >> report to pdf format. ... The code is working perfect in Access 97. ... >> Public Sub test() ...
    (microsoft.public.access.modulesdaovba)
  • SendKeys Problem
    ... report to pdf format. ... The code is working perfect in Access 97. ... It output my report to ... Public Sub test() ...
    (microsoft.public.access.modulesdaovba)
  • Re: New Ustafish Listing
    ... >Thanks Tim, ... (Jeff, the FIRST ... >port and report from now till the second Tuesday of the week. ...
    (sci.military.naval)
  • Re: Unbound field in query
    ... Tim ... "Jeff Boyce" wrote: ... >> I am trying to run a query to show certain records on a form. ... the user would select which records to exclude from the report. ...
    (microsoft.public.access.queries)
  • Re: Demon representative on committee?
    ... I suggest you report them often and frequently. ... You are the one with poo on your face for forbidding things you can't enforce. ... You *were* told your charter was unenforceable and I would not be surprised if some people tease you about it. ... You *really* should have thought more at the time, ...
    (uk.net.news.management)

Loading