Should I Convert from VBA to ActiveX 1

[LonnieJohnson]

I have a lot of jobs that I run in MS Access VBA that update recordsets. Are there any books or web tutorials that help you with converting that to ActiveX? Is ActiveX even the way I want to go?

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!

 

[jabrony76]

Lonnie,

Not sure if you want to use activex scripts to accomplish this but here is a good page that lists many examples of how to accomplish things in vbscript, the language that activex controls use:

http://www.vba-programmer.com/#VBScriptBkmk

If you are using access vba now to update recordsets and developing a solution on a SQL Server platform, maybe you should take advantage of scheduled T-SQL / Stored Procedure jobs as well as Triggers.

Hope this helps.
Andy

 

[LonnieJohnson]

Thank you.

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!