Re: Registering programs in access
- From: "Dr. Brad" <rbthomas@xxxxxxxxxxxxx>
- Date: Sat, 28 Jan 2006 17:33:38 GMT
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
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>
.
- Follow-Ups:
- Re: Registering programs in access
- From: Douglas J. Steele
- Re: Registering programs in access
- References:
- Registering programs in access
- From: Dr. Brad
- Re: Registering programs in access
- From: Douglas J. Steele
- Re: Registering programs in access
- From: Dr. Brad
- Re: Registering programs in access
- From: Douglas J. Steele
- Re: Registering programs in access
- From: Dr. Brad
- Re: Registering programs in access
- From: Dr. Brad
- Re: Registering programs in access
- From: Douglas J. Steele
- Re: Registering programs in access
- From: Dr. Brad
- Registering programs in access
- Prev by Date: Re: Registering programs in access
- Next by Date: Re: Registering programs in access
- Previous by thread: Re: Registering programs in access
- Next by thread: Re: Registering programs in access
- Index(es):
Relevant Pages
|
