I must have missed that tutorial. I'll get on it asap. As far as my backend db it's Access 2003 and there is no time component just mm/dd/yyyy.

I will be changing the db field to Tdate

and as far as I understand, I'll be doing something like this:

Code:
dim Tdate as Date
Tdate = Date
Dim sql as String
sql = "Select Note From Transactions Where Tdate = '" & _
"Format(Date,"mm/dd/yyyy") & "'"
This will look for any entries in the Transaction Table for Today's date. Moving on...

I will be needing to incorporate Text fields that hold a user entered date. The values of which will become variables. I will need to run a query for Transaction BETWEEN Date1 and Date2.

I do see this at http://www.vbforums.com/showthread.php?t=489286 and this should help quite a bit in getting the user input date to a textbox and then to a variable:

Code:
'This example is assumes that the text was entered in the format of mm/dd/yyyy
Dim MyDate as Date
Dim TempArray() as String

    'Separate the items by the delimiter (in this example, "/") 
  TempArray() = Split(Text1.Text, "/")

    'Note: you should check here that the values are valid 
    '(such as the month is a whole number, between 1 and 12)

    'Place each item in the relevant part of DateSerial to build the date
  MyDate = DateSerial(TempArray(2), TempArray(0), TempArray(1))