Reports not showing anything

[Dest2KO]

Hi,

I fixed this problem some time ago but I can't remember exactly how I did it. I think I may have started a new program from scratch. I don't really do this much -- mostly as a side thing when people need it within the company since I can code a bit. Anyways, we just converted one of the employees' system from an old Access (97 or 2000) to 2003. Strangely, the report she uses now displays no information whatsoever. It has all the columns listing the data type typically displayed and whatnot, but it just doesn't fill out. No code has been changed before or after the development of the program. None of the SQL code in the criteria rows has been altered. It stopped working when she upgraded the version, which was done after obtaining a new computer from the company (Core2Duo+Vista) and copying all her old files to it.

This seems like it could be a very common problem. Any suggestions?




Thanks,
Richard

 

[MagicMan]

You could try compact and repair on the database. You could also try doing a compile of the project. If this is a fe/be environment, make sure the be is linked properly. Many many reasons for no data, but I have taken too many previous versions of Access databases and convert them fine to Access 2007.

 

[Dest2KO]

Surprisingly, it turned out to be syntactical. Old versions had used ASCII piping characters in the Criteria rows succeeding the Like statement that pulls strings from the queries. For some reason the new version wasn't liking it, and likes lots of ampersands!

 

[MagicMan]

Glad you found the answer, and welcome to the forums.
Smiles
Bob