Well, not even knowing what the heck a showcase query is, all I can say is that the Shell function doesn't like spaces in paths so you have to surround the thing in double-quotes like this:
varODDone = Shell(Chr(34) & "DriveName:\path...\Open Demand based off SO # rev A.dbq" & Chr(34))
But you might have to include the program's path as well. I'm not sure if the extension is mapped to it or not. If you need to include the program put it first and surround it with double-quotes as well with a space between the 2 paths.
Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile/Bill.Mosca
--- In MS_Access_Professionals@yahoogroups.com, <liz_ravenwood@...> wrote:
>
> Pros, does anyone know how to run a showcase query from VBA? This is my
> latest attempt:
>
> dim varODDone as variant
>
> varODDone = Shell("DriveName:\path...\Open Demand based off SO # rev
> A.dbq")
>
> Respectfully,
> Liz Ravenwood
> Programmer/Analyst
> Super First Class Division
> BE Aerospace, Inc.
> (O): 1.520.239.4808
> E-Mail: Liz_Ravenwood@...
> www.beaerospace.com
>
>
>
>
> ----------------------------------------------------------
>
> This email (and all attachments) is for the sole use of the intended
> recipient(s) and may contain privileged and/or proprietary information.
> Any unauthorized review, use, disclosure or distribution is prohibited. If
> you are not the intended recipient, please contact the sender by reply
> e-mail and destroy all copies of the original message.
>
> [Non-text portions of this message have been removed]
>
Tidak ada komentar:
Posting Komentar