Dynamic Report Membership Card Details 1

[djnick]

I currently learning access, in which I use mainly the built in features including the reporting option.

I have a simple membership database in which there are multiple status ie. VIP, Standard, Privilaged etc.

Each of these has a seperate report where the background information is changed.

IE. VIP will be printed on the vip membership card, etc.

These are currently graphic based images which have the rules information for each one differently.

Is there a way of writing one report which pulls off all the current new members and then the report dynamically changes the card details to match with the type of status they have.

I am a newbie.. so please over explain how to do this.

Many thanks..

I await the replies and your information

Nick

 

[OrWolf]

The best way to accomplish this is to use the DLOOKUP function to determine the member status. Use this in conjunction with the OnFormat expression of your detail section of the report. The code would look something like this:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)

If DLookup("[Status]","[MemberTableName]","[MemberID] = " & MemberNo)= "VIP" Then
Me.VIPImage.Visible = True
ElseIf DLookup("[Status]","[MemberTableName]","[MemberID] = " & MemberNo)= "Standard" Then
Me.StandardImage.Visible = True
End Sub

Set-up the report with all images' visible property set to No.

Let me know if this is what you were looking for.