runtime error 75 when I run the application for second time

D

divya

Hello.

I have a worksheet in which I have a button which call the foll macro
Private Sub cmdCases_Click()
Load frmCases
frmCases.Show vbModal
End Sub

When I open the worksheet for the first time, everything
works fine. However, when I exit the above code, and
then reopen the worksheet, I get the following VB errors:


"Path/File Access Error", and
"Run-Time Error 75, Cannot find the specified object"


When I hit the DEBUG button, the "Load frmcases" is
highlighted (see code, above).

can anybody help


Thanks!
 
I

Irina

You should unload frmCases to load it again.
May be, you only hide it, but not unload?
 
D

divya

hii,
This is the application which worked fines since so many years and
was used extensively by every body here .Now a days it gives this eroor
sometimes Runtime 75 and sometimes 1004, few Machines it works fine and
few machines it doesn't.it shows different behaviour on different
machines gives different error on different machines>i"m working on it
with what u said <but i don"t want to meddle with the code , thnx for
ure help.will let u know .

Regards
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top