Problem Between Two Dates Report

a_20120

tan
Local time
Tomorrow, 00:22
Joined
Nov 21, 2006
Messages
175
Hi All,
I used macro to generate report between two dates (From - To)
It works on some PCs well but I dont know why on some PCs not work and generate error, see the attachment...Help is apprecited
 

Attachments

  • error.JPG
    error.JPG
    16.6 KB · Views: 134
For more information about above thread See the DB attachment...Waiting ur help...
 

Attachments

Hi all Viewers,
If the Solution is possible through VBA plz Do it.
I f Possible through Macro then Do it too
 
Hello EveryOne,
AnyOne can help and find solution for the above thread will be appreciated, I am really interested to see the solution of the above Thread. I am sure some u men faced to the same issues....plz have a reply here too
 
Normally I would suggest that the .Visible property should always be present, but for reports that is not necessarily the case. If there is some code somewhere that is trying to reference the visibility of a report, the first thing I would check is that the same version of Access is running on the machine giving the error as on the machine where the database was developed.

Microsoft frequently adds features such that something you develop on Access for WinXP won't work correctly on Access for Win2K. Nor would a re-install of the same version of Access help if it is that level of a problem.

If this is an Access Version issue, you will find no solution of any kind except to upgrade the version of Access on the machine having the problem.
 
Thanx 4 replying,
did u test the DB on ur System? if yes, what was the result? Could anyone help me with this thread?
 
Hello Everyone,
What happening here, no one to reply and find solution for the above thread... I am really interested to know the solution of the above thread...
 
I would always create a dialog box with the Start and End and on the report Query refer back to the Dialog Box. The Dialog Box contains a Command Button to Report and a method to select which Report you want.

All the Sales date based reports use:

[Client Sale Date] Between [Forms]![Sales Dialogue Reports]![Start] And [Forms]![Sales Dialogue Reports]![End]

Simon
 
Solution

Finally I found the solution, just from the Macro security select the LOW mode
 

Users who are viewing this thread

Back
Top Bottom