Re: Registering programs in access

Hi Douglas,
I did and I got the same results! I also reregisered "TsiSoon90.dll". I
recieved the same error
" Run-time Error 91: Object variable or With block variable not set." It
hangs on the first statment within the With block (i.e..FileToOpen =
"c:\db1.mdb"). If I take that ststement out, it hangs on the next statement
etc.

It seem to me that it wants me to Define an Object; Though, I do not know
what object Object.

Brad

"Douglas J. Steele" <NOSPAM_djsteele@xxxxxxxxxxxxxxxxx> wrote in message
news:%23EgIp0DJGHA.3696@xxxxxxxxxxxxxxxxxxxxxxx
> Just as a test, create a new database strictly to test TSISoon.
>
> If it works, try importing all of the objects from your existing database
> into a new one.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no private e-mails, please)
>
>
> "Dr. Brad" <rbthomas@xxxxxxxxxxxxx> wrote in message
> news:SVNCf.5164$2O6.669@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>> Yes I did registered the DLL, using regsvr32.exe. I allways compile when
>> I make a change.
>>
>> Brad
>>
>> "Dr. Brad" <rbthomas@xxxxxxxxxxxxx> wrote in message
>> news:5SNCf.5163$2O6.271@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>>> OK. I will see. I am running a program developed in Access 2000. If
>>> that matters.
>>>
>>> Brad
>>> "Douglas J. Steele" <NOSPAM_djsteele@xxxxxxxxxxxxxxxxx> wrote in message
>>> news:ualqzTCJGHA.2628@xxxxxxxxxxxxxxxxxxxxxxx
>>>> You did say you registered the DLL, using regsvr32.exe, didn't you?
>>>>
>>>> I'd never used MichKa's utility before your question (although I was
>>>> aware of it), and all I did was register it and use the code I pasted
>>>> and it worked.
>>>>
>>>> Try compiling your application, in case there's an unrelated problem
>>>> that's causing that line to fail.
>>>>
>>>> --
>>>> Doug Steele, Microsoft Access MVP
>>>> http://I.Am/DougSteele
>>>> (no private e-mails, please)
>>>>
>>>>
>>>> "Dr. Brad" <rbthomas@xxxxxxxxxxxxx> wrote in message
>>>> news:_eMCf.22681$F_3.6552@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>>>>> Well, I've tried everything I can think of this morning! Everything
>>>>> looks okay; however, when I attempt to execute the With block I am
>>>>> getting " Run-time Error 91: Object variable or With block variable
>>>>> not set." I do not know what this means nor it is Help any use to me.
>>>>>
>>>>> Any suggestions??
>>>>>
>>>>> Brad
>>>>>
>>>>>
>>>>> "Dr. Brad" <rbthomas@xxxxxxxxxxxxx> wrote in message
>>>>> news:LtLCf.22665$F_3.3409@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>>>>>> Thank you Douglas,
>>>>>>
>>>>>> I guess you are telling me that if I register the program with
>>>>>> Windows 2003, Access 2003 will find it. I have noticed that when I
>>>>>> open a Module I can check the References. Sure enough TSISoon is
>>>>>> present and checked.
>>>>>>
>>>>>> Because this system is so critical to me (I wrote it for my wife to
>>>>>> use with her Fuller Brush business and all I heard was loud noises
>>>>>> when she tried to use it.) I was hoping that if it ran on Access 2000
>>>>>> it would automatically convert OK to access 2003. Because I open
>>>>>> several databases from a control database I developed a common
>>>>>> function:
>>>>>>
>>>>>> Function Call_BFB_Brad(strDB)
>>>>>> Dim Called_DB
>>>>>> 'Create text string containing "Database to Call".
>>>>>> Called_DB = strDB
>>>>>>
>>>>>> With COMAddIns("TsiSoon90.Connect").Object
>>>>>> .FileToOpen = Called_DB
>>>>>> .Exclusive = False
>>>>>> .FileIsAdp = False
>>>>>> .CloseAll
>>>>>> End With
>>>>>> End Function
>>>>>>
>>>>>> And I passed the parameter strDB to it.
>>>>>>
>>>>>> Thank you for your help. Now that I know it will work, I will play
>>>>>> around and see what may be the problem. Thanks again!
>>>>>>
>>>>>> Brad
>>>>>> "Douglas J. Steele" <NOSPAM_djsteele@xxxxxxxxxxxxxxxxx> wrote in
>>>>>> message news:uEuRtSBJGHA.3144@xxxxxxxxxxxxxxxxxxxxxxx
>>>>>>>I can confirm that TSISoon works with Access 2003.
>>>>>>>
>>>>>>> There's no need to add a reference to it or anything: all you need
>>>>>>> do is follow the Access 2000 instructions that come with the DLL.
>>>>>>>
>>>>>>> 1) Register the dll with regsvr32.exe
>>>>>>> 2) Use the following code to run the ComAddIn's capabilities:
>>>>>>>
>>>>>>> With COMAddIns("TsiSoon90.Connect").Object
>>>>>>> .FileToOpen = "c:\db1.mdb"
>>>>>>> .Exclusive = False
>>>>>>> .FileIsAdp = False
>>>>>>> .CloseAll
>>>>>>> End With
>>>>>>>
>>>>>>> --
>>>>>>> Doug Steele, Microsoft Access MVP
>>>>>>> http://I.Am/DougSteele
>>>>>>> (no private e-mails, please)
>>>>>>>
>>>>>>>
>>>>>>> "Dr. Brad" <rbthomas@xxxxxxxxxxxxx> wrote in message
>>>>>>> news:LsKCf.14946$_S7.12845@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>>>>>>>> By "register different programs for the system," I mean "Make known
>>>>>>>> to an Access database." For several years I have been using a
>>>>>>>> module "TsiSoon90.dll" developed by Michael Kaplan. I thought I
>>>>>>>> would see if it could be used by access 2003.
>>>>>>>>
>>>>>>>> To use this module I usually registered it with Windows by using
>>>>>>>> regsvr32.exe. And then in access 2000 there was an option under
>>>>>>>> Tools that allowed me to make this program known to access 2000.
>>>>>>>> With Windows 2003 I registered it with regsvr32.exe; however, I
>>>>>>>> cannot find any place in access 2003 to reference this module.
>>>>>>>>
>>>>>>>> Of course I could recode the processes in each database; however, I
>>>>>>>> would prefer using "TsiSoon90.dll" also there may be other modules
>>>>>>>> that I need to access. I don't know what modules are currently
>>>>>>>> being used by my databases. (With Access 2000 "under Tools" I used
>>>>>>>> to be able to look at the various modules a given database was
>>>>>>>> using.)
>>>>>>>>
>>>>>>>> Any suggestions??
>>>>>>>> Brad
>>>>>>>>
>>>>>>>>
>>>>>>>> "Douglas J. Steele" <NOSPAM_djsteele@xxxxxxxxxxxxxxxxx> wrote in
>>>>>>>> message news:O1Yu9S4IGHA.2896@xxxxxxxxxxxxxxxxxxxxxxx
>>>>>>>>> What do you mean by "register different programs for the system"
>>>>>>>>> using Access?
>>>>>>>>>
>>>>>>>>> --
>>>>>>>>> Doug Steele, Microsoft Access MVP
>>>>>>>>> http://I.Am/DougSteele
>>>>>>>>> (no private e-mails, please)
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> "Dr. Brad" <rbthomas@xxxxxxxxxxxxx> wrote in message
>>>>>>>>> news:uqtCf.4540$2O6.4101@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>>>>>>>>>> Good morning,
>>>>>>>>>>
>>>>>>>>>> I was using access 2000. I am now using access 2003. In 2000 I
>>>>>>>>>> could register different programs for the system. How do I do
>>>>>>>>>> this in 2003?? I cannot find out how to see the programs that are
>>>>>>>>>> registered??
>>>>>>>>>>
>>>>>>>>>> Thank you.
>>>>>>>>>> Brad
>>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>


.

Loading