How to use system username directly in MS Access query?

by

You need to create a VBA function that returns the username, and then use the function in the query.

Public Function GetUserName() As String
    ' GetUserName = Environ("USERNAME")
    ' Better method, see comment by HansUp
    GetUserName = CreateObject("WScript.Network").UserName
End Function

and

SELECT foo FROM bar WHERE myUserName = GetUserName();

More Related Contents:

  1. How do I use parameters in VBA in the different contexts in Microsoft Access?
  2. What’s the difference between DoCmd.SetWarnings and CurrentDB.Execute
  3. Using Excel VBA to export data to MS Access table
  4. Access – compare two tables and update or insert data in first table
  5. Query for getting value from another record in same table and filter by difference greater than a gap threshold
  6. How to save the result of a SQL query into a variable in VBA?
  7. Escaping ‘ in Access SQL
  8. sql in ms-access [closed]
  9. Managing and debugging SQL queries in MS Access
  10. How do I write a full outer join query in access
  11. How to do INSERT into a table records extracted from another table
  12. Multiple INNER JOIN SQL ACCESS
  13. Performing SQL queries on an Excel Table within a Workbook with VBA Macro
  14. How to simulate UNPIVOT in Access?
  15. Table-less UNION query in MS Access (Jet/ACE)
  16. Ms Access Query: Concatenating Rows through a query
  17. is there a group_concat function in ms-access?
  18. Accessing SQL Database in Excel-VBA
  19. Excel function to make SQL-like queries on worksheet data?
  20. Using Excel VBA to run SQL query
  21. How do I implement pagination in SQL for MS Access?
  22. SQL to add column with default value – Access 2003
  23. Achieving ROW_NUMBER / PARTITION BY in MS Access
  24. Lightweight SQL database which doesn’t require installation [closed]
  25. Convert String to Date in MS Access Query
  26. HOW TO SELECT PREVIOUS ROW VALUE? [duplicate]
  27. MSAccess – query to return result set of earliest rows with a unique combination of 2 columns
  28. Select query with date condition
  29. Does MS access(2003) have anything comparable to Stored procedure. I want to run a complex query in MS acceess
  30. Microsoft Access – Case Query

Leave a Comment