Date format in report -may have corrupt db?

[Dophia]

Hi Again:
I am having so many problems and it seems never ending! I have a report which worked in a previous copy of my database. But now I am getting a Parameter Prompt for "Format" and "trim". What could have changed in my current version so that now the database doesn't recognize these formats? It seems that my database is corrupt since when I delete these fields on the report, I can't even open it now. When I open a previous backup, there isn't a problem.
Help!
Sophia

 

[Remou]

I think you may have lost one of the libraries. Check the references on the working copy (module window, tools, references) and see if you have something different on the 'broken' copy.

 

[Dophia]

Yes, I did check that and they are the same.

 

[Remou]

I show below a quote from Roy-Vidar regarding corruption. I did not make a note of the thread it is from, but I am sure that a back-up prior to trying any of this would have been mentioned at some point.

======================================
I keep this text, and sometimes copy/paste it for questions like this

This Corrupt Microsoft Access MDBs FAQ has a lot of info concerning corruption, symptoms and how to deal with it. MakeItSo's FAQ705-4683 also has some recommandations.

During the last years, I've resolved all my code corruption issues using the /decompile option, in stead of importing objects. It's described here
Decompile or how to reduce Microsoft Access MDB/MDE size and decrease start-up times

Here's also an option that might provide some results on exporting/importing database objects thread705-834817.
Roy-Vidar
======================================

 

[Dophia]

Thank you for your help. I'll read up on this.
Sophia