Can users to specify report arguments (e.g. Patient ID, Date ranges etc,) at run time?

In mdb file, you need to specify a sql statement for the report, such as the following VBA code:

Private Sub Report_Open(Cancel As Integer)

Me.RecordSource = "SELECT DISTINCTROW Categories.CategoryName, Products.ProductName, Products.QuantityPerUnit, Products.UnitsInStock, Products.Discontinued " _

& "FROM Categories INNER JOIN Products ON Categories.CategoryID = Products.CategoryID " _

& "WHERE (((Categories.CategoryName) = '" & Me.OpenArgs & "') And ((Products.Discontinued) <> Yes)) " _

& "ORDER BY Categories.CategoryName, Products.ProductName;"

End Sub

You can now pass in the ReportArgs argument into the GetReport method. This will be passed into the Access report using OpenArgs:

Dim strArgs As String = "Condiments"

strReturn = objReportClient.GetReport(strDatabaseName, strReportName, strReportFilter, strArgs, enmReportFormat)

Please note this will only work with Access 2002 and higher.