Author |
Message |
zhongqin
Joined: 22 May 2008 Posts: 2 Country: United States |
|
Run Macro/Function in Access database |
|
Hi,
How can run Macro or function in an Access database? I have create database profile but don't know if
there is a command to run Macro/function.
|
|
Thu May 22, 2008 12:05 pm |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7966
|
|
|
|
Database profiles/connections are used for running SQL commands. Theoretically in Access you can call user-defined function from a SQL query, something like SELECT my_function() FROM some_dummy_table
|
|
Thu May 22, 2008 12:28 pm |
|
 |
zhongqin
Joined: 22 May 2008 Posts: 2 Country: United States |
|
|
|
It dosen't work since We have alot of DoCmd.query in the function
|
|
Thu May 22, 2008 12:58 pm |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7966
|
|
|
Thu May 22, 2008 1:21 pm |
|
 |
|