Menu
Home
Forums
New posts
Search forums
What's new
New posts
New profile posts
Latest activity
Members
Current visitors
New profile posts
Search profile posts
Log in
Register
What's new
Search
Search
Search titles only
By:
Current visitors
New profile posts
Search profile posts
Menu
Log in
Register
Home
Members
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
TipsyWolf's latest activity
T
TipsyWolf
reacted to
Gasman's post
in the thread
Solved
Where condition in dbl click event
with
Like
.
You would at least need status='In progress' or status = 'New') I would surround the conditions with () for the logic.
Today at 2:07 PM
T
TipsyWolf
replied to the thread
Solved
Where condition in dbl click event
.
it worked ! awesome ! thank u , Sir ! :) much appriciated for your help !
Today at 2:07 PM
T
TipsyWolf
posted the thread
Solved
Where condition in dbl click event
in
Forms
.
hello everyone ! i have a double click event where it opens up for me a master list. i tried this one ="RiskID In(SELECT RiskID FROM...
Today at 10:40 AM
T
TipsyWolf
reacted to
Pat Hartman's post
in the thread
Solved
the expression you entered is too complex
with
Like
.
Your language says it all;) You have created a spreadsheet rather than a normalized relational database. Relational databases do not...
Apr 12, 2024
T
TipsyWolf
reacted to
Gasman's post
in the thread
Solved
the expression you entered is too complex
with
Like
.
You do not say what the error is? :( I would be using Me.txtb if that is a control on the form.
Apr 12, 2024
T
TipsyWolf
reacted to
nector's post
in the thread
Solved
the expression you entered is too complex
with
Like
.
If you are using those codes within access and the DB or BE is access then its fine, but if you want to use the SQL server with Access...
Apr 12, 2024
T
TipsyWolf
reacted to
Gasman's post
in the thread
Solved
the expression you entered is too complex
with
Like
.
Why not just use the Sovernity directly?
Apr 12, 2024
T
TipsyWolf
reacted to
CJ_London's post
in the thread
Solved
the expression you entered is too complex
with
Like
.
that error usually implies a problem with your data - typically a null value. As written, your nested iif function will fail if you...
Apr 12, 2024
T
TipsyWolf
reacted to
cheekybuddha's post
in the thread
Solved
the expression you entered is too complex
with
Like
.
Choose() is probably a better choice than Switch() if you want to avoid the table option.
Apr 12, 2024
T
TipsyWolf
reacted to
The_Doc_Man's post
in the thread
Solved
the expression you entered is too complex
with
Like
.
Probably too much depth in the nested IIF. That certainly looks like more than twenty nests of the IIF FALSE option. I see three...
Apr 12, 2024
T
TipsyWolf
reacted to
cheekybuddha's post
in the thread
Solved
the expression you entered is too complex
with
Like
.
There are 25 risk codes - with either Switch() or nested IIf(), my guess is that you are butting up against or beyond the maximum number...
Apr 12, 2024
T
TipsyWolf
reacted to
arnelgp's post
in the thread
Solved
the expression you entered is too complex
with
Like
.
table, tblRiskCode: RiskCode...
Apr 12, 2024
T
TipsyWolf
reacted to
Gasman's post
in the thread
Solved
the expression you entered is too complex
with
Like
.
Whilst I would also go for a lookup table, just in cas ethe data changes, could a Switch() function be used here as well? if it did not...
Apr 12, 2024
T
TipsyWolf
reacted to
GPGeorge's post
in the thread
Solved
the expression you entered is too complex
with
Like
.
Lookup tables are cool.
Apr 12, 2024
T
TipsyWolf
reacted to
cheekybuddha's post
in the thread
Solved
the expression you entered is too complex
with
Like
.
When you have this many it's easier to create a table for risk codes; then join the table without the need for such an unwieldy...
Apr 12, 2024
Home
Members
Top
Bottom