Register
Help
Remember Me?
Forum
What's New?
Activity Stream
New Events
Mark Forums Read
Quick Links
Today's Posts
How to Post a Question
How to Mark Thread Solved
How to Attach Files
Advanced Search
Home
Activity Stream
Activity Stream
Filter
Sort By
Time
Show
Recent
Recent
Popular
Popular
Anytime
Anytime
Last 7 Days
Last 7 Days
Last 30 Days
Last 30 Days
All
All
Photos
Photos
Forum
Forums
Filter by:
Clear All
New Activity (
)
Please reload this page to view the 200+ new activity items that have been created.
Older Activity
Today,
08:39 PM
gr8dane
replied to a thread
If Statement Ignores Boolean Values in Access VBA
in
Programming
I'm assuming it evaluates to either True or False, depending on whether or not it's been selected (the first MsgBox in the function confirms that)....
see more
11 replies | 71 view(s)
Today,
07:54 PM
Micron
replied to a thread
If Statement Ignores Boolean Values in Access VBA
in
Programming
Not from what I see. If the line I'm referring to does not evaluate to True, then what does blnA =Me!chkA evaluate to? The msgbox line does not...
see more
11 replies | 71 view(s)
Today,
07:46 PM
gr8dane
replied to a thread
If Statement Ignores Boolean Values in Access VBA
in
Programming
The combo has always been correct, so I didn't bother verifying it.
see more
11 replies | 71 view(s)
Today,
07:33 PM
davegri
replied to a thread
If Statement Ignores Boolean Values in Access VBA
in
Programming
You've verified the values of the checkboxes, but not the combobox. Perhaps the combobox has more than one column; the default is cboCat.column(0)
see more
11 replies | 71 view(s)
Today,
05:34 PM
gr8dane
replied to a thread
If Statement Ignores Boolean Values in Access VBA
in
Programming
TripleState is set to No. Default value is currently 0, although I originally set it to False.
see more
11 replies | 71 view(s)
Today,
05:29 PM
gr8dane
replied to a thread
If Statement Ignores Boolean Values in Access VBA
in
Programming
That part works correctly. That's what the MsgBoxes are there for.
see more
11 replies | 71 view(s)
Today,
05:27 PM
June7
replied to a thread
If Statement Ignores Boolean Values in Access VBA
in
Programming
Checkbox not bound to Yes/No field can be 0, -1, Null unless TripleState property is set to No. Setting DefaultValue property will populate with a...
see more
11 replies | 71 view(s)
Today,
05:17 PM
gr8dane
replied to a thread
If Statement Ignores Boolean Values in Access VBA
in
Programming
Well, not exactly. The checkboxes currently have a default value of 0, so it should never be Null, should it? I think I originally set the defaults...
see more
11 replies | 71 view(s)
Today,
05:06 PM
Micron
replied to a thread
If Statement Ignores Boolean Values in Access VBA
in
Programming
Maybe I've missed something, but if just one of these tests are not True, If (Me!cboCat = 0) And (Me!chkA = False) And (Me!chkB = False) ...
see more
11 replies | 71 view(s)
Today,
04:38 PM
gr8dane
replied to a thread
If Statement Ignores Boolean Values in Access VBA
in
Programming
Thanks for responding so quickly. I forgot to say that these are all unbound controls. I set the default value for cboCat (and all the other combos)...
see more
11 replies | 71 view(s)
Today,
04:14 PM
June7
replied to a thread
If Statement Ignores Boolean Values in Access VBA
in
Programming
I tested your function by calling it from Immediate Window with inputs that should return appropriate message. It works for all 3 cases. When...
see more
11 replies | 71 view(s)
Today,
01:15 PM
gr8dane
started a thread
If Statement Ignores Boolean Values in Access VBA
in
Programming
I have a form with several controls that I'm using to filter its records. To make it simple, let's say the controls are cboCat, chkA, chkB and...
see more
11 replies | 71 view(s)
Today,
09:33 AM
skydivetom
replied to a thread
Need Assistance with Streamlining/Reducing # of Queries to Output "Percentages"
in
Queries
CJ_London: Your proposed structure/streamlining works great!! Many thanks! SELECT /(+) AS PCProposed, /(+) AS PCVerified, /(++) AS...
see more
9 replies | 272 view(s)
Today,
03:53 AM
skydivetom
replied to a thread
Need Assistance with Streamlining/Reducing # of Queries to Output "Percentages"
in
Queries
CJ_London: I definitely love the idea of this streamlined query. "Proposed" (32 records) and "Verified" (29 records) should be combined (61...
see more
9 replies | 272 view(s)
More Activity
No More Results
No Recent Activity