Search results

Yea, probably better. I'll keep this thread for the RC menu stuff, and let you know about the CDs offline.

Still no luck finding the CDs, but I'm at work and have gotten my old FTP server started. The CD images are all there, but it's an ancient SUSE configuration, with something screwed in the root user, so I can't login as that, even though I was able to reset the root password and thereby get...

No luck yet. I went through my music CD collection, because they were in there for a while, but it's all music now. All the tech CDs are somewhere else, and I don't know where right now, since I almost never use them any more. But I'm sure I didn't throw them out, and I live alone, so they must...

Let me look around - I'm an awful packrat, and rarely throw out anything that has the slightest chance of being useful. It's probably here somewhere, and I think I copied it onto one of my servers back then as well.

I have that book (both volumes) and it is a gold mine of information. That's where I got the original idea to build these things. Unfortunately, it covers this particular subject fairly sparsely, and devotes some of the space to the graphic interface, which has been removed in newer versions...

Next phase - I tried maxing out the cascade level, by adding a control, adding another control to that and another and so on. Got to just over 6,000 before it crashed. The visual is kind of comical - it kicks out and down, expanding across the screen to the right edge, then turns back to the...

Thanks - it helps a lot to discuss these things with someone. At the very least, I have to get my own thoughts in order well enough to explain them, which often starts me on a viable path. I'll post back here with how it turns out.

Yeah, I understand - wading through never-ending error messages is a monumental pain in the fundament. I'm not sure why it's misbehaving like that, although I suspect it's a language problem - it works flawlessly on all machines here, but they are all running a Czech OS and Czech Office package...

That message is when the database detects something internal. It's just a warning from my error-handling routine that an unexpected error occurred, and the behavior may become erratic, so it would be better to close and re-open the database. The user of this app is a somewhat fractured...

Not very long - a few minutes. Just ran my setup with 10 textboxes with each having its own RC menu, and it crashed at 1,214 - roughly a tenth of how far it got with only one textbox or one menu on ten textboxes. It was also faster to execute, but that may be partly because I have only one...

Just ran it again, with 10 textboxes using the same RC menu. This time it made it to 15,916 controls added before crashing, so it seems that it's not some hard-coded limit in Access - just running off the deep end, past what the designers ever thought might happen,or maybe didn't even think...

Yes, that is the same error - add method failed. I'm not all that surprised that the number is different. It's probably not a well-defined limit, like the number of controls per form, so it's probably just running out of resources somewhere. I'm running Access Professionl Plus 2010 on a 64-bit...

Check the instructions I wrote again - you have to UNZIP the individual pieces FIRST, then join the unzipped pieces, using that website, into a zipped total file, then unzip that to get the final .accdb file. Just tried it and it works fine, but you cannot join the the four zipped attachments...

That is the terminology used by Microsoft. Adding an item to an RC menu is called adding a control. In my original post, I quoted this line as the one that crashed: Set AEp = .Controls.Add(msoControlPopup) I executed that 15,626 times in my new test database before it crashed, and all...

Just a brief note - I made an empty database with a single form and a textbox, to which I added RC controls in code. It just crashed, with 15,626 controls added. The textbox works. Takes several seconds, but that RC menu pops up and I can scroll through the controls.

Thanks, it's worth a try. I'll add it to the experiments in my test database, although the deletes are quick, and the adds are where it crashes. But it's something to test, and see if deleting the entire root command bar changes the situation in any way.

Thank you, I looked at that. Obviously, such a technique works well, but as I wrote earlier, it uses an unacceptable (for me) amount of screen real estate, and necessitates lots of extra clicking. I appreciate the link, and I know how to do that, but I don't want to. The reason I started this...

Okay, I'll post it when I get the data fixed up. AccessForums is a completely different site - do you think linking to unrelated forums is proper? I've also asked the question on StackOverflow, because I've actually been battling this for quite a while, and always ended up with nothing. For a...

Acer Pseudoplatanus is a sycamore maple. Lichens may or may not grow on any particular tree - some of them are extremely fussy about conditions, and even a small change in temperature, humidity, sunlight, acidity or any number of other things can suddenly make it inhospitable for a particular...

I can hash up the data in the tables and send along the actual database, if you think it will help, but I can't do it tonight. Messing up the data to the point where it is not identifiable will take a bit of time, and I have some people waiting for something right now. I don't care about the...