Can't save form as..error msg

[RipperT]

I am trying to save an existing form as another form with a new name but
every time I click OK I get error msg:

File not found: 'C:\DOCUME~1\SmithSR\LOCALS~1\Temp\VB32.tmp'

Click OK and:

Name conflicts with existing module, object or project library.
What do these mean and how do I fix them?

Thanks,

Ripper

 

[TonyT]

what name are you trying to save the form under?

TonyT

 

[RipperT]

I've tried many different names. Same error; varying numbers in the
VB32.tmp. Always VBxx.tmp.

Thanks,

R

 

[TonyT]

If the name itself isn't the problem, then what code are you using to save
the form, or are you just pressing the Save As icon?

The wording of the error message makes it sound like you might have a
function or public sub using reserved words that are causing the issue.

Do you have any code that references that particular file or folder that the
error message generates?

Of course it could be that the database is corrupt or mis-compiled. Do a
search on here for corrupt database to see the many and varies methods of
recovery depending on your version of Access.

 

[RipperT]

If the name itself isn't the problem, then what code are you using to save
the form, or are you just pressing the Save As icon?

Right clicking on the form and choosing Save As...

The wording of the error message makes it sound like you might have a
function or public sub using reserved words that are causing the issue.

Will check for reserved words.

Do you have any code that references that particular file or folder that
the
error message generates?

Will check this also.

Of course it could be that the database is corrupt or mis-compiled. Do a
search on here for corrupt database to see the many and varies methods of
recovery depending on your version of Access.

Recently re-compiled using \compile switch.

This happened once before (sometime around last June) and each time I tried
to Save As, one of these .tmp files was written to the parent folder of
where the .mdb resides. Opening the files in Notepad, they were just copies
of all the code in the form looking much like it does in the VBA editor. I
couldn't figure it out, so I just moved to a different machine where it
behaved properly. I am now trying it on two machines and the misbehavior is
identical, except the .tmp files are not being saved anywhere that I can
see.

Thanks again,

Ripper

 

[TonyT]

It's a common way to recover a corrupt form or database to copy the code out
of the form, compile it empty and then paste it back in and re-compile. Any
chance someone has coded something to do this automatically and it's failing
for some reason, like clash of wording? Maybe a search for anything in vba
containing the string saveas?

It's more common to use the decompile switch outside of visual basic and
then to compile within the vba editor, and this will show you where if
anywhere the compile is failing.

 

[RipperT]

After further experimentation, I am not convinced it is corruption because:

It appears to have happened to 7 different front end files at pretty much
the same time (there is nothing wrong with the back end).
The error occurs only on certain workstations on our network.
The behavior is identical on respective workstations, whether using one of
the 7 front-end files or creating new db's; using a custom workgroup file or
the default workgroup file.
All front and back ends (development and production) continue to function
properly, presenting no error messages.

This suggests to me that it is a VBA or Jet issue, or something else
specific to the workstation. I am working to see that the latest versions
and all service packs are installed. I think that will help narrow down the
cause. I would appreciate any further thoughts anyone might have...

Ripper