[AccessD] Run stored action query

You should be able to use

Docmd.OpenQuery("queryname")

You may also want to use "docmd.setwarnings False" before the query and
"docmd.setwarnings True" after the query so the user doesn't have to answer
the prompts about adding, editing, or deleting records associated with
action queries.



Reuben Cummings
GFC, LLC
phone: 812.523.1017
email: reuben at gfconsultants.com


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Andy Lacey
Sent: Friday, March 04, 2005 9:09 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Run stored action query


Hi Sander

Dim db as Database
Dim qdf as Querydef

Set db = CurrentDb
Set qdf=db.Querydefs("xxxxquery")
qdf.Execute

set qdf = nothing
set db = nothing

HTH

--
Andy Lacey
http://www.minstersystems.co.uk



--------- Original Message --------
From: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
To: Acces User Group <accessd at databaseadvisors.com>
Subject: [AccessD] Run stored action query
Date: 04/03/05 14:24

>
> Hi group,
>
> how do I run a stored action query using VBA?
> I'm using A2K.
>
> I know how to run a select query. I tried the same for
> my action query but Access didn't like that :-(
>
> TIA
>
> Sander
>
>
>
>
>
> __________________________________
> Celebrate Yahoo!'s 10th Birthday!
> Yahoo! Netrospective: 100 Moments of the Web
> http://birthday.yahoo.com/netrospective/
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
>
>
>

________________________________________________
Message sent using UebiMiau 2.7.2

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com