Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ADP will not Save after VBA compile!

Status
Not open for further replies.

DonoLee

IS-IT--Management
Sep 22, 2003
2
ZA
Hi

I hope someone can point me in a useful direction, have done quite a bit of searching and not having much luck...

I have and Access Project (ADP) 2000 version, running on Windows XP, Office XP.

This is the problem:
I open the project in Access and then open my VBA Code window, run a Debug > Compile and then try and Save after it has compiled. I get the following message "The Save operation failed.".

On trying to close the Access Project I get the message above again and then another message "Access could not save your project." with the option to either close, and lose any changes, or keep Access open. I select the Exit option and on then reopen the project, only to find that my VBA modules (ALL VBA Code) have vanished from the project.

I have tried this on several XP machines and experienced the same problem. I tried it on a Windows 2k machine with Office XP installed, and it doesn't happen.

Any ideas will be HUGELY appreciated!!!
Donovan
 
Hi

Solved this problem, was due to duplicated names on a few public functions and subs.

Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top