VBA 6.00 to 6.04

[roger]

Hi,

how can upgrade on MS Access 2000 from VBA 6.0 to VBA 6.04?

thank you

 

[Tony Toews]

how can upgrade on MS Access 2000 from VBA 6.0 to VBA 6.04?

Why would you want to? What problems are you trying to fix? What
are you using to determine the VBA version numbers?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Van T. Dinh]

Since VBA is only part of the Access "package", I would suggest that trying
to upgrade one component of Access by itself is not the safe way to go.

Suggest you try the Office Update site (link followed) and let the Office
Update works it out for you.

http://office.microsoft.com/officeupdate/default.aspx

 

[roger]

Hi,

The reasoin is that i'm running a mail merge and ms access 2000 is
using VBA 6.00 but it shoudl be vba 6.04, otherwise i get an error:
undefined function replace...

I've checked all other computers and all of them have vba 6.04 on
microsoft access...

 

[roger]

Hi,

The reasoin is that i'm running a mail merge and ms access 2000 is
using VBA 6.00 but it shoudl be vba 6.04, otherwise i get an error:
undefined function replace...

I've checked all other computers and all of them have vba 6.04 on
microsoft access...

 

[Douglas J Steele]

Have you applied all of the Office 2000 service packs to the machine?

As Van suggests, that's the only supported way to update the version of VBA.

 

[Tony Toews]

The reasoin is that i'm running a mail merge and ms access 2000 is
using VBA 6.00 but it shoudl be vba 6.04, otherwise i get an error:
undefined function replace...

Now this is interesting. When I run A2000, go to the VBA IDE, click
on Help then About I get version 6.3. Ah, that's likely because I
have A2002 and A2003 installed on my system.

Like Doug states ensure that system is up to date on the Office
service packs.

However I think your problem lies elsewhere and has to do with your
references.

Do you have any references besides the basic three? Are you sure you
need them? Write down the path and name of the extra ones, delete
from the references list and Compile and Save All. Keep any
necessary references and ensure they are distributed to the target
system.

For a very detailed page on reference problems see
http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html

Ctrl+G will take you into the Debug/Immediate window. Then click on
Tools on the menu bar and References.

The Access 2000 default references are:
Visual Basic for Applications
Microsoft Access 9.0 Object Library
OLE Automation
Microsoft ActiveX Data Objects 2.1 Library
or
Microsoft DAO 3.6 Object Library

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[jacobean]

Hi,

The reasoin is that i'm running a mail merge and ms access 2000 is
using VBA 6.00 but it shoudl be vba 6.04, otherwise i get an error:
undefined function replace...

I've checked all other computers and all of them have vba 6.04 on
microsoft access...

I searched all over the place to get this stupid simple answer.

Replace C:\Program Files\Common Files\Microsoft
Shared\VBA\VBA6\VBE6.DLL created 9/19/2000 6:56 PM (VBA6.0)
with the one created 7/3/2003 4:19 PM (VBA6.04).

You can get 6.04 here -
http://www.microsoft.com/downloads/...BA-CD3D-458B-9729-AB9094C9BD3F&displaylang=en

VBA 6.0 did not include the functions FormatCurrency(),
FormatDateTime(), FormatNumber(), FormatPercent(), InStrRev(),
MonthName(), Replace(), Round(), StrReverse() and WeekdayName()