Call parameter query in Access from Excel VBA?
I've prepared a query in Access that calculates a number that I want to display in Excel, using VBA and ADO. Here's the query in Access:
PARAMETERS [p_month] DateTime; SELECT Count(*) AS [Number] FROM (SELECT DISTINCT Occupancy.PersonID FROM Occupancy WHERE (((Occupancy.Month)=[p_month])) ) AS [Table]; So, the query accepts a parameter and returns a value. Because it's just a value, I figure I won't need to construct a recordset object. All examples I've seen so far returns a recordset, but I hope to make this simple and fast. How would you call this query from VBA and how do you extract the return value? Gustaf |
Call parameter query in Access from Excel VBA?
Not that familiar with Acess, but most likely you could do this be adding an
"out" parameter to your procedure. http://groups.google.com/group/micro...4f98c5257ffa54 Tim "Gustaf" wrote in message ... I've prepared a query in Access that calculates a number that I want to display in Excel, using VBA and ADO. Here's the query in Access: PARAMETERS [p_month] DateTime; SELECT Count(*) AS [Number] FROM (SELECT DISTINCT Occupancy.PersonID FROM Occupancy WHERE (((Occupancy.Month)=[p_month])) ) AS [Table]; So, the query accepts a parameter and returns a value. Because it's just a value, I figure I won't need to construct a recordset object. All examples I've seen so far returns a recordset, but I hope to make this simple and fast. How would you call this query from VBA and how do you extract the return value? Gustaf |
All times are GMT +1. The time now is 09:45 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com