Hi
I hope that someone else has seen this before.
I have a microsoft access 2000 that I have written. The orginal computer has win ME o/s. The database runs fine on win ME. I copied my database and installed it on both a win 2000 pro o/s system (desktop) and win 98 o/s system (laptop.
On Win 2000 pro and Win 98 systems.
When I try to run some reports they gave me an error equal to when a field is not included in the query that a report is based on, (example: Lname field in the report but not in the query). This error says format. I have not a used format field anywhere in the database.
Also a have 1 query that runs fine but when I try to run the report based on the query the report will not open. I can go into the design mode of the report. I have gone into the report properties and removed the query from the record source property.
Also 5 querys based upon the same Between Date()-16 And (Date()-30) And >=#1/1/2003# formula. In win 98 I am forced to change this to a paramter query (Between [start] And [end]). I set up these 5 querys to run on 1 report.
Any suggestions would be greatly appreciated.
Mark
I hope that someone else has seen this before.
I have a microsoft access 2000 that I have written. The orginal computer has win ME o/s. The database runs fine on win ME. I copied my database and installed it on both a win 2000 pro o/s system (desktop) and win 98 o/s system (laptop.
On Win 2000 pro and Win 98 systems.
When I try to run some reports they gave me an error equal to when a field is not included in the query that a report is based on, (example: Lname field in the report but not in the query). This error says format. I have not a used format field anywhere in the database.
Also a have 1 query that runs fine but when I try to run the report based on the query the report will not open. I can go into the design mode of the report. I have gone into the report properties and removed the query from the record source property.
Also 5 querys based upon the same Between Date()-16 And (Date()-30) And >=#1/1/2003# formula. In win 98 I am forced to change this to a paramter query (Between [start] And [end]). I set up these 5 querys to run on 1 report.
Any suggestions would be greatly appreciated.
Mark