Escaping ‘ in Access SQL

by

The “Replace” function should do the trick. Based on your code above:

DLookup("island", "villages", "village="" & Replace(txtVillage, """, "''") & "'")

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. How to use system username directly in MS Access query?
  5. Access – compare two tables and update or insert data in first table
  6. Query for getting value from another record in same table and filter by difference greater than a gap threshold
  7. How to save the result of a SQL query into a variable in VBA?
  8. SQL multiple join statement
  9. How do I write a full outer join query in access
  10. How to handle a single quote in Oracle SQL
  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. Table-less UNION query in MS Access (Jet/ACE)
  15. Ms Access Query: Concatenating Rows through a query
  16. is there a group_concat function in ms-access?
  17. Accessing SQL Database in Excel-VBA
  18. Oracle SQL escape character (for a ‘&’)
  19. Excel function to make SQL-like queries on worksheet data?
  20. How do I implement pagination in SQL for MS Access?
  21. [] brackets in sql statements
  22. Row numbers in query result using Microsoft Access
  23. SQL to add column with default value – Access 2003
  24. “You tried to execute a query that does not include the specified aggregate function”
  25. How can I implement SQL INTERSECT and MINUS operations in MS Access
  26. How to escape square brackets inside square brackets for field name
  27. SQL Update woes in MS Access – Operation must use an updateable query
  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. How do I create a decimal field in Access with Alter Table?

Leave a Comment