How to enable computer without VB to run VB scripts

[Jason Lim]

Dear all,

My Access database contains some VB scripts and functions.

That causes my database fail to run properly when used by computers
which are not installed with Visual Basic.

So, may I know, is there any way to solve it? Without having to
install VB in other computers. Are there any library files?

Thanks a lot for all your help.

 

[Tom van Stiphout]

On Mon, 17 Nov 2008 18:49:53 -0800 (PST), Jason Lim

Use precise language. An Access database application uses VBA, not "VB
scripts".
If a computer can successfully open an Access application, it can also
execute the VBA code of that application. No additional setup is
needed.
If a computer cannot successfully open an Access application, at least
the Runtime version of Access will have to be installed. For A2007
that's a free download.

-Tom.
Microsoft Access MVP

 

[Larry Linson]

Access' programming language is Visual Basic for Applications, which is
supported by Access and/or the Access runtime. I don't know what you have,
but you can't put Visual Basic that requires the separate installation of a
Visual Basic runtime inside an Access database. If you have recent versions
of the operating system and Access, you may be encountering permissions
problems, and might need to create a "trusted area" to contain your Access
database.

Without more specific information about what you are seeing, the error
messages, etc., I don't think anyone can be more specific in suggestions.

Larry Linson
Microsoft Office Access MVP

 

[Jason Lim]

Thanks a lot, and sorry for my language. hehe

errrm the database works fine on my computer. But when it is executed
on computer without Visual Basic, the following error messages appear
(Some forms cant be opened as well):

1) Your XYZ Database or project contains a missing or broken reference
to the file 'aAvgApi.exe' version 1.0

2) The function you entered can't be used in this expression.
* You may have used DoEvents, LBound, UBound, Spc or Tab Function
in an expression.

In some text boxes, the Default Value is set to: =Format(Now(),
"Medium Time").
But, they appear as #Name in the forms.

All that do not occur when I execute the database on my computer,
which is installed with Visual Basic.

Thanks a lot in advance..

=)

 

[Douglas J. Steele]

Your application has a reference to something that's not installed on the
users' machines.

See http://www.accessmvp.com/DJSteele/AccessReferenceErrors.html for more
information about problems with References in Access.

 

[David W. Fenton]

:

My Access database contains some VB scripts and functions.

That causes my database fail to run properly when used by
computers which are not installed with Visual Basic.

So, may I know, is there any way to solve it? Without having to
install VB in other computers. Are there any library files?

Are you perhaps getting security warnings, and scripts are blocked?
This is a matter of setting your security level or setting up
trusted locations.

 

[David W. Fenton]

Your application has a reference to something that's not installed
on the users' machines.

And it's very likely a reference you don't need. I limit my apps to
the three default references and if I need any other libraries, I
use late binding.

 

[Jason Lim]

Thanks a lot, dear friends...

=)