I have a report, and when I click a button for report preview, follwing code is executed:
sCriteria = ([Date of First Issue] <= #" & [Forms]![DirectivesForm].[cboLastDate] & "#"
stDocName = "Report"
DoCmd.OpenReport stDocName, acViewPreview, , sCriteria, acWindowNormal
Now, this should show all records up to the date selected, and it does that on the computer the database was created.
This database is in network envoirnment, and it can be accessed from any computer in the network.
Now, the problem is, as I said it filters the report query right on the computer that the database was created, but, it doesn't do the right job in any other computer on the network.
It filters some of the dates correctly, but then some others are not correct. For example: If i pick Friday, June 6th as the date, it filters all records up to June 6th, but if I pick June 7th, it filters all records up to June 10th... And as I said, it does that on all computers except the one on which database was created.
Any suggestions how to fix this problem ??
Thank you
Dragan
sCriteria = ([Date of First Issue] <= #" & [Forms]![DirectivesForm].[cboLastDate] & "#"
stDocName = "Report"
DoCmd.OpenReport stDocName, acViewPreview, , sCriteria, acWindowNormal
Now, this should show all records up to the date selected, and it does that on the computer the database was created.
This database is in network envoirnment, and it can be accessed from any computer in the network.
Now, the problem is, as I said it filters the report query right on the computer that the database was created, but, it doesn't do the right job in any other computer on the network.
It filters some of the dates correctly, but then some others are not correct. For example: If i pick Friday, June 6th as the date, it filters all records up to June 6th, but if I pick June 7th, it filters all records up to June 10th... And as I said, it does that on all computers except the one on which database was created.
Any suggestions how to fix this problem ??
Thank you
Dragan