Results 1 to 6 of 6
  1. #1
    CoZak is offline Advanced Beginner
    Windows 10 Access 2010 64bit
    Join Date
    May 2018
    Posts
    33

    Error : File not found

    Hello,

    I have an error "File not found" in my database that probably comes from a corrupt Access Class Object called Form_q_calculate_qty
    Whenever I try to run VBA code it pops up "Error : File not found" even though the code itself works perfectly and the module and Access Class Object can be found perfectly
    I cannot understand how to fix that and I cannot delete the apparently "corrupt" Access Class Object/Module
    I ve looked online but I havent been able to find a workaround yet... This has taken me so much time so I was wondering if any of you guys had an idea

    Thanks in advance...

    Link .zip attached Road_Marking_Database_45_disaster.zip


    Try pressing the browse elexar or import elexar button

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,525
    "File not found" is not a form. it is a file.
    can you open the form manually?
    is there code in the form?

  3. #3
    CoZak is offline Advanced Beginner
    Windows 10 Access 2010 64bit
    Join Date
    May 2018
    Posts
    33
    I can open the form called form_calculate_qty but it s a subform, there is no code in it which annoys me even more. But it might not be the original form_calculate_qty, i might have renamed the subform like this
    Click image for larger version. 

Name:	error.jpg 
Views:	7 
Size:	172.8 KB 
ID:	34586It s its code ("module"? that i cannot open and makes everything not work, even the other code (i think) Click image for larger version. 

Name:	error 2.jpg 
Views:	7 
Size:	142.9 KB 
ID:	34587

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    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.

  5. #5
    CoZak is offline Advanced Beginner
    Windows 10 Access 2010 64bit
    Join Date
    May 2018
    Posts
    33
    Nope didnt work either,
    I tried the built in Compact and Repair but it changed nothing
    Click image for larger version. 

Name:	sfgasfg.jpg 
Views:	5 
Size:	149.1 KB 
ID:	34593

  6. #6
    CoZak is offline Advanced Beginner
    Windows 10 Access 2010 64bit
    Join Date
    May 2018
    Posts
    33
    Ok so for someone that could have the same problem the "workaround" i found is that since you cant access the form's code to delete it or the Access Class Object etc, delete the whole module and then import it again if you have a backup..
    Otherwise no idea how to fix it
    I m never deleted unused forms again anymore

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

Similar Threads

  1. Replies: 1
    Last Post: 07-24-2015, 11:31 AM
  2. File Not Found error
    By polbit in forum Access
    Replies: 7
    Last Post: 07-10-2014, 09:54 AM
  3. 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
  4. Intercepting error codes like 2220, file not found
    By justphilip2003 in forum Programming
    Replies: 4
    Last Post: 04-21-2013, 11:33 AM
  5. "File Not Found" error
    By jgelpi16 in forum Programming
    Replies: 5
    Last Post: 04-21-2011, 10:17 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