transactions to see the patron history by enter a barcode.
I have made a recordset to get the patron barcode
in the same time to get the Id field from patrons
as this value is connected to the [checked out to] field in the transaction.
I have tried
Expand|Select|Wrap|Line Numbers
- str = "SELECT [ID], [BookID], [Checked in date], [Checked Out Date], [DueDate] FROM Transactions ORDER BY [duedate] Where [checked out to] = " & _
- rspatrons![ID]
- Me.result_list.AddItem "ID; Title; Checked in date; checked out date ; due date "
- Me.result_list.RowSource = str
and it displays
ID book id checked in date checked outdate due date
in the first line without my search results.
did i miss anything ?
thanks.