Results 1 to 12 of 12
  1. #1
    Oblivion_Creed is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Apr 2017
    Posts
    20

    cant open code view in access / vba

    For some reason the project is really broken...

    i tried to use "compact and repair" but it did nothing...

    https://drive.google.com/file/d/0Byv...ew?usp=sharing


    this is the project ^^ (too large for site upload)

    and here the things that happen:

    if i press here:

    Click image for larger version. 

Name:	Capture.jpg 
Views:	10 
Size:	73.8 KB 
ID:	30910

    that what appear (and i cannot see any part of the project):

    Click image for larger version. 

Name:	Capture.jpg 
Views:	10 
Size:	46.4 KB 
ID:	30911


    and if i press here:
    Click image for larger version. 

Name:	Capture.jpg 
Views:	10 
Size:	165.7 KB 
ID:	30912

    than i get this error:

    Click image for larger version. 

Name:	Capture.PNG 
Views:	10 
Size:	10.3 KB 
ID:	30913


    any one know what the problem can be?
    Last edited by Oblivion_Creed; 10-22-2017 at 04:04 PM.

  2. #2
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,706
    We prefer to only download a file that is presented via the tools available to you at this website. It should be a compressed .zip file.
    Did you create this project or did you download it from the internet? If from the internet or unknown, you should discard the file and assume that it is not safe, and certainly not ask us to look at it.

  3. #3
    Oblivion_Creed is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Apr 2017
    Posts
    20
    Quote Originally Posted by davegri View Post
    We prefer to only download a file that is presented via the tools available to you at this website. It should be a compressed .zip file.
    Did you create this project or did you download it from the internet? If from the internet or unknown, you should discard the file and assume that it is not safe, and certainly not ask us to look at it.
    I made that project and forgot to zip it.

    my project is larger than 2mb what can i do?

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,648
    Is the zip larger than 2mb?

    Try making a copy and removing data. Is file already smaller? Run C&R again. Does that do anything?
    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
    Oblivion_Creed is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Apr 2017
    Posts
    20
    Quote Originally Posted by June7 View Post
    Is the zip larger than 2mb?

    Try making a copy and removing data. Is file already smaller? Run C&R again. Does that do anything?
    not really but i added screen shots that might help

  6. #6
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,648
    Images don't really provide any new info. A database can become corrupted beyond repair. Do you have a working backup?
    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.

  7. #7
    Oblivion_Creed is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Apr 2017
    Posts
    20
    Quote Originally Posted by June7 View Post
    Images don't really provide any new info. A database can become corrupted beyond repair. Do you have a working backup?
    My project works except for this problem...
    I have uploaded the project here because its more than 2 mb:

    https://uploadfiles.io/y52hs

  8. #8
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,648
    I took a chance and tried to download the file. It does not download a valid accdb file. I don't know what it is downloading. If it is not a Windows compressed file, I cannot extract from it.

    I recommend Box.com for fileshare site.
    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.

  9. #9
    Oblivion_Creed is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Apr 2017
    Posts
    20
    Quote Originally Posted by June7 View Post
    I took a chance and tried to download the file. It does not download a valid accdb file. I don't know what it is downloading. If it is not a Windows compressed file, I cannot extract from it.

    I recommend Box.com for fileshare site.

    here's a drive share: https://drive.google.com/file/d/0Byv...ew?usp=sharing

  10. #10
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,648
    Yeah, code is gone. Never seen anything like this. Can only conclude corruption.
    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.

  11. #11
    John_G is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2011
    Location
    Ottawa, ON (area)
    Posts
    2,615
    Interestingly, I was able to create a new code module, put a little sub in, and it ran. I was also able to create a new form, put a command button on it, and the code (just a message box) ran.

    All your forms have the Has Code Module property set to No, and if I try to set it to Yes, I get that error.

    I agree with June7 - there is some sort of corruption.

    I can't do much testing with import/export/copy, because when I do, Access complains about the language.

  12. #12
    Oblivion_Creed is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Apr 2017
    Posts
    20
    Quote Originally Posted by John_G View Post
    Interestingly, I was able to create a new code module, put a little sub in, and it ran. I was also able to create a new form, put a command button on it, and the code (just a message box) ran.

    All your forms have the Has Code Module property set to No, and if I try to set it to Yes, I get that error.

    I agree with June7 - there is some sort of corruption.

    I can't do much testing with import/export/copy, because when I do, Access complains about the language.
    I have seen that while trying to export files only the form make problem. i wounder to my self

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

Similar Threads

  1. Replies: 7
    Last Post: 12-08-2020, 09:20 AM
  2. View VBA Code for a Report in Access 2010
    By deluxes in forum Reports
    Replies: 2
    Last Post: 12-15-2016, 03:44 PM
  3. Replies: 7
    Last Post: 08-05-2013, 10:19 AM
  4. How to access design view and VBA code
    By abrogard in forum Access
    Replies: 8
    Last Post: 03-22-2012, 05:47 PM
  5. Replies: 1
    Last Post: 12-20-2011, 08:15 PM

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