[AccessD] Queries with vba function inside...

David McAfee davidmcafee at gmail.com
Sat Jul 18 02:54:16 CDT 2009


Post your function and your SQL so we can take a look. :)

On Fri, Jul 17, 2009 at 8:56 AM, philippe pons <phpons at gmail.com> wrote:

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