Front End SQL Statement

Ask a Question related to Coldfusion Database Access, Design and Development.

  1. #1

    Default 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

  2. Similar Questions and Discussions

    1. 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...
    2. 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...
    3. 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
    4. [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); ...
    5. 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...
  3. #2

    Default 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

  4. #3

    Default Re: Front End SQL Statement

    how would i go about this...

    any code snippets or references? thanks!
    coryd218 Guest

  5. #4

    Default 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

  6. #5

    Default Re: Front End SQL Statement

    wow...over my head, lol.
    coryd218 Guest

Posting Permissions

  • You may not post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139