Phucon
I'm glad I could help. And please call me "Bill". we are not very formal around here.
Bill
--- In MS_Access_Professionals@yahoogroups.com, "saigonf7q5" <saigonf7q5@...> wrote:
>
>
> Good moring Mr. Mosca
>
> Thank you so much sir. That works! I have repeatedly open and close the reports again and again, so far so good, but afraid it's going to do that (crash) again. I am wondering if it's because my query caused it to crash. I hope it's not, reconstructing the query is tough...
>
> Anyway thanks lot again.
>
> Phucon
>
> --- In MS_Access_Professionals@yahoogroups.com, "Bill Mosca" <wrmosca@> wrote:
> >
> > Phucon
> >
> > The first thing I would do is import everything into a new, blank database and compact it. If that doesn't fix your report issue you might have to break your query down into a few sub queries.
> >
> > Regards,
> > Bill Mosca, Founder - MS_Access_Professionals
> > http://www.thatlldoit.com
> > Microsoft Office Access MVP
> > https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E
> > My nothing-to-do-with-Access blog
> > http://wrmosca.wordpress.com
> >
> >
> >
> > --- In MS_Access_Professionals@yahoogroups.com, "saigonf7q5" <saigonf7q5@> wrote:
> > >
> > > I have a couple of reports, 8 out of 10 times when the report is open (default open in Print Preview), it crashes (pops up a dialog box saying that "Microsoft Office Access has encountered a problem and needs to close… Please tell Microsoft about this problem.") and closes the database, especially when the reports were open by double clicking on the report icon in the navigation pane. It did the same thing when the report was open from a command button in a form.
> > >
> > > I have noted that, it seems to be OK when open the report by right clicking on the report icon in the navigation pane, then select `Open' on the short cut menu.
> > >
> > > What causes it crashed? Hopefully is not caused by the query (the query is a kind of complicated) that I created.
> > >
> > > Phucon
> > >
> >
>
Tidak ada komentar:
Posting Komentar