ACCESS FEED: Re: [MS_AccessPros] Report not opening, Dialog Form is blank

Senin, 17 Maret 2014

Re: [MS_AccessPros] Report not opening, Dialog Form is blank

Khalid-

Do you have code in the Report that opens the Dialog form in the Open event? And what code is in the form?

Also, you might need to explicitly define the parameter in the query:

PARAMETERS [Forms]![Clients Claim Undelivered Cargo Per Pc Dialog]![ClientCIN] Text;

SELECT ...

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications

SQL Queries for Mere Mortals

http://www.viescas.com/

(Paris, France)

On Mar 17, 2014, at 9:04 AM, Khalid Tanweer <khalidtanweerburrah@yahoo.com> wrote:

Hi All,
I have some reports which i am opening through Dialog Form, which are working right.

But now i am stucked for many reports for which report is not opening and Dialog Form to fill parameters comes to a blank form, further i am unable to close this form unless i right click on the form and click on "Form Design".

I have further noticed that any query which have 'Sum' or 'Count' they are not working.

For example i put down the query:

SELECT ClientsClaimPerPiece.ClientCIN, ClientsClaimPerPiece.ClientName, ClientsClaimPerPiece.ConsignmentNo, ClientsClaimPerPiece.CartonNo, ClientsClaimPerPiece.Product, ClientsClaimPerPiece.ProductQtyClaimed, ClientsClaimPerPiece.PricePerPc, ClientsClaimPerPiece.ClaimPerPc, Sum(ClientsClaimPerPiece.ProductQtyClaimed) AS TotQtyClaimed
FROM ClientsClaimPerPiece
GROUP BY ClientsClaimPerPiece.ClientCIN, ClientsClaimPerPiece.ClientName, ClientsClaimPerPiece.ConsignmentNo, ClientsClaimPerPiece.CartonNo, ClientsClaimPerPiece.Product, ClientsClaimPerPiece.ProductQtyClaimed, ClientsClaimPerPiece.PricePerPc, ClientsClaimPerPiece.ClaimPerPc
HAVING (((ClientsClaimPerPiece.ClientCIN)=[Forms]![Clients Claim Undelivered Cargo Per Pc Dialog]![ClientCIN]) AND ((ClientsClaimPerPiece.ClientName) Is Not Null) AND ((ClientsClaimPerPiece.ConsignmentNo)=[Forms]![Clients Claim Undelivered Cargo Per Pc Dialog]![ConsignmentNo]) AND ((ClientsClaimPerPiece.CartonNo) Is Not Null) AND ((ClientsClaimPerPiece.Product) Is Not Null) AND ((ClientsClaimPerPiece.ProductQtyClaimed) Is Not Null) AND ((ClientsClaimPerPiece.PricePerPc) Is Not Null) AND ((ClientsClaimPerPiece.ClaimPerPc) Is Not Null))
ORDER BY ClientsClaimPerPiece.CartonNo, ClientsClaimPerPiece.Product;
============
Could somebody help. Is there some other method to open Dialog Forms for such queries OR something is wrong in this query.
============
The report works perfectly if i do not use Dialog Form and simply in the query i put criteria
Like [Enter Client CIN]
Like [Enter Consignment No]

Thanks in advance for assistance.

Khalid