Results 1 to 5 of 5
  1. #1
    krag is offline Medium experience
    Windows 7 32bit Access 2013
    Join Date
    May 2014
    Posts
    75

    Question Different VBA versions matter?

    I am working between 2 PCs, one is with VBA 7.1.1042 (Japanese Win 7, Access 2013)


    Other is VBA 7.1.1038 (English Win 7, Access 2013)
    VBA program made on 1038 version ran OK in 1042.
    But other way round, from 1042 to 1038, error message that macro or event procedure is not recognized.
    In design view, there is no problem to open the modules from the form.
    Anybody had similar issue?
    I suspect version number matters and unable to figure out how to update the version from 1038 to 1042.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,549
    Not that I've used different languages of Access, BUT, I get errors due VBA hitting an exotic object.
    One was an email .dll that didnt exist on the other PC. This gives false errors in the code..like: "RIGHT(word,1) is not a function." Bull#@%, Because it is.
    So check the vba, TOOLS, REFERENCES, and make sure no items are MISSING.

  3. #3
    krag is offline Medium experience
    Windows 7 32bit Access 2013
    Join Date
    May 2014
    Posts
    75
    I have checked for any missing items but all seems ok.
    I have to test run the program in debug mode again and see if it really is executing from event procedure.
    Perhaps it is not recognizing the event procedure due to language.
    Tks for yr advice anyhow.

  4. #4
    krag is offline Medium experience
    Windows 7 32bit Access 2013
    Join Date
    May 2014
    Posts
    75

    Question Not running the vba program

    With debug mode, I found out today that the database is not even opening the VBA program and stopping with the message as attached.
    This message is same with any of the on-click event procedures in the form.
    I am unable to figure out the relation of OLE server or active X control mentioned in the message.
    Hope some one can help me out to get over this problem.
    I have asked my partner working on the english version to try update the active X control and see if it resolves the issue.
    Attached Files Attached Files

  5. #5
    hapm is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2014
    Posts
    197
    Tried to recompile the modules using the vba editor?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Synchronisation with various versions
    By asearle in forum Access
    Replies: 0
    Last Post: 03-24-2012, 02:08 AM
  2. Problem Using Two Versions
    By cgolds in forum Reports
    Replies: 4
    Last Post: 03-22-2012, 03:17 PM
  3. only prints the same query - no matter what i have open
    By RedGoneWILD in forum Programming
    Replies: 9
    Last Post: 08-31-2010, 10:47 AM
  4. Replies: 5
    Last Post: 08-10-2010, 02:57 PM
  5. Does it Matter? Pulling fields in a query
    By Canadiangal in forum Access
    Replies: 1
    Last Post: 10-01-2009, 01:53 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums