Ask a Question related to Coldfusion Database Access, Design and Development.
-
coryd218 #1
Front End SQL Statement
Does anyone know a SQL statement that can run a macro or a module within ACCESS?
-or-
A CF Command/Tag that can run a macro or module within access via a front end?
Any help on this is greatly appreciated. Thanks.
coryd218 Guest
-
Enlarge the front of a car?
I have a shot of a car that is almost coming directly at the viewer. You can actually see the side of the car, but very slightly. I would like to be... -
Minus Front
I hope this isn't an overly stupid question, but how do I "minus front" in AI 11.0? In 9.0 and 10.0, there's a command in the Pathfinder palette... -
pdf allways on front
hello i can open a pdf with an Activex or xtra in director. But all the other objects are allways behind to the pdf. thank you -
[PHP] trying to match the front and end...
On 08 August 2003 15:39, Dan Joseph wrote: $middlenum = preg_replace("/^${this->start_num}(.*)${this->end_num}$/", '$1', $this->ach_acct_num); ... -
IE5 or Front Panel ?????
Gang, We have a machine running Solaris 2.6 on which I installed Internet Explorer 5. I install it as root and it runs fine. It starts by... -
philh #2
Re: Front End SQL Statement
You can't access those objects through SQL. You have to instantiate the Access object in CFSCRIPT, or call a script/executable with CFEXECUTE that does the same.
HTH,
philh Guest
-
coryd218 #3
Re: Front End SQL Statement
how would i go about this...
any code snippets or references? thanks!
coryd218 Guest
-
philh #4
Re: Front End SQL Statement
A. From a Google Group thread:
I had a good long search on the MSDN library documentation and came to the
conclusion that for Macros and Module functions, you will have to use the
COM Object Model.
eg.
Set pobjAccess = CreateObject("Access.Application")
With pobjAccess
(etc.)
B. The Access object model reference is at msdn.microsoft.com. According to
what I've read, they provide a pretty picture of the object model, but you have
to have the Access help file (.chm), included with the install, to get the
meat and potatoes.
Good luck,
philh Guest
-



Reply With Quote

