Results 1 to 4 of 4
  1. #1
    Lorlai is offline Competent Performer
    Windows Vista Access 2007
    Join Date
    Jun 2011
    Posts
    107

    Works in one database, not a new one


    I have some vba code that I have been carefully combining the last month and a half. I finally had it all working perfectly and need to transfer it to a new blank database that I am building. When I copied it over, however, it no longer works! I copied it in line by line, there is no difference at all. How on earth can it work at one point, and then not work at all in a new database?

    Any advice is greatly appreciated!

  2. #2
    jgelpi16 is offline Expert
    Windows XP Access 2010 32bit
    Join Date
    Mar 2010
    Location
    Charlotte, NC
    Posts
    544
    Instead of literally copying the code I would import the module in which you developed the code the same way you import a table or query. If that doesn't work make sure your reference libraries are the same in both databases (Tools -> Refrences...).

  3. #3
    Lorlai is offline Competent Performer
    Windows Vista Access 2007
    Join Date
    Jun 2011
    Posts
    107
    Just kidding, I feel like a total bumkin, I forgot to check and make sure all of my object references were checked. Everything works now!

  4. #4
    jgelpi16 is offline Expert
    Windows XP Access 2010 32bit
    Join Date
    Mar 2010
    Location
    Charlotte, NC
    Posts
    544
    Hey, sometimes it's the simple things! Glad you figured it out.

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

Similar Threads

  1. One works, the other doesn't. Why?
    By oleBucky in forum Queries
    Replies: 6
    Last Post: 05-09-2011, 01:52 PM
  2. Can someone explain how this works?
    By daveofgv in forum Access
    Replies: 3
    Last Post: 04-23-2011, 09:59 AM
  3. db: some records works other not...
    By bobrock4 in forum Access
    Replies: 1
    Last Post: 12-16-2010, 09:17 AM
  4. Ensuring Everything Works...?
    By catat in forum Access
    Replies: 1
    Last Post: 03-31-2010, 01:44 PM
  5. Import from MS Works
    By jerald in forum Import/Export Data
    Replies: 0
    Last Post: 03-17-2009, 08:00 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