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
AccessForums.net is a forum dedicated to Microsoft Access, if you want to ask any Access related questions or help other members out, please
join our community
, the registration is free and takes only one minute.
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:
Forums
Clear All
New Activity (
)
Please reload this page to view the 200+ new activity items that have been created.
Older Activity
Today,
04:16 AM
Welshgasman
replied to a thread
Populating Excel Cells
in
Access
does intLR have a value? Why not just insert a row? Wxcel has a macro recorder which comes in really handy to start your code logic.
see more
12 replies | 784 view(s)
Today,
04:11 AM
Welshgasman
replied to a thread
how to add categories and sub categories in subform
in
Forms
Crossposted first at...
see more
1 replies | 2 view(s)
Today,
03:51 AM
afiasiddiqa
started a thread
how to add categories and sub categories in subform
in
Forms
I have below 4 tables.Table1:ID, OHN (this is primary key), Dob, Type of referral, Reason of referral, date of referral received , clinician ...
see more
1 replies | 2 view(s)
Today,
03:11 AM
DMT Dave
replied to a thread
Populating Excel Cells
in
Access
Hi guy's, just to follow up this one with a question, whilst i have the formula now studied and understood, i have now added some formulas into...
see more
12 replies | 784 view(s)
Today,
12:50 AM
Welshgasman
replied to a thread
If Statement Ignores Boolean Values in Access VBA
in
Programming
Well they are not solvinjg your problem though, are they? :) A simple walk of the code would find the issue in a heartbeat, but you seem reluctant...
see more
13 replies | 160 view(s)
Yesterday,
11:53 PM
davegri
replied to a thread
If Statement Ignores Boolean Values in Access VBA
in
Programming
Ah, but saying so doesn't make it so. Your symptoms are exactly as described If cboCat is > 0 for Case 2 or Case 3
see more
13 replies | 160 view(s)
Yesterday,
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
13 replies | 160 view(s)
Yesterday,
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
13 replies | 160 view(s)
Yesterday,
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
13 replies | 160 view(s)
Yesterday,
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
13 replies | 160 view(s)
Yesterday,
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
13 replies | 160 view(s)
Yesterday,
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
13 replies | 160 view(s)
Yesterday,
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
13 replies | 160 view(s)
Yesterday,
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
13 replies | 160 view(s)
Yesterday,
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
13 replies | 160 view(s)
Yesterday,
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
13 replies | 160 view(s)
Yesterday,
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
13 replies | 160 view(s)
Yesterday,
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
13 replies | 160 view(s)
Yesterday,
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 | 288 view(s)
Yesterday,
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 | 288 view(s)
05-18-2024,
05:26 PM
CJ_London
replied to a thread
Need Assistance with Streamlining/Reducing # of Queries to Output "Percentages"
in
Queries
your T3 table has 3 values, not what you described before so I haven't done the total since not clear whether the 'not mapped' values should be...
see more
9 replies | 288 view(s)
05-18-2024,
03:01 PM
Welshgasman
replied to a thread
Using Input boxes to populate a Form?
in
Access
Every Web application I have used takes you through a set of what I will call controls to keep in line with Access. In fact they will complain you...
see more
18 replies | 670 view(s)
05-18-2024,
02:44 PM
easyrider
replied to a thread
Using Input boxes to populate a Form?
in
Access
My initial question was in regards to giving the user an alternative way to input data into the form via a series of input boxes as opposed to...
see more
18 replies | 670 view(s)
05-18-2024,
02:28 PM
Welshgasman
replied to a thread
Using Input boxes to populate a Form?
in
Access
All I am saying is that we were directed away from the issue as we were presented with what appeared to be a non normalised db, which most people...
see more
18 replies | 670 view(s)
05-18-2024,
02:09 PM
Micron
replied to a thread
Using Input boxes to populate a Form?
in
Access
Guys, let's play nice. Lots of people post with pseudo data and/or situations so why is this any different? IMO, in ALL cases, the OP gets the...
see more
18 replies | 670 view(s)
05-18-2024,
12:53 PM
Welshgasman
replied to a thread
Using Input boxes to populate a Form?
in
Access
The O/P has now stated that most of he has shown us us pure BS, so we have no idea as to what he actually has. Sort of asking us how to mount a...
see more
18 replies | 670 view(s)
05-18-2024,
11:21 AM
CarlettoFed
replied to a thread
Using Input boxes to populate a Form?
in
Access
from the uselessness of the Middle Initial field by the lack of combobox controls for what should probably concern the City, Region, Postal Code...
see more
18 replies | 670 view(s)
05-18-2024,
09:34 AM
easyrider
replied to a thread
Using Input boxes to populate a Form?
in
Access
OK, everyone, I'm working on a database solution that will eventually be trademarked - maybe even patented. As such, I really didn't want to reveal...
see more
18 replies | 670 view(s)
05-18-2024,
08:33 AM
Micron
replied to a thread
Using Input boxes to populate a Form?
in
Access
I didn't say to do anything to the fields, just present one list (message box), like "Please enter data for: - Parcel ID - Last Name " I...
see more
18 replies | 670 view(s)
05-18-2024,
07:33 AM
Welshgasman
replied to a thread
Using Input boxes to populate a Form?
in
Access
Probably from the Attribute numbered controls?
see more
18 replies | 670 view(s)
More Activity
No More Results
No Recent Activity