Drew Wutka
DWUTKA at Marlow.com
Fri Jul 17 10:40:27 CDT 2009
With ADO, you cannot run a query with an Internal VBA function. That is because ADO is not running Access, it is just querying JET. If you run DAO, then yes, you can use VBA functions in your query, because DAO is going to access the Access features, along with JET. That's probably over simplified. Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of philippe pons Sent: Friday, July 17, 2009 6:18 AM To: Access Developers discussion and problem solving Subject: [AccessD] Queries with vba function inside... Hi all, I need your help, if you mind! I have a select query that uses a vba function in one field. another one uses an integrated function like formatpercent. I need to use these queries from within Excel, using an ADODB command object. I get an error message saying that both functions, vba and integrated, are not recognized. (error 3085 function not defined in the expression) I'm afraid it's not possible to use this kind of queries like that. Would you confirm? Are there any tricks?? I further question: How would you trigger from Excel, a public function that is in access? Thank's in advance, Philippe -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com The information contained in this transmission is intended only for the person or entity to which it is addressed and may contain II-VI Proprietary and/or II-VI Business Sensitive material. If you are not the intended recipient, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. You are notified that any review, retransmission, copying, disclosure, dissemination, or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited.