Cannot get a complete report

[andy49]

Hi Lou. Your query for that report searches for status <>"n/a" which return no values at all as they are all n/a


Sent from my iPhone using Tapatalk

[andy49]

Yes that's correct.


Sent from my iPhone using Tapatalk

[Lou_Reed]

When I open rptAttendence from frmPersonnel; the rptAttendence does open, but ut stays in the background; I cannot even see it because frmPersonnel is blocking it..

Now when I tried to alter the Macro that open this report, to change the visible property from Yes to No, MS Access did not like it.

There is no close form Macro, but there is on open form Macro; so how to get rid frmPersoonel? Or at least how do I move it to the background?

Thanks in advance.

Respectfully,


Lou Reed

[andy49]

Go into the macro you have to open the report and change the initial setting from Normal to Dialog

[Lou_Reed]

I also have one more question. How or where did you know that frmPersonnel must be open to rptAttendence ?

I have not read anything about it. I am certain that you are correct. It works after all!

But just where did you get it.

Also what is the purpose of the Form_Current subprogram?

Any help appreciated. Thanks in advance.

Respectfully,

Lou Reed

[andy49]

SELECT tblMeetings.MeetingID, tblMeetings.MeetingDate, tblAttendence.Notes, tblAttendence.Status, tblPersonnel.PersonnelID FROM tblPersonnel INNER JOIN (tblMeetings INNER JOIN tblAttendence ON tblMeetings.MeetingID = tblAttendence.MeetingID) ON tblPersonnel.PersonnelID = tblAttendence.PersonnelID WHERE (((tblAttendence.Status)<>"N/A") And ((tblPersonnel.PersonnelID)=Forms!frmPersonnel.PersonnelID));

This is the SQL that the rptAttendance needs for it's data

(It was on the data tab of the reports properties)

The SQL cannot know the value of something on a form if the form isn't open