A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.
'Creates a recordsource for frmContactLookupMaster and binds the subform to it. Dim strWhere As String If IsDate(Me.txtContactDate) = True Then '--Add a 60 day timestamp window strWhere = "AND InquiryTimeStamp >= #" & DateAdd("d", -30, txtContactDate) & "# AND InquiryTimeStamp < #" & DateAdd("d", 30, txtContactDate) & "# " End If '--Build the filtered SQL statement and bind the recordsource Me.frmContactLookupMaster.Form.RecordSource = "SELECT Last, Middle, First, InquiryTimeStamp, " & _ "ContactID " & _ "From tblContacts " & _ "WHERE Last Like '" & txtLastName & "*' AND First Like '" & txtFirstName & "*' " & strWhere & _ "ORDER BY Last, First, InquiryTimeStamp DESC"
|Adding new field to an existing database in access||3||24|
|Converting Access 2003 db to 2010 db: Errors in calculated fields appear after closing pop-up form||5||19|
|What is the best way to use power bi and ssrs||3||19|
|How to define combination of fields as a non duplicate combination.||3||10|