Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Hash sign in me.filter expresion

Posted on 2015-02-16
2
Medium Priority
?
118 Views
Last Modified: 2016-02-10
Microsoft Access 2013

Hi.

Following code fails because of the  # character (hash sign).
Me.Filter = "[Template Name] like '*template #2*'"
Me.FilterOn = True

Open in new window


How do I deal with this?
0
Comment
Question by:peispud
2 Comments
 
LVL 54

Accepted Solution

by:
Rgonzo1971 earned 2000 total points
ID: 40611966
Hi,

have you tried

Me.Filter = "[Template Name] like '*template [#]2*'"

https://msdn.microsoft.com/en-us/library/office/gg251796(v=office.15).aspx

Regards
0
 

Author Comment

by:peispud
ID: 40611978
Me.Filter = "[Template Name] like '*template [#]2*'"
Me.FilterOn = True

Thanks.

Found the solution there.
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…
Suggested Courses

564 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question