Set qdf = CurrentDb.QueryDefs("PT_OE_V_TC_Employees_Username") sSQL = "SELECT * From OE_V_TC_Employees (NOLOCK) " & vbCrLf sSQL = sSQL & "WHERE(UserName = '" & varUsername & "')" qdf.SQL = sSQL
|MS Access to SQL Conversion - Bit and Yes/No Datatypes||12||46|
|How to remove the decimal places from a number field within an expression in Access 2010||4||27|
|MS Access Why isn't the relationship ID being copied when an input is made?||7||23|
|Simple "INSERT INTO " give "Compile Error - expected end of statement||2||22|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
25 Experts available now in Live!