Page 1 of 2 12 LastLast
Results 1 to 15 of 24
  1. #1
    rcrobman is offline Not Expert Yet!
    Windows 10 Access 2016
    Join Date
    Apr 2011
    Location
    Toronto
    Posts
    73

    File Not Found Error in Module

    I have gotten myself into some trouble here with a Module. The image below shows that a Module called "Converted Macro - getuserinfo" cannot be found. Because of this error it seems to causes the db to fail to load other modules that are needed.
    The way I got into trouble with this issue was that I was testing letting Access convert a macro to code - which it did and created the module "Converted Macro - getuserinfo". The problem was created when in VBA I chose "Remove Converted Macro - getuserinfo " INSIDE the VBA Project Explorer If you look at the image none of the other Module actually exist BUT they were deleted from within the Access Module listing NOT by deleting the module in VBA.
    So the question is - how do I get VBA to stop looking for the file Converted Macro - getuserinfo?? Can I create a file (somehow) and place it somewhere Access can find it when it starts up?
    This has virtually killed the application as all of the included VBA functions cannot be found since the error occurs immediately on launch thereby stopping the loading of any and all Modules.
    Thanks in advance for any help!



  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    No image showing, but are you sure there isn't something trying to call that function in the form that loads first? Can you attach the db here?
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    rcrobman is offline Not Expert Yet!
    Windows 10 Access 2016
    Join Date
    Apr 2011
    Location
    Toronto
    Posts
    73
    That is weird - the image showed fine when I posted.
    Lets try again
    Click image for larger version. 

Name:	Screen Shot 2019-03-05 at 8.03.49 AM.png 
Views:	22 
Size:	90.8 KB 
ID:	37707

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Can you attach the db here? Do you get that even if you hold down the shift key while opening the db?
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    rcrobman is offline Not Expert Yet!
    Windows 10 Access 2016
    Join Date
    Apr 2011
    Location
    Toronto
    Posts
    73
    Thanks for the suggestion - if I hold down the shift key to go into dev mode it does not happen - it only happens when I open any form that makes a call to the vba which is the opening form for example. If I don't hold down the shift key it tries to load the opening form and of course it errors with the File Not Found. I suspect that when you create modules that then creates some type of file that gets called to load the modules but I don't know where those files would be or how I could fudge one to get the db to pass over the missing file. I can't post the db online as it belongs to someone else.

  6. #6
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,388
    I would try holding down the shift key when loading to avoid the error. Then rename that module to mdConvertedMacros or the like. Save, C/R and see if the error goes away.

  7. #7
    rcrobman is offline Not Expert Yet!
    Windows 10 Access 2016
    Join Date
    Apr 2011
    Location
    Toronto
    Posts
    73
    Thanks for the suggestion. Unfortunately no matter what you try to do to the Module name in VBA you get the error - since it cannot find the listed file it can't change the name or do anything else.

  8. #8
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,388
    Unfortunately no matter what you try to do to the Module name in VBA
    Can you see the module names at the bottom of the Navigation Pane (not in the VBE)? If so, try changing name there.

  9. #9
    rcrobman is offline Not Expert Yet!
    Windows 10 Access 2016
    Join Date
    Apr 2011
    Location
    Toronto
    Posts
    73
    Thanks for the reply. The image above is the bottom of the navigation pane and no you cannot do anything with the file that is giving the File Not Found error. It appears if you delete a module from within the Access object navigator it cause no issue - my issue was created when I try to delete the module in the VB navigation pane.

  10. #10
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,388
    The image above is the bottom of the navigation pane and no you cannot do anything with the file that is giving the File Not Found error.
    No, that's the VBE view. Close the vbe and you will see the Navigation Pane.

  11. #11
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    I've deleted modules from the VBE before with no problem. Can you create a new module and give it that name?
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  12. #12
    rcrobman is offline Not Expert Yet!
    Windows 10 Access 2016
    Join Date
    Apr 2011
    Location
    Toronto
    Posts
    73
    I'm sorry I don't know what you mean - can you take a screenshot of the Navigation pane you are speaking of?
    Thanks for the help!

  13. #13
    rcrobman is offline Not Expert Yet!
    Windows 10 Access 2016
    Join Date
    Apr 2011
    Location
    Toronto
    Posts
    73
    Thanks for the help! Do you mean create another module in Access or in the VBE window?

  14. #14
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,388
    can you take a screenshot of the Navigation pane you are speaking of?
    Thanks for the help!
    ALT+F11 will toggle between views...
    Click image for larger version. 

Name:	np.png 
Views:	16 
Size:	18.6 KB 
ID:	37728

  15. #15
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Quote Originally Posted by rcrobman View Post
    Thanks for the help! Do you mean create another module in Access or in the VBE window?
    One in the same. In the VBE window, Insert/Module, then save it with the old name. It's a shot in the dark, but stranger things have worked.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Page 1 of 2 12 LastLast
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Error : File not found
    By CoZak in forum Programming
    Replies: 5
    Last Post: 06-29-2018, 02:32 AM
  2. Replies: 1
    Last Post: 07-24-2015, 11:31 AM
  3. File Not Found error
    By polbit in forum Access
    Replies: 7
    Last Post: 07-10-2014, 09:54 AM
  4. Error importing Excel file re search key not found
    By pcbrush in forum Import/Export Data
    Replies: 1
    Last Post: 10-03-2013, 03:19 PM
  5. Intercepting error codes like 2220, file not found
    By justphilip2003 in forum Programming
    Replies: 4
    Last Post: 04-21-2013, 11:33 AM

Tags for this Thread

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