Want to do a QBF (query by form) for data in a SQL Server. Using Access (project) as the frontend and SQL7 as the db. In Old Access I used to write
Like Forms!SearchForm!SearchField & "*" Or Forms!SearchForm!SearchField Is Null
This was written in several query fields and using an unbound form, I could query a table with one or several fields at once. I haven't really tried this much, but this doesn't seem to fire in SQL and it looks like my simple QBF is going to get really complicated. Is that true?
Does anyone out there have a really good QBF technique they want to share for Access frontend and a SQL backend?
Just looking for ideas before I start slapping the monitor and cursing outloud when I'm alone.
HeeHAw
Like Forms!SearchForm!SearchField & "*" Or Forms!SearchForm!SearchField Is Null
This was written in several query fields and using an unbound form, I could query a table with one or several fields at once. I haven't really tried this much, but this doesn't seem to fire in SQL and it looks like my simple QBF is going to get really complicated. Is that true?
Does anyone out there have a really good QBF technique they want to share for Access frontend and a SQL backend?
Just looking for ideas before I start slapping the monitor and cursing outloud when I'm alone.
HeeHAw