[AccessD] Storing SQL in VBA

Jim Lawrence accessd at shaw.ca
Tue Aug 1 11:51:52 CDT 2006


Hi Chester:

Maybe run the select query first only bringing back the keys, store the
results in a temp recordset, then run your action query and finally use the
temp recordset keys fields to reselect the records you have changed.

HTH
Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kaup, Chester
Sent: Tuesday, August 01, 2006 9:30 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Storing SQL in VBA

I was wanting to use the results of the select query.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence
Sent: Tuesday, August 01, 2006 10:48 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Storing SQL in VBA

Hi Chester:

You can get back the record count of the records you affected...is that
what
you want?

HTH
Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kaup, Chester
Sent: Tuesday, August 01, 2006 7:57 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Storing SQL in VBA

I want to store and execute an action query in VBA. Did some research
and found RunSQL will not work on action queries. The execute method
will run the action query SQL but returns no recordset. So is there a
way to store and execute an action query in VBA and then use the
results?

 

Chester Kaup

Engineering Technician

Kinder Morgan CO2 Company, LLP

Office (432) 688-3797

FAX (432) 688-3799

 

 

No trees were killed in the sending of this message. However a large
number of electrons were terribly inconvenienced.

 

-- 
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


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




More information about the AccessD mailing list