Recent content by KAyers

Hello! Sorry for the repost but I wanted to refine what I was asking for and the ideas I was tossing about to officemates that don't use Access! I have searched the forums, help, and books for a nudge in the right direction but I haven't found anything applicable. I have a request to make the...

Thanks for the tip- no one had mentioned that before. It's unfortunate if that is the reason no one had replied. K As for a solution for anyone interested I found a possible compromise. It seems to be working but if anyone finds a huge hole in the logic please let me know: Option Compare...

Can anyone help me with this?!?!

Another attempt! OK... Instead of trying to build one giant report, I have broken the report into the 3 parts (A, B, and C) which simplifies things. Unfortunately, my attempts to separate out the visibility based on the checkbox results has not worked and they are displaying all- I do have the...

Update! my effort so far... Here is where I have gotten so far. Unfortunately I need a bit more from the results. If a field (which is set to invisible) ends in "A" then U1 must be true so G1 would be visible. "B" can have either U1 or P1 as true (P1 trumps U1) so if P1 is true then G2 would be...

I have created a form with checkboxes controlling the enabling of certain groups of fields. Now that I am constructing the report, I have a subreport which should display a field from group 1 if checkbox 1=true if not it should show a field from group 3. I looked for something similar in the...

While I thank you for the explanation, the condescension was not necessary... I was not dismissing you by asking for something other than the DCount but was under the impression that it would keep the subforms at their constant maximum height and therefore always require scrolling to the bottom...

I'm not sure the DCount is what I'm looking to do- I would rather keep this as simple as possible and have the subforms height resize (perhaps using AutoResize?) to display the data, as little as 0 records and as much as 90ish and highly subject to change. What I'm having problems with is where...

Thank you for the DCount solution... I will try that out and let you know how it works. As for the db- it's not a matter of my Access version but that I can't download zip files at work which makes life more interesting when dealing with dbs.

Hello- (I'm trying to resize a subform automatically depending on how many records it is displaying. It needs to resize to fit all of the contents it displays, but no more. This needs to be done every time the user cycles through records in the main form) so that for each record the subform...

I'm all for good habits- can you give me a sample as explanation because I think I understand what you're saying but I don't want to do something outrageously complicated due to my own ignorance.

AHHHHHHHHHH! Thank you for the fresh eyes! I kept going over the code but I hadn't updated it to include the new buttons or checkboxes that replaced them- I've been looking at it for so long I was blind it! Thank you, thank you! The finished element: Private Sub Form_Current()...

I'm not sure if this is the same issue without looking at the form itself but, here goes... We had a similar issue and it turned out to be as simple as someone hitting the filter button by mistake so they had no idea what was happening when only half the data displayed even though the table was...

Modifications have been made! Thanks for any help- I feel like progress is painfully slow with this issue. I have done away with the buttons and tied them to checkboxes recording true/false in the associated table. The only issue now is that it seems to call ALL group 1 (G1) in the form if the...

Sorry to continue this but can anyone help me keep every group setting (disabled/enabled) separate for each record as someone enters data into the form? The greyed out boxes should be an a la carte menu for the user to make different configurations for each record so that every row on the...