DLL to create task in scheduler - cannot create component

[Pat]

A97, WinXP
Hello,
I am looking for a way to create a task (in the windows task scheduler) from
an Access MDB using VBA. I found this great DLL:

http://www.mtogden.com/~tom/files/Sc...ngAgentVB6.zip

However, when I test it with a basic example:

Dim jb as CJob
For Each jb In TaskScheduler.Jobs '*****
Debug.Print jb.Name
Next jb

Access returns Error 429: Activex Component Cannot Create Object on the line
marked with '*****. I've got a reference to the dll, and ActiveX 2.1
Library (even tried up to 2.7).

Can anyone shed some light on what I'm missing?
Many thanks - as always!
Pat

[TC]

Maybe show us the code that instantiates the object?

TC
"Pat" <pa*@noemail.ihatespam.bum> wrote in message
news:uP*****************@twister.austin.rr.com...

A97, WinXP
Hello,
I am looking for a way to create a task (in the windows task scheduler) from an Access MDB using VBA. I found this great DLL:

http://www.mtogden.com/~tom/files/Sc...ngAgentVB6.zip

However, when I test it with a basic example:

Dim jb as CJob
For Each jb In TaskScheduler.Jobs '*****
Debug.Print jb.Name
Next jb

Access returns Error 429: Activex Component Cannot Create Object on the line marked with '*****. I've got a reference to the dll, and ActiveX 2.1
Library (even tried up to 2.7).

Can anyone shed some light on what I'm missing?
Many thanks - as always!
Pat

[Pat]

TC,
Thanks for the reply. The supporting documentation had the following info:

The TaskScheduler Object

The TaskScheduler object is a global object. It is created
automatically the first time you reference it in your code.

Just tried the same code below in A2K with no probs.
Pat

"TC" <a@b.c.d> wrote in message news:1068177369.556431@teuthos...

Maybe show us the code that instantiates the object?

TC
"Pat" <pa*@noemail.ihatespam.bum> wrote in message
news:uP*****************@twister.austin.rr.com...

A97, WinXP
Hello,
I am looking for a way to create a task (in the windows task scheduler)

from

an Access MDB using VBA. I found this great DLL:

http://www.mtogden.com/~tom/files/Sc...ngAgentVB6.zip

However, when I test it with a basic example:

Dim jb as CJob
For Each jb In TaskScheduler.Jobs '*****
Debug.Print jb.Name
Next jb

Access returns Error 429: Activex Component Cannot Create Object on the

line

marked with '*****. I've got a reference to the dll, and ActiveX 2.1
Library (even tried up to 2.7).

Can anyone shed some light on what I'm missing?
Many thanks - as always!
Pat

[TC]

I imagine you need to create the TaskScheduler object using the New keyword
or the CreateObject statement. Check the documentation that came with the
DLL.

HTH,
TC

Pat <pa*@noemail.ihatespam.bum> wrote in message
news:uP*****************@twister.austin.rr.com...

A97, WinXP
Hello,
I am looking for a way to create a task (in the windows task scheduler) from an Access MDB using VBA. I found this great DLL:

http://www.mtogden.com/~tom/files/Sc...ngAgentVB6.zip

However, when I test it with a basic example:

Dim jb as CJob
For Each jb In TaskScheduler.Jobs '*****
Debug.Print jb.Name
Next jb

Access returns Error 429: Activex Component Cannot Create Object on the line marked with '*****. I've got a reference to the dll, and ActiveX 2.1
Library (even tried up to 2.7).

Can anyone shed some light on what I'm missing?
Many thanks - as always!
Pat