Access 2003 report in access 2007
in [Reports]
|
From: AccessVandal via AccessMonster.com on 19 Oct 2009 02:16 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? Peter wrote: >Dear Duane, > >Sorry for being so long in repluying. I tried that but it made no difference. > >Thanks -- Please Rate the posting if helps you. Message posted via http://www.accessmonster.com
From: Duane Hookom on 19 Oct 2009 16:16 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" wrote: > Dear Duane, > > Sorry for being so long in repluying. I tried that but it made no difference. > > Thanks > -- > Aussie > > > "Duane Hookom" wrote: > > > 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" wrote: > > > > > 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" wrote: > > > > > > > Post the SQL of your query. > > > > -- > > > > Build a little, test a little. > > > > > > > > > > > > "Peter" wrote: > > > > > > > > > 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. > > > > > > > > > > -- > > > > > Aussie
From: Peter on 21 Oct 2009 02:05
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 -- Aussie "AccessVandal via AccessMonster.com" wrote: > 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? > > Peter wrote: > >Dear Duane, > > > >Sorry for being so long in repluying. I tried that but it made no difference. > > > >Thanks > > -- > Please Rate the posting if helps you. > > Message posted via http://www.accessmonster.com > > . > |