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,
01:31 PM
Welshgasman
replied to a thread
how to add categories and sub categories in subform
in
Forms
I get picked up on several things I post here and elsewhere, so no need to take it personal.
see more
17 replies | 137 view(s)
Today,
01:16 PM
Welshgasman
replied to a thread
how to add categories and sub categories in subform
in
Forms
The fact the it should be a continuous form and not a datasheet. Surely either would suffice?
see more
17 replies | 137 view(s)
Today,
12:53 PM
mike60smart
replied to a thread
how to add categories and sub categories in subform
in
Forms
Hi Welshgasman Well he did say this "Not super hard but does take some tricks. Here is an example where they select a group from the first combo...
see more
17 replies | 137 view(s)
Today,
12:42 PM
Welshgasman
replied to a thread
how to add categories and sub categories in subform
in
Forms
No, I am genuinely curious as to why you said that? My understanding is he was saying the opposite, from the quote I posted?
see more
17 replies | 137 view(s)
Today,
12:25 PM
mike60smart
replied to a thread
how to add categories and sub categories in subform
in
Forms
Hi Welshgasman MajP did make the comment but in his example he shows how to use Continuous Form. Is he wrong as well or do you just like nit...
see more
17 replies | 137 view(s)
Today,
12:14 PM
Welshgasman
replied to a thread
how to add categories and sub categories in subform
in
Forms
Really Mike? Care to explain why? especially when MajP made this comment in this post...
see more
17 replies | 137 view(s)
Today,
11:12 AM
mike60smart
replied to a thread
how to add categories and sub categories in subform
in
Forms
The SubCat Combobox is made very narrow to only display the dropdown arrow. Then in the after update of the Combobox there is an event that...
see more
17 replies | 137 view(s)
Today,
11:08 AM
afiasiddiqa
replied to a thread
how to add categories and sub categories in subform
in
Forms
Hi, Thank you so much. Is InjurySubCat_FK hidden behind SubCat? as when i click on just drop down arrow the it shows the properties with query in...
see more
17 replies | 137 view(s)
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
17 replies | 137 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
17 replies | 137 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 | 362 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
17 replies | 137 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
17 replies | 137 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
17 replies | 137 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 | 362 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
17 replies | 137 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 | 362 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 | 362 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
17 replies | 137 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 | 833 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
17 replies | 137 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 | 833 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 | 833 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 | 833 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
17 replies | 137 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
17 replies | 137 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 | 833 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 | 362 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 | 362 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 | 362 view(s)
More Activity
No More Results
No Recent Activity