Køre en Access makro via VBScript

Are we talking ASP?

Ja enten ASP eller VBScript client-scripting

I would think that the easiest way is to make a query in Access and then call the query from your ASP. This example performs a function in Access. I NEVER use macros.

In Access You make a query named MyQry

Something like this:
SELECT MyFunction() as theFunc;

THis calles the function which you place in a module

Function MyFunction() as Boolean

.Do what you want.....

  MyFunction = True

End Function

In your ASP you need to call the query, I will leave your ASP up to you but the SQL will look something like this:

sSQL = \"SELECT theFunc from myQry\"

Hope thats easy enoug hto understand.

SKAL bruge makro

rune_c> You CAN run a macro from the function. But then you have closed the question, so I will keep that to myself!