Access 2003 report in access 2007

[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.

 

[KARL DEWEY]

Post the SQL of your query.

 

[Peter]

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];

 

[Duane Hookom]

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

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.

 

[Peter]

Dear Duane,

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

Thanks
--
Aussie

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

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.

 

[AccessVandal via AccessMonster.com]

I don't know whether Duane has other suggestion.

Is it possible that you may have a control or controls that was bound to your
Query on that Report and that you may have rename a Field/Column in your
table and that control may still be bound to a name that was replaced?

 

[Duane Hookom]

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

Dear Duane,

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

Thanks
--
Aussie

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

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.

 

[Peter]

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