Results 1 to 5 of 5
  1. #1
    Gene is offline Novice
    Windows XP Access 2000
    Join Date
    May 2009
    Posts
    7

    Access Form will not debug

    I have written a very simple VBA application that is supposed to generate a report form a table. I have done this hundreds of times, but this one has got me stumped. It will not generate the report or let me see the report. I don't get any warning or error messages. The weirdest thing is, I can't debug it. I set break points on the Load event, of the Click event for the button I use to generate the report. Nothing will break It just sits there making me look stupid.



    I moved the database to another machine and still does the same thing.

    Does anyone have a clue as to what might be happening?

    Thanks in advance.

    Gene

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Have you tried opening the db while holding down a <SHIFT> key?

  3. #3
    Gene is offline Novice
    Windows XP Access 2000
    Join Date
    May 2009
    Posts
    7

    Thanks!!!

    Not that I am complaining, but do you know why that worked? Is it a Access 2003 thing? Or is it just magic?

    Gene

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    It is just magic...my specialty.

  5. #5
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Just kidding! When you open while holding down a <SHIFT> key you bypass all of the startup options. I suspect you have a few boxes unchecked in Tools>Startup...

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

Similar Threads

  1. Is There a Way to Debug or Step Through VB code?
    By jeffbase34 in forum Programming
    Replies: 1
    Last Post: 05-28-2009, 08:14 PM
  2. Updating SQL server form Access form?
    By slash75 in forum Forms
    Replies: 1
    Last Post: 09-06-2008, 02:39 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