Hi, I recently migrated a split access db to Azure SQL Server. Really happy with the performance of SQL Views in SQL Server.
I need to build a search form for searching text of supporttickets.
In TSQL in SSMS i can perform queries like this one:
The question is:
I need to build a search form for searching text of supporttickets.
In TSQL in SSMS i can perform queries like this one:
SQL:
select * from Supporttickets where contains(TicketDescription, 'lookingforthisword')
The question is:
- How can I access the Full text functionality from Access VBA side?
- Is this the way to go or is there a better option?