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,
10:42 AM
mike60smart
replied to a thread
how to add categories and sub categories in subform
in
Forms
Hi The subform needs to be set as a Continuous Form vice Datasheet. You should name the Forms with the prefix "frm" vice "tbl" The first...
see more
9 replies | 68 view(s)
Today,
10:31 AM
afiasiddiqa
replied to a thread
how to add categories and sub categories in subform
in
Forms
and this is the initial database file but this is with alpha numeric primary keys Many Thanks
see more
9 replies | 68 view(s)
Today,
10:25 AM
gr8dane
replied to a thread
If Statement Ignores Boolean Values in Access VBA
in
Programming
No, they are never gray. They are always either white or selected.
see more
17 replies | 325 view(s)
Today,
10:17 AM
afiasiddiqa
replied to a thread
how to add categories and sub categories in subform
in
Forms
I have added the zip file . Many Thanks
see more
9 replies | 68 view(s)
Today,
10:02 AM
mike60smart
replied to a thread
how to add categories and sub categories in subform
in
Forms
Hi Can you upload your latest version of the database?
see more
9 replies | 68 view(s)
Today,
09:51 AM
afiasiddiqa
replied to a thread
how to add categories and sub categories in subform
in
Forms
Thank you so much for the detailed reply and explaining it to me. I have designed the database as per your advise. I had the Main form designed on...
see more
9 replies | 68 view(s)
Today,
09:26 AM
June7
replied to a thread
If Statement Ignores Boolean Values in Access VBA
in
Programming
Micron, unbound controls do not ignore DefaultValue setting. Try it.
see more
17 replies | 325 view(s)
Today,
09:07 AM
orange
replied to a thread
how to add categories and sub categories in subform
in
Forms
In addition to the comments received so far, I recommend no field names with embedded spaces. They will come back to haunt you.
see more
9 replies | 68 view(s)
Today,
08:48 AM
davegri
replied to a thread
If Statement Ignores Boolean Values in Access VBA
in
Programming
@Micron said: And that certainly includes ChatGPT!!
see more
17 replies | 325 view(s)
Today,
08:43 AM
Micron
replied to a thread
If Statement Ignores Boolean Values in Access VBA
in
Programming
I don't think that is reliable. Try this: choose a procedure that refers to a form control. Make sure your code is compiled and saved. Edit the form...
see more
17 replies | 325 view(s)
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
9 replies | 68 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 | 820 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
9 replies | 68 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 | 820 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 | 820 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 | 820 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
9 replies | 68 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
9 replies | 68 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 | 820 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
17 replies | 325 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
17 replies | 325 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
17 replies | 325 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
17 replies | 325 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
17 replies | 325 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
17 replies | 325 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
17 replies | 325 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
17 replies | 325 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
17 replies | 325 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
17 replies | 325 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
17 replies | 325 view(s)
More Activity
No More Results
No Recent Activity