coding VB on reports?

  • Thread starter Thread starter Jerome
  • Start date Start date
J

Jerome

Hi there,

I've got a weird thing here. When in the Visual Basic window of Access
2000, I can edit the codes from my FORMS without problem, but when I
want to select my REPORTS I always get "Error access file. Network
connection may have been lost" ??

I'm using Access 2000 and SQL Server 2000.

Any help is appreciated,

Jerome
 
Jerome:

This problem results from a known bug that is a result of having a certain
version of the visual basic library on your system (updated after the
install of Access 2000) combined with importing an object and then closing a
db or compacting it BEFORE you do a full compile on modules.

Unfortunately, there's no known way to fix a db where this has occured,
other than to use a back up copy to replace the hosed objects.

The office 2000 Service Pack 6 fixes this problem so that it doesn't occur
again, so you should download and update your system from
www.microsoft.com/office

However, you'll have to recreate the reports via your back up copy, or if
that's not possible, then open each report and set its has module property
to false (to eliminate the link to the hose code,) and then re-add your vb.
 
Back
Top