[AccessD] Run stored action query

Rocky,

thnx for the reply. I was just about to update this
item.

I created some very simple queries:
insert;
update;
make table;

They all ran fine.

Then I checked the query and noticed an "Expr1" field.
It seems that the source file has changed and a field
I need is missing!!

Thnx for the help.

Regards,

Sander
--- Rocky Smolin - Beach Access Software
<bchacc at san.rr.com> wrote:

> Can you run the query by itself from the database
> container?  Can you see it 
> in design view and SQL view?  Can you post the SQL
> statement here?
> 
> Regards,
> 
> Rocky Smolin
> Beach Access Software
> http://www.e-z-mrp.com
> 858-259-4334
> 
> ----- Original Message ----- 
> From: "Sad Der" <accessd666 at yahoo.com>
> To: "Access Developers discussion and problem
> solving" 
> <accessd at databaseadvisors.com>
> Sent: Sunday, March 06, 2005 10:40 PM
> Subject: RE: [AccessD] Run stored action query
> 
> 
> > Hi,
> >
> > I've tried both given solutions but they both
> failed!
> > I keep getting the error:
> > ?err.Number
> > 3615
> > ?err.Description
> > Type mismatch in expression.
> >
> > Can anybody please help me on this one?
> > Thnx!
> >
> > Regards
> > Sander
> >
> >
> > --- Reuben Cummings <reuben at gfconsultants.com>
> wrote:
> >
> >> 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
> >>
> >>
> >>
> >>
> >> -- 
> >> AccessD mailing list
> >> AccessD at databaseadvisors.com
> >>
> http://databaseadvisors.com/mailman/listinfo/accessd
> >> Website: http://www.databaseadvisors.com
> >>
> >
> >
> >
> >
> >
> > __________________________________
> > 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
> > 
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 



	
		
__________________________________ 
Celebrate Yahoo!'s 10th Birthday! 
Yahoo! Netrospective: 100 Moments of the Web 
http://birthday.yahoo.com/netrospective/