Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.
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.
Dim EESQL As String Dim db As Database Dim rs As DAO.Recordset EESQL = "SELECT Max(os_claims.EmployeeID) AS MaxOfEmployeeID " & _ "FROM os_claims " & _ "WHERE (((os_claims.DateClosed) Is Null) AND ((os_claims.ArchivedRecord)=False) AND ((os_claims.EmployeeID)=[forms]![frmEmployees]![id]));" Set db = CurrentDb Set rs = db.OpenRecordset(EESQL) Me.selectedEEFound.Value = rs.Fields("MaxOfEmployeeID").Value Set rs = Nothing Set db = Nothing
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Access 2010 - Issue Viewing Records Added to a Linked SQL Table||16||95|
|ms access - Helpdesk ticket system||5||39|
|Create a VBA Loop in Access to check records and create and action||7||51|
|Converting Access 2016 from 32-bit to 64-bit||8||49|
Join the community of 500,000 technology professionals and ask your questions.