MS Access Project Explorer showing New Icon and Crashing with Errors

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Gordon Sanderson
    #1

    MS Access Project Explorer showing New Icon and Crashing with Errors

    I have been working with for two days on a database with no
    problems(changi ng forms and adding code to the forms and a module).
    Shut down last night was fine, with no errors generated.

    This morning, I opened the database and I started getting the dialog
    "MSACCESS.e xe has generated errors and will be closed by Windows. You
    will need to restart the program. An error log is being created."
    with an OK button. Access shuts down.

    If I open the database again, and click on my first form that pops up,
    I get the error. If I don't click the form, I can access the Access
    menus, however.

    If I go to the VBA code, I can view code for all my forms. I can
    enter new code (ie comments), but once I enter the built-in function
    MsgBox( the error occurs again. I can enter user-made functions
    without incident.

    I notice that a new icon is in the Project Explorer. It looks like a
    form, but clicking it causes an error. The icon looks like the logo
    from a printout. It looks like a small sheet of paper with blue
    border and blue horizontal lines with the top right corner turned down
    and a bit of light blue on the top right corner.

    This icon is different from the form icons, and it located right under
    the form icons but before the Modules. I have a form named
    Form_frmPricing Report. This new icon has the name frmPricingRepor t.
    Obviously, they are somehow connected, but I don't know how.

    I have tried to compact and repair the database several times with no
    change. I have tried to use the /decompile hack, to no avail (when I
    run this through a batch program, the database starts and immediately
    gives me the error message above.)

    Also, when I attempt Debug > Compile in VBA I get the error.

    Any ideas as to what the new icon is and how to rescue the database?

    Thanks,
    Gordon Sanderson
    gordon22@texas. net
    Tags: None
    • Gordon Sanderson
      #2
      Re: MS Access Project Explorer showing New Icon and Crashing with Errors

      Please disregard the following message. If anyone knows what that
      symbol means in front of my form, I'd like to know, however. I did not
      find the answer to repairing the database, but I copied the updated
      forms and code to a backup copy of the database. The new database and
      forms are working fine now.

      Thanks,
      Gordon Sanderson


      gordon22@texas. net (Gordon Sanderson) wrote in message news:<52ea3dc1. 0404141056.2bf0 2ced@posting.go ogle.com>...[color=blue]
      > I have been working with for two days on a database with no
      > problems(changi ng forms and adding code to the forms and a module).
      > Shut down last night was fine, with no errors generated.
      >
      > This morning, I opened the database and I started getting the dialog
      > "MSACCESS.e xe has generated errors and will be closed by Windows. You
      > will need to restart the program. An error log is being created."
      > with an OK button. Access shuts down.
      >
      > If I open the database again, and click on my first form that pops up,
      > I get the error. If I don't click the form, I can access the Access
      > menus, however.
      >
      > If I go to the VBA code, I can view code for all my forms. I can
      > enter new code (ie comments), but once I enter the built-in function
      > MsgBox( the error occurs again. I can enter user-made functions
      > without incident.
      >
      > I notice that a new icon is in the Project Explorer. It looks like a
      > form, but clicking it causes an error. The icon looks like the logo
      > from a printout. It looks like a small sheet of paper with blue
      > border and blue horizontal lines with the top right corner turned down
      > and a bit of light blue on the top right corner.
      >
      > This icon is different from the form icons, and it located right under
      > the form icons but before the Modules. I have a form named
      > Form_frmPricing Report. This new icon has the name frmPricingRepor t.
      > Obviously, they are somehow connected, but I don't know how.
      >
      > I have tried to compact and repair the database several times with no
      > change. I have tried to use the /decompile hack, to no avail (when I
      > run this through a batch program, the database starts and immediately
      > gives me the error message above.)
      >
      > Also, when I attempt Debug > Compile in VBA I get the error.
      >
      > Any ideas as to what the new icon is and how to rescue the database?
      >
      > Thanks,
      > Gordon Sanderson
      > gordon22@texas. net[/color]

        Comment

        Previous template Next
        Working...