Access Query Desgnr & Report Wizard via Macros/VB6/.Net Code

[UniverseTN]

Is it possible to start QD or RW from macros/vb6/.Net independent of the
whole Access application?

[If you can please email: (e-mail address removed)]

Thanks!

 

[Steve Schapel]

UniverseTN,

As far as I know, this is not possible.

 

[UniverseTN]

I just heard that I might be able to use the Access macro 'RunCommand'*
bring up say for instance Query Designer. Do you think that's possble? Also
where can I get a listing of all the Access macro and VBA keywords.

*replaces the old 'MenuItem' macro keyword

Thanks so far!

(e-mail address removed) [please continue to email this address if possible]

UniverseTN,

As far as I know, this is not possible.

--
Steve Schapel, Microsoft Access MVP

Is it possible to start QD or RW from macros/vb6/.Net independent of the
whole Access application?

[If you can please email: (e-mail address removed)]

Thanks!

 

[Steve Schapel]

Well, if you're using a macro, then you need to have Access running and
a database file open, so it's not independent of Acvess, is it? Unless
I have misunderstood your question.

I am not sure how RunCommand action can open the query designer. You
can use the OpenQuery action in a macro to open a query in design view.

By the way, RunCommand has been part of Access macros for at least 10 years.

 

[Brendan Reynolds]

A good resource for information about RunCommand constants is ...
http://home.clara.net/tkwickenden/

--
Brendan Reynolds (MVP)

I just heard that I might be able to use the Access macro 'RunCommand'*
bring up say for instance Query Designer. Do you think that's possble?
Also
where can I get a listing of all the Access macro and VBA keywords.

*replaces the old 'MenuItem' macro keyword

Thanks so far!

(e-mail address removed) [please continue to email this address if
possible]

UniverseTN,

As far as I know, this is not possible.

--
Steve Schapel, Microsoft Access MVP

Is it possible to start QD or RW from macros/vb6/.Net independent of
the
whole Access application?

[If you can please email: (e-mail address removed)]

Thanks!

 

[UniverseTN]

You're correct about 'RunCommand'.

However in recent Knowledge, and, or Office documentation rather then use
macro keyword 'RunCommand', it's suggested to use the new alternative Access
maco keyword, 'DoCmd'.

As I understand from the above docs, the 'DoCmd' can for instance invoke
'MenuItem.View.Database Objects.Report'.

I hear you about the requirement for Access to be running in order to invoke
Access macro keywords.

If you, or anyone can point me to on-line Microsoft explaining the plethora
of Access macro keywords, I'd much appreciative.

Thanks for the prompt responses!

Elliiott

 

[Steve Schapel]

Elliott

Just to clarify, DoCmd has nothing to do with macros. This is an object
you can use in a VBA procedure.

I see that Brendan has pointed you to a site for help with RunCommand
constants. Sorry, I know of no comprehensive source of information
about macro actions. The Access Help files are very good, though. If
you open the macro design window, and select each Action one by one
(there are 53 of them), and press F1, you will get some good info.