Help on reporting with option group (VB)

V

Veli Izzet

Hi all,

I have an app where daily monetary transactions are inserted in an
access database. The interactions may be in TL, usd or euro. There is a
field where the money that is used is stored. In addition to that, the
currency parities for the transaction day is stored too.

Now, I want to have a report on any currency I choose on the fly. For
reporting I use a button with the code:
---
Private Sub Command6_Click()
On Error GoTo Err_Command6_Click

Dim strReport As String 'Name of report to open.
Dim strField As String 'Name of your date field.
Dim strWhere As String 'Where condition for OpenReport.
Const conDateFormat = "\#mm\/dd\/yyyy\#"

strReport = "Hareketler-Tek"

strField = "HareketTarihi"

If IsNull(Me.Baslangic) Then
If Not IsNull(Me.Bitis) Then 'End date, but no start.
strWhere = strField & " < " & Format(Me.Bitis, conDateFormat)
End If
Else
If IsNull(Me.Bitis) Then 'Start date, but no End.
strWhere = strField & " > " & Format(Me.Baslangic,
conDateFormat)
Else 'Both start and end dates.
strWhere = strField & " Between " & Format(Me.Baslangic,
conDateFormat) _
& " And " & Format(Me.Bitis, conDateFormat)
End If
End If
-------

To be able to have the report in the currency I like I created an option
group with three option buttons, but I cannot pass the info to the report.

I would appreciate any help..

Thanks for answers..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top