MajP
You've got your good things, and you've got mine.
- Local time
- Today, 09:06
- Joined
- May 21, 2018
- Messages
- 8,463
So I was helping the OP on this thread
I was creating a Like "*text*" query and nothing would return. Every time I typed the query I look in the QDE and the word like magically changed to Alike. In 20 years of playing with Access I had never seen this. I thought the DB was corrupted. I was like WTF. So I googled and came across this
And then read on MS
I get it now, but I did not know access supported two ANSI standards.
I do not do a lot of work with sql backend, so my question is if SQL Server is 92 do you still set up the Access front end as 89? I am just surprised I had never seen this.
Multi field search-box
Hey there, I trying to multi field search box or Group Mark selection into search-Box. attached file (office 2019) have been work, but when reopen my database its not work. "What the reasons, can you checking my code have any problems or any others reasons. note : [List Name = List3] ------...
www.access-programmers.co.uk
I was creating a Like "*text*" query and nothing would return. Every time I typed the query I look in the QDE and the word like magically changed to Alike. In 20 years of playing with Access I had never seen this. I thought the DB was corrupted. I was like WTF. So I googled and came across this
ALike
I am relatively new to Access but I am just creating my first database for the workplace. Everything was going to plan until I came up against this. In a query when I type Like "Blue" in the criteria it changes it to ALike and the query shows nothing. I have searched and searched and asked...
www.access-programmers.co.uk
Access wildcard character reference - Microsoft Support
support.microsoft.com
I do not do a lot of work with sql backend, so my question is if SQL Server is 92 do you still set up the Access front end as 89? I am just surprised I had never seen this.