Access 2003 report in access 2007

  • Thread starter Thread starter Peter
  • Start date Start date
P

Peter

Hullo,

I created a report in Access 2003 based on a query which is based on one
table. It works perfectly in Access 2003 however it will not open in Access
2007. The query it is based on runs ok in Access 2007 though.

When I try to open the report I get an error message: " Is not a valid name.
Make sure that it does not include invalid characters or punctuation and that
it is not too long.

I cannot find a name of a field in the table that defies these rules. The
names of the report and the query do not defy these rules either.

If you could help me I would be greatful.
 
Dear Karl,

Here is the SQL of the Query.

Thanks

SELECT [Vegetation Tracking].[Record No], [Vegetation Tracking].[Job Code],
[Vegetation Tracking].Tenure, [Vegetation Tracking].[RE Maps], [Vegetation
Tracking].[RE Data], [Vegetation Tracking].[CSEP Data], [Vegetation
Tracking].[CSEP Data received], [Vegetation Tracking].[KML created],
[Vegetation Tracking].[Forms sent], [Vegetation Tracking].Phoned, [Vegetation
Tracking].[Disclaimer received], [Vegetation Tracking].[Client response],
[Vegetation Tracking].[PMAV lodged], [Vegetation Tracking].[PMAV expected],
[Vegetation Tracking].[Confirmation of Receipt], [Vegetation Tracking].[Draft
offer], [Vegetation Tracking].[Draft offer accepted], [Vegetation
Tracking].[PMAV Certificate], [Vegetation Tracking].[Shape files],
[Vegetation Tracking].Notes, [Vegetation Tracking].[Job finished]
FROM [Vegetation Tracking]
WHERE ((([Vegetation Tracking].[Job finished])=No))
ORDER BY [Vegetation Tracking].[Job Code];
 
If [Job Finished] is a yes/no field, try replacing No in the criteria with 0.
A yes/no field actually stores 0 for No/False and -1 for Yes/True.

--
Duane Hookom
Microsoft Access MVP


Peter said:
Dear Karl,

Here is the SQL of the Query.

Thanks

SELECT [Vegetation Tracking].[Record No], [Vegetation Tracking].[Job Code],
[Vegetation Tracking].Tenure, [Vegetation Tracking].[RE Maps], [Vegetation
Tracking].[RE Data], [Vegetation Tracking].[CSEP Data], [Vegetation
Tracking].[CSEP Data received], [Vegetation Tracking].[KML created],
[Vegetation Tracking].[Forms sent], [Vegetation Tracking].Phoned, [Vegetation
Tracking].[Disclaimer received], [Vegetation Tracking].[Client response],
[Vegetation Tracking].[PMAV lodged], [Vegetation Tracking].[PMAV expected],
[Vegetation Tracking].[Confirmation of Receipt], [Vegetation Tracking].[Draft
offer], [Vegetation Tracking].[Draft offer accepted], [Vegetation
Tracking].[PMAV Certificate], [Vegetation Tracking].[Shape files],
[Vegetation Tracking].Notes, [Vegetation Tracking].[Job finished]
FROM [Vegetation Tracking]
WHERE ((([Vegetation Tracking].[Job finished])=No))
ORDER BY [Vegetation Tracking].[Job Code];

--
Aussie


KARL DEWEY said:
Post the SQL of your query.
Click to expand...
Click to expand...
 
Dear Duane,

Sorry for being so long in repluying. I tried that but it made no difference.

Thanks
--
Aussie


Duane Hookom said:
If [Job Finished] is a yes/no field, try replacing No in the criteria with 0.
A yes/no field actually stores 0 for No/False and -1 for Yes/True.

--
Duane Hookom
Microsoft Access MVP


Peter said:
Dear Karl,

Here is the SQL of the Query.

Thanks

