[AccessD] Queries with vba function inside...

philippe pons phpons at gmail.com
Fri Jul 17 10:56:18 CDT 2009


Thank's Drew.
We tried with DAO, but it seems we get the same result.
We decided not to use function in queries.
Philippe

2009/7/17 Drew Wutka <DWUTKA at marlow.com>

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