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
New Activity (
)
Please reload this page to view the 200+ new activity items that have been created.
Older Activity
Today,
06:39 AM
ArviLaanemets
replied to a thread
how to add categories and sub categories in subform
in
Forms
l Another option is to have 2 unbound combos in main form to select injury category and subcategory, and have the subform linked to those unbound...
see more
3 replies | 41 view(s)
Today,
05:53 AM
DMT Dave
replied to a thread
Populating Excel Cells
in
Access
As always thanks WGM, i know it's an old thread but i knew at some point I'm coming back to it, once i sort it, i will post resolution and mark...
see more
15 replies | 809 view(s)
Today,
05:40 AM
mike60smart
replied to a thread
how to add categories and sub categories in subform
in
Forms
Hi There are numerous things wrong with your database. You should not be using Text data Type as a Primary Key. Each table should have an...
see more
3 replies | 41 view(s)
Today,
04:56 AM
Welshgasman
replied to a thread
Populating Excel Cells
in
Access
The every other time issue is a reference issue I seem to recall. However that is all I can do with my bad memory. You could try fully qualifying...
see more
15 replies | 809 view(s)
Today,
04:32 AM
DMT Dave
replied to a thread
Populating Excel Cells
in
Access
Thanks WGM, was looking at excel coding yesterday on i think it was Mr Excel site, very handy.. I will then debug.print intLR to check its value ...
see more
15 replies | 809 view(s)
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
15 replies | 809 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
3 replies | 41 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
3 replies | 41 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
15 replies | 809 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 | 279 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 | 279 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 | 279 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 | 279 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 | 279 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 | 279 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 | 279 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 | 279 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 | 279 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 | 279 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 | 279 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 | 279 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 | 279 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 | 279 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 | 298 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 | 298 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 | 298 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 | 678 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 | 678 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 | 678 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 | 678 view(s)
More Activity
No More Results
No Recent Activity