Results 1 to 4 of 4

Form, VBA and their associated References

  1. #1
    Sonu is offline Advanced Beginner
    Windows 7 64bit Access 2016
    Join Date
    Aug 2019
    Posts
    32

    Form, VBA and their associated References


    Hi All,

    I have a very generic question related for Form and VBA. Let say a Form is developed in a certain DB1 and then it is moved to a different DB2.

    My question is - Does while copying a Form and it's VBA code to a different DB, it's associated references (like Libraries etc.) also gets copied and replace the target DB's existing references?

    Thank You.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    48,588
    Copying/importing objects has no impact on reference libraries selected.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Mickjav is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Mar 2019
    Location
    Margate, Kent
    Posts
    99
    Quote Originally Posted by June7 View Post
    Copying/importing objects has no impact on reference libraries selected.
    Agreed also you can't import references to libraries when importing objects these will have to be reselected in the db your importing into.

    mick
    All open code examples and free projects are only available from:
    https://databasedreams.createaforum.com/index.php

  4. #4
    Sonu is offline Advanced Beginner
    Windows 7 64bit Access 2016
    Join Date
    Aug 2019
    Posts
    32
    Thank you for the answers. It helped.

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

Similar Threads

  1. How to change references in VBA
    By Beginer in forum Programming
    Replies: 13
    Last Post: 07-14-2017, 06:57 PM
  2. Replies: 8
    Last Post: 05-22-2017, 03:24 PM
  3. Replies: 5
    Last Post: 12-22-2012, 01:36 PM
  4. References
    By jessiemaske in forum Access
    Replies: 0
    Last Post: 05-30-2012, 09:33 AM
  5. Open a form using a query that references a combo
    By accessbobp646 in forum Access
    Replies: 1
    Last Post: 02-22-2009, 09:50 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
  •  
Tech Forums: Microsoft Office Forums