Search results

Nope quote is fine.

Post-3 in this thread auto-shrinkwrapped. Trying a quote now and backspacing on the auto carriage line. ; lets see if quote is what it is:

It isn't just the first post. Nor is it when a user views their own post as I don't put any unnecessary return carriages at the end of a post. Again it's no big deal but just out of interest is all. I altered post-1 after Doc's input. post-3 shrinkwrapped automatically. Maybe it's to do with...

I've encountered it quite a bit, some posts appear unnecessarily tall. Though I didn't enter any return characters... it appeared taller. At least on edit it resolved it but I think there may be something going on. Been a while since I posted (apart from recent).

You're right Doc, apologies to the forum. It is by far the best designed I have encountered, & the calibre of users & I am a member of many forums (not just Access). Very fortunate to have found this forum.

Maybe it's because when viewing one's own posts they appear taller?

Is it not a waste of space; causing unnecessary scrolling & wasted time in making it appear so tall. Not the end of the world, but myself personally think it would be better if it was a normal post size; shrink-wrapped css. Says how well designed the forum is if this is my only gripe :).

Thank you both so much for extremely detailed high quality help. As mentioned I did many iterations & playing around massively all day long trying to understand what was going on & just to get it to work. I want to understand classes & events amongst other things. The input I have received from...

Thanks for your patience guys. The trouble is I have done much experimenting making it impossible to explain exactly what I've done. Again thanks for your patience. Also not helped by my first play with a CommandBar... Something along them lines. In @jwcolby54 generous book 'Event Driven...

I believe that would be helpful if I knew the Collection Name & if it was the same as is currently written in the VBA code, BUT I do not & the code is not the same. As I said I changed the names lots of times. So we don't know what the Collection's name is. So the collection's compiled name...

The problem is I created many different collections and classes relating to this particular form. So whatever is currently in the VBA code is irrelevant if you get my drift. Somewhere in the CurrentProject/ CurrentDb I have rogue instances of a Collection and or Classes which I need to find. I...

Thanks bud, it is not a collection class, just a plain old collection. I was wrapping Text Box controls in a class. Assigning an Event to the class & then adding them to a standard collection so the event/ class would stick around. But as i said unhelpfully changed the names lots of times so I'm...

I wrapped all textboxes in my frm.description in a cls to assign a right-click CommandBar menu to all textboxes to save me doing it individually. Then added them to user-defined collection so the right-click event would stay around. The trouble is I was playing around with the cls names &...

Thanks Pete & for the forewarning of cross-tab qry's. Yes I think this will be the best solution for my needs on this.

Thanks; I have complex calculated fields in the query. Having to rewrite each of these obfuscates the complex arithmetic behind the query & costs me severely in time in redefining an already calculated field & makes it much more complex. I'm planning to migrate to MSSQL type db later (not...

Thanks @jwcolby54, I was basing my experience on the most recent .pdf on this post. I see a lot of references to GitHub but have not found a link to it. My humble feedback is the second e.g. insinuates that the code will run, & is detailed in it's step by step process. But there are no...

Thanks for the book @jwcolby54, enjoying it. Obv's in the interest of constructive feedback I'd agree with @Gasman here. Up to p28 & as @Gasman mentioned p27 says that we are able to step through & fire the after_update events; which of course we haven't hooked up the main frm yet... & are not...

Thanks Pete Thanks Pete

Thanks for this, I'm close to finishing Andrew Couch's 'Access 2010 VBA Programming Inside Out'; an excellent book! But I still have not fully grasped events fully as the e.g's in the book were hooked into native Access events. So I'm unclear if all clsEvents need to be hooked or they can be...

Thanks @Edgar, really helpful input. As there are so few items in HeaderTypesT & UnitsT & they will not change to minimize storage I avoided Autonumber & believe this is a rare exception. Cannot believe I did not think of this. I have spent 12 hours a day; over a week trying to recursively...