Question Creating ACCDE

[xirokx]

Hi there,

Having completed my first database I wanted to let other use it so I tried creating an ACCDE and it failed.

Having gone into the visual basic part of MS Access and clicked on "compile database" I receive the following error

"Private Sub Command22_Click()
GoToPage (7,{7},{7}
)
End Sub"

What does this mean?

Having googled the message I understand it needs to be fixed, unforunately I do not know where to begin...

Please help

Cheers!!!

 

[HiTechCoach]

Try commenting out the code line to see if you can get it to comiple. Do this by placing a ' at the beginning if each line that is causing an issue.

Before you make an ACCDE, have you split your database into a front end and back end? If, Not, I would highly urge you to do so.

See:

Sharing an Access Database

Hope this helps ...

 

[xirokx]

the " ' " trick worked a treat.......tis great....


thank you very much

 

[HiTechCoach]

You''re welcome!