Access 2.0 and VB

[Mark]

I am trying to write a Module that will send commands to
another application and the instructions that i have
begin with

Dim btApp As BarTender.Application

but I get an Expected: End-of-Statement error after I type
this entry in the module. The maker of the application
is telling me I need to reference the bartender
application within Access 2.0 in order to get around this.

Can someone help?

Mark-
..

 

[Alex Ivanov]

Mark,

I never had Access 2 installed, but I think this still should work, or at
least something very similar. Open any code window, then click
Tools/References. If you see your Bartender anywhere in the list, mark that
check box and hit OK. If you don't see it anywhere, click Browse and locate
its executable (exe or dll) or type library (olb,tlb) and doubleclick it and
click OK. Your reference should be set. If neither of these thinks work,
it's probably means that your Bartender is not installed properly or is not
a COM object.

BTW consider a newer version of Access. 2 is 2 old.

 

[Brian]

I am trying to write a Module that will send commands to
another application and the instructions that i have
begin with

Dim btApp As BarTender.Application

but I get an Expected: End-of-Statement error after I type
this entry in the module. The maker of the application
is telling me I need to reference the bartender
application within Access 2.0 in order to get around this.

Can someone help?

Mark-
.

I don't believe you can reference stuff in Access 2. You need to ask the
BarTender folks if the functions you want to use are available as a 16-bit
dll. When they've finished laughing, ask them for a stiff whisky instead
and go buy Office 2003.