M
Mike
So, I've been working hard at learning Microsoft Access and have made pretty
nifty tools to help do my job better. I've started writting some VBA and
custom functions. I want to make one of my queries a little more dynamic,
edit some of the filter without actually going into the 'design query' view.
So, of course I started using the DoCmd.RunSQL - made sense, worked for a
bunch of simple SQL stuff. I got this error saying my query (which I copied
from SQL View) isn't valid... so... I popped into VS2005 and started to
rebuild the SQL query with its fancy GUI interface... they're not the same at
all. So, I'm guessing its safe to assume that Access SQL isn't the same as
'real' SQL - yes?
The thing is, my Access queries have several calculated fields, using custom
functions I wrote in VBA... can SQL call VBA functions in an application? Is
there a method? Or am I SOL?
Thanks!
Mike
nifty tools to help do my job better. I've started writting some VBA and
custom functions. I want to make one of my queries a little more dynamic,
edit some of the filter without actually going into the 'design query' view.
So, of course I started using the DoCmd.RunSQL - made sense, worked for a
bunch of simple SQL stuff. I got this error saying my query (which I copied
from SQL View) isn't valid... so... I popped into VS2005 and started to
rebuild the SQL query with its fancy GUI interface... they're not the same at
all. So, I'm guessing its safe to assume that Access SQL isn't the same as
'real' SQL - yes?
The thing is, my Access queries have several calculated fields, using custom
functions I wrote in VBA... can SQL call VBA functions in an application? Is
there a method? Or am I SOL?
Thanks!
Mike