Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

VBA 6.00 to 6.04

Discussion in 'Information Technology' started by roger, Nov 12, 2005.

Tags:
  1. roger

    roger
    Expand Collapse
    Guest

    Hi,

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

    thank you
     
  2. Loading...

    Similar Threads Forum Date
    India SGPC General Secretary for Appointment of 600 'dharam parcharks' Breaking News May 30, 2013
    India Bills worth Rs 1600 cr pending as Punjab’s Fiscal Woes Worsen Breaking News Feb 7, 2012
    India Indian Air Force is short of 600 pilots Breaking News Nov 1, 2010
    Sikh News Punjab farmers paid over Rs 6000 crore for wheat procurement (The Economic Times) Breaking News Apr 29, 2008
    Sikh News Punjab farmers paid over Rs 6000 cr (The Times of India) Breaking News Apr 28, 2008

  3. Tony Toews

    Tony Toews
    Expand Collapse
    Guest

    "roger" <villanue73@gmail.com> wrote:

    >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
     
  4. Van T. Dinh

    Van T. Dinh
    Expand Collapse
    Guest

    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

    --
    HTH
    Van T. Dinh
    MVP (Access)



    "roger" <villanue73@gmail.com> wrote in message
    news:1131743948.877329.294980@g44g2000cwa.googlegroups.com...
    > Hi,
    >
    > how can upgrade on MS Access 2000 from VBA 6.0 to VBA 6.04?
    >
    > thank you
    >
     
  5. roger

    roger
    Expand Collapse
    Guest

    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...


    Van T. Dinh wrote:
    > 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
    >
    > --
    > HTH
    > Van T. Dinh
    > MVP (Access)
    >
    >
    >
    > "roger" <villanue73@gmail.com> wrote in message
    > news:1131743948.877329.294980@g44g2000cwa.googlegroups.com...
    > > Hi,
    > >
    > > how can upgrade on MS Access 2000 from VBA 6.0 to VBA 6.04?
    > >
    > > thank you
    > >
     
  6. roger

    roger
    Expand Collapse
    Guest

    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...
     
  7. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    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.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    "roger" <villanue73@gmail.com> wrote in message
    news:1131982173.957438.240740@o13g2000cwo.googlegroups.com...
    > 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...
    >
    >
    > Van T. Dinh wrote:
    > > 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
    > >
    > > --
    > > HTH
    > > Van T. Dinh
    > > MVP (Access)
    > >
    > >
    > >
    > > "roger" <villanue73@gmail.com> wrote in message
    > > news:1131743948.877329.294980@g44g2000cwa.googlegroups.com...
    > > > Hi,
    > > >
    > > > how can upgrade on MS Access 2000 from VBA 6.0 to VBA 6.04?
    > > >
    > > > thank you
    > > >

    >
     
  8. Tony Toews

    Tony Toews
    Expand Collapse
    Guest

    "roger" <villanue73@gmail.com> wrote:

    >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
     

Share This Page