thutmoseone
IS-IT--Management
I'm having problems creating a reference to actole.dll and act.exe in Access 2000 VBA, VB6 or Excel 2000 VBA. I get the "can't create reference to specified file" error from the references menu. Therefore when I use the createobject("actole.database"
or getobject("","actole.database" statements then reference values of database fields within the object I get a "object variable or with value not set" error because the reference was not established. Funny thing is when I have Act open to a database the createobject or getobject statements work fine and I can retrieve database field values with no problem. I need VB or VBA to open the database or application object without requiring Act to already be open. I'm I missing something. All comments welcome. Thanks.
or getobject("","actole.database" statements then reference values of database fields within the object I get a "object variable or with value not set" error because the reference was not established. Funny thing is when I have Act open to a database the createobject or getobject statements work fine and I can retrieve database field values with no problem. I need VB or VBA to open the database or application object without requiring Act to already be open. I'm I missing something. All comments welcome. Thanks.