Results 1 to 5 of 5
  1. #1
    maxmaggot is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2013
    Location
    Ireland
    Posts
    91

    VBA code crash before viewing problem


    I have an access db 2010 that I have due by Friday to a client. All of a sudden, any time vba code is called it pops up to say that access has crashed. I've tried decompiling the code, taking out any features that I added in the hour before it stopped working. Nothing helps. I can't even open my modules or access crashes. I'm in desperate need of help. Any suggestions.

    I've attached the file minus sensitive info. Sorry for not reading rules. In a panic to sort this.
    Last edited by maxmaggot; 06-12-2013 at 11:10 PM. Reason: add file

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    2mb zip file allowed as attachment - follow instructions at bottom of my post
    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
    maxmaggot is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2013
    Location
    Ireland
    Posts
    91
    I've now attached the file. Apologies for not reading the rules. Panicking about this.

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    I can confirm I get the same behavior, however, this is a web database and I don't know much about web database design. I did set a breakpoint and step debugged. The Login procedure ran fine until it hit:

    DoCmd.BrowseTo ObjectType:=acBrowseToForm, ObjectName:="Registration"

    I have never used BrowseTo but then, as I said, don't know much about web database.

    It also crashes if I try to manually open the Registration form. I can open it in design view. Possibly this form is corrupted. Try building a new one and deleting the original.

    I am able to manually open other forms. I do get error messages trying the filtering on the Expense form.
    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
    maxmaggot is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2013
    Location
    Ireland
    Posts
    91
    Thanks for your help. I've given up hope on it and I've being working off of a backup. For me it was the registration page that crashed too. I was adding relationships to the Funds page which broke web compatibility and then it died on me. I'm new to this web database but I want to load it to a sharepoint server when finished to operate as web pages. Thanks for your time and effort. You got further than me with trying to solve it.

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

Similar Threads

  1. Code problem
    By sboelitz in forum Programming
    Replies: 1
    Last Post: 06-15-2012, 08:35 AM
  2. Problem with Code
    By jackiea in forum Programming
    Replies: 1
    Last Post: 10-07-2011, 05:59 PM
  3. Code Problem
    By Jeddell in forum Programming
    Replies: 2
    Last Post: 09-29-2011, 06:31 PM
  4. Access 2.0 Viewing Code
    By wollydog in forum Access
    Replies: 0
    Last Post: 12-03-2008, 07:50 AM
  5. Problem with Code
    By cujee75 in forum Programming
    Replies: 0
    Last Post: 03-10-2006, 02:40 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