access reports UNRESOLVED!

[Bazzlad]

are crap
im using access 2000
and the reports decide to work or not.
is there any way to make them stable?

[M Owen]

How are they working and then not? What is the behaviour you are seeing manifest? What are the conditions that the report is operating in? Where is the report being run?

[Bazzlad]

I'm running a report which draws its information from a query, the query draws its information from a form

SELECT DISTINCT [tblin].[Make], [tblin].[Phone Model], [tblin].[IMEI], [tblin].[Cost], [tblin].[Sold?], [tblin].[Sale Number], [tblin].[Price], [tblcustomer].[Customer Name], [tblcustomer].[Customer ID], [tblcustomer].[Company], [tblout].[Date]
FROM tblcustomer, tblout, tblin
WHERE ((([tblin].[Sold?])=Yes) And (([tblin].[Sale Number])=[Forms].[frmsale].[sale number].value) And (([tblcustomer].[Customer ID])=[Forms]![frmsale]![Customer ID].value) And (([tblout].[Date])=[Forms]![frmsale]![datebox].value));


It'll work 50% of the time and the others it'll say
access can't find the field FORMS reffered to in your expression
or
the open report action was cancelled.

It's driving me insane.

[M Owen]

Have you run a compact & repair on this DB? Also since you said the query is BASED on an OPEN form, when you run this report that form is running correct (just trying to eliminate the obvious stuff ...)?

[Bazzlad]

Have run a compact.
Form running correct?
Je ne pas comprende!
The Data is there and the form is open....
any ideas whats wrong?

[andreys]

Originally posted by Bazzlad


It'll work 50% of the time and the others it'll say
access can't find the field FORMS reffered to in your expression
or
the open report action was cancelled.


Exactly, look at this in your sql statement:

[Forms].[frmsale].[sale number].value


Should be:

[Forms]![frmsale]![sale number].value

[Bazzlad]

Changed it but it still is throwing strops....

If you look here

http://www.vbforums.com/showthread.php?s=&threadid=265684

You can find a link to Download and have a look if you like...