Error

[THEAF]

Im trying to generate a report that gets the data from my Database
using DataEnvironment and Datareport.

This is the code I use to open my datareport.

Private Sub mnuCentreListEx aminer_Click()
'
DataEnvironment 1.Command4 cmbExaminerno.T ext '
DataReport4.Sho w
End Sub

I also used this SQl ststement in my command.

SELECT Exam_Entries.* FROM Exam_Entries WHERE
Exam_Entries.Ex aminer_No = ?

The datareport shows all relevent data of 1 Examiner,
that Examiner is indicated by the Examiner number from the textbox cmbExaminerno.T ext

When I open the Datareport it works.But if I try to open it
again I get this error " Operation is not allowed when the object is open "
I have seen some other people on this website with the same problem who have answers,
and I have tried to adapt those answers to suit me but it still doesn't work

CAN ANYONE PLEASE HELP ME
AND THANX IN ADVANCE

[Dököll]

Im trying to generate a report that gets the data from my Database
using DataEnvironment and Datareport.

This is the code I use to open my datareport.

Private Sub mnuCentreListEx aminer_Click()
'
DataEnvironment 1.Command4 cmbExaminerno.T ext '
DataReport4.Sho w
End Sub

I also used this SQl ststement in my command.

SELECT Exam_Entries.* FROM Exam_Entries WHERE
Exam_Entries.Ex aminer_No = ?

The datareport shows all relevent data of 1 Examiner,
that Examiner is indicated by the Examiner number from the textbox cmbExaminerno.T ext

When I open the Datareport it works.But if I try to open it
again I get this error " Operation is not allowed when the object is open "
I have seen some other people on this website with the same problem who have answers,
and I have tried to adapt those answers to suit me but it still doesn't work

CAN ANYONE PLEASE HELP ME
AND THANX IN ADVANCE

I am not sure why you are getting the error. Since you are using data environment, take a look here:

http://www.thescripts.com/forum/thread585465.html

Look towards the botton of the thread...

Good luck with the project, THEAF!

Dököll

[THEAF]

Thanx Dököll for your answer but im quite new to this and i
didn't fully understand what you ment. could you explain a bit more.

Thanx ALOT