[AccessD] Run stored action query

Andy Lacey andy at minstersystems.co.uk
Fri Mar 4 08:09:07 CST 2005


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




More information about the AccessD mailing list