Display the results via QBE or report

[Ian Shaw]

Hi Guys,

I need to be able to display the results of a query that is written in VBA
in the same manner that a QBE is displayed. The query needs to be updateable
also I need to sometimes have the ability to send the results of the query to
a report. Is there any code that can enable me to do this??

 

[Alex Dybenko]

Hi,
you can either set some query sql using:

currentdb.querydefs("myquery").SQL="Select ..."

and then open in using docmd.openquery

or make a datasheet form and set this query to it recordsource

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[Ian Shaw]

Thanks Mate!!


Your code does not have the ability to already exist in the database. I
have some code that shall work if the "qrytemp" query already exists but I
don't know how to check if the query exists already in the database.

The code that i use if the query exists is by using the following code:
SET qdftemp = Currentdb.Querydefs("qrytemp")
qdftemp.SQL = vsql
Docmd.openquery "qrytemp"

Is there such code that I can use to determine if a query is already being
used??

Cheers
Ian

 

[Alex Dybenko]

Hi,
here a sample code:
http://www.mvps.org/access/modules/mdl0014.htm

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com