Getting TA working in MS Access 2007 & VBA

Hi all,

I'm having issues getting the VBA up and running for a system I have.

I have imported TurboActivate.bas & TurboActivate.cls both successfully.

I am looking at the online tutorial which says include this line at the start of your code:

TurboActivate.PDetsFromPath(GetTADirectory() & "/TurboActivate.dat")

I run that on the logon form in my app and I get this error:

Object Required 424.

I have done some modifications to force it to behave but to no avail, this is what I have tried:

Giving the code the actual full path & letting it add the /TurboActivate.dat:TurboActivate.PDetsFromPath ("C:\Program Files (x86)\CheckFixGo\" & "/TurboActivate.dat")Same error

Giving it the full path and assuming that the "/" is the wrong way around and should be a "\":TurboActivate.PDetsFromPath ("C:\Program Files (x86)\CheckFixGo\TurboActivate.dat")Same error

I have not been successful importing the example project the .frm or .frx files, it gives me an error that MS tried to solve on a forum a few years back but failed. I will try to import into Access 2003 on a different machine.

I'm stuck here, please help.ThanksNeo

Hey Neo,

We'll look into the importing problem you're having.

Regarding the "Object Required 424" error, this is because the documentation currently on our website is referencing the old API: https://wyday.com/limelm/help/using-turboactivate-with-vba/

We'll be updating this next week (we put off updating the documentation so we could release TA/TF 4.0 sooner).

The best place to look for a working, complete example is in the "API\VBA" folder.

1. Put TurboActivate.dll and TurboActivate.dat in that folder (from the "stdcall\x86" folder).

2. Also, from the "stdcall\x64" folder rename TurboActivate.dll to TurboActivate.x64.dll, and also move it to the same "API\VBA" folder.

3. Run the "YourVBAProject.xlam" file. That's an Excel add-in, so you'll need Excel on the machine. When prompted, click "Enable Macros", and then click the "Developer" tab in Excel. And then click the "Visual Basic" button.

This will open up the full example source code. You can see all of the "logic" code is in frmMain (right click, click "View Code").

If you don't have Excel, or you just want to view the code without the hassle of opening it in Excel, you can just open the "frmMain.frm" file in a text editor. It will should you how to correctly setup TurboActivate and make function calls.

We'll be updating the documentation next week to be much better than it is right now. I'm sorry about that.

Reply
Discard post