SELECT [Vegetation Tracking].[Record No], [Vegetation Tracking].[Job Code],
[Vegetation Tracking].Tenure, [Vegetation Tracking].[RE Maps], [Vegetation
Tracking].[RE Data], [Vegetation Tracking].[CSEP Data], [Vegetation
Tracking].[CSEP Data received], [Vegetation Tracking].[KML created],
[Vegetation Tracking].[Forms sent], [Vegetation Tracking].Phoned, [Vegetation
Tracking].[Disclaimer received], [Vegetation Tracking].[Client response],
[Vegetation Tracking].[PMAV lodged], [Vegetation Tracking].[PMAV expected],
[Vegetation Tracking].[Confirmation of Receipt], [Vegetation Tracking].[Draft
offer], [Vegetation Tracking].[Draft offer accepted], [Vegetation
Tracking].[PMAV Certificate], [Vegetation Tracking].[Shape files],
[Vegetation Tracking].Notes, [Vegetation Tracking].[Job finished]
FROM [Vegetation Tracking]
WHERE ((([Vegetation Tracking].[Job finished])=No))
ORDER BY [Vegetation Tracking].[Job Code];

--
Aussie


KARL DEWEY said:
Post the SQL of your query.
--
Build a little, test a little.


:

Hullo,

I created a report in Access 2003 based on a query which is based on one
table. It works perfectly in Access 2003 however it will not open in Access
2007. The query it is based on runs ok in Access 2007 though.

When I try to open the report I get an error message: " Is not a valid name.
Make sure that it does not include invalid characters or punctuation and that
it is not too long.

I cannot find a name of a field in the table that defies these rules. The
names of the report and the query do not defy these rules either.

If you could help me I would be greatful.
Click to expand...
Click to expand...
Click to expand...
 
I don't see anything else in the query that might be an issue. I would try
create a new report to see if it has an issue.

--
Duane Hookom
Microsoft Access MVP


Peter said:
Dear Duane,

Sorry for being so long in repluying. I tried that but it made no difference.

Thanks
--
Aussie


Duane Hookom said:
If [Job Finished] is a yes/no field, try replacing No in the criteria with 0.
A yes/no field actually stores 0 for No/False and -1 for Yes/True.

--
Duane Hookom
Microsoft Access MVP


Peter said:
Dear Karl,

Here is the SQL of the Query.

Thanks

SELECT [Vegetation Tracking].[Record No], [Vegetation Tracking].[Job Code],
[Vegetation Tracking].Tenure, [Vegetation Tracking].[RE Maps], [Vegetation
Tracking].[RE Data], [Vegetation Tracking].[CSEP Data], [Vegetation
Tracking].[CSEP Data received], [Vegetation Tracking].[KML created],
[Vegetation Tracking].[Forms sent], [Vegetation Tracking].Phoned, [Vegetation
Tracking].[Disclaimer received], [Vegetation Tracking].[Client response],
[Vegetation Tracking].[PMAV lodged], [Vegetation Tracking].[PMAV expected],
[Vegetation Tracking].[Confirmation of Receipt], [Vegetation Tracking].[Draft
offer], [Vegetation Tracking].[Draft offer accepted], [Vegetation
Tracking].[PMAV Certificate], [Vegetation Tracking].[Shape files],
[Vegetation Tracking].Notes, [Vegetation Tracking].[Job finished]
FROM [Vegetation Tracking]
WHERE ((([Vegetation Tracking].[Job finished])=No))
ORDER BY [Vegetation Tracking].[Job Code];

--
Aussie


:

Post the SQL of your query.
--
Build a little, test a little.


:

Hullo,

I created a report in Access 2003 based on a query which is based on one
table. It works perfectly in Access 2003 however it will not open in Access
2007. The query it is based on runs ok in Access 2007 though.

When I try to open the report I get an error message: " Is not a valid name.
Make sure that it does not include invalid characters or punctuation and that
it is not too long.

I cannot find a name of a field in the table that defies these rules. The
names of the report and the query do not defy these rules either.

If you could help me I would be greatful.
Click to expand...
Click to expand...
Click to expand...
 
Dear AccessVandal,

Thanks for the suggestion but I checked out all the names and they line up
ok. Duane suggested that I make up a new report. I will try to get time to do
that sometime.

Thanks
 
Back
Top