Re: Registering programs in access

Good afternoon Douglas,

I think I know what the problem might be! One of the first things that the
directions say is to make sure that you have the VB6 run-time files on your
machine! I cannot find vb6sys.exe on my computer.

As the directions suggested I tried going to:
http://support.microsoft.com/download/support/mslfiles/Vb6sys.exe
however, this page is no longer supported. I then spent about an hour
trying to find a way to download vb6sys.exe with no luck. Things in office
XP-Pro do not seem to be as simple as the old Office 2000.

Do you have a suggestions on where I might find this module?? I know this
may seem like a very dumb question; however, any suggestions will be
helpful. I am pretty sure that this is is my problem.

Brad


"Dr. Brad" <rbthomas@xxxxxxxxxxxxx> wrote in message
news:1dTCf.28349$H71.4976@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Thanks Douglas,
> I will work on it tomorrow. Thanks again.
>
> Brad
>
> "Douglas J. Steele" <NOSPAM_djsteele@xxxxxxxxxxxxxxxxx> wrote in message
> news:%23omybDFJGHA.532@xxxxxxxxxxxxxxxxxxxxxxx
>> Sorry, I don't know what to say.
>>
>> It worked fine for me with no changes to the sample code. In fact, I
>> copied your code into a test database, and it worked fine for me.
>>
>> 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
>>
>> Of course, you really should be declaring your variable types as Strings,
>> and there's no reason for variable Called_DB:
>>
>> Function Call_BFB_Brad(strDB As String)
>>
>> With COMAddIns("TsiSoon90.Connect").Object
>> .FileToOpen = strDB
>> .Exclusive = False
>> .FileIsAdp = False
>> .CloseAll
>> End With
>>
>> End Function
>>
>>
>>
>>
>> --
>> Doug Steele, Microsoft Access MVP
>> http://I.Am/DougSteele
>> (no private e-mails, please)
>>
>>
>> "Dr. Brad" <rbthomas@xxxxxxxxxxxxx> wrote in message
>> news:GPQCf.5233$2O6.2500@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>>> 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)
>>>>
>>
>>
>
>


.

Loading