Running VBA Code from a DataAccessPage

BastiMK · April 27th, 2006, 04:14 AM

Hello,

i want to run VBA-Code from a DataAccessPage. I placed a Button on the Page and try to run VBA-Code using VBScript. But it doesn't work. Here is the Code:

Code:

  Dim oAccess
  Set oAccess = CreateObject("Access.Application")
  oAccess.Run "Befehl0_Click"
  Set oAccess = Nothing

Someone an idea whats wrong?

Thx

Basti

peko · April 28th, 2006, 02:52 AM

Hi,
the procedure, which you call, must be public, and must be located (stored, saved) in standard module (not in module of any class (form, report, you class)).
Peko

BastiMK · June 1st, 2006, 10:10 AM

It is, but it still doesn't work.

Basti