Search results

http://social.msdn.microsoft.com/Forums/office/en-US/e12a48d2-cec0-4792-9ae7-342d827e61ca/access-97-sr2b-causes-massive-registry-corruptionwin-7 Chris.

Helystra. You might consider asking one question at a time in a new thread. The people trying to help you vary in their level of expertise in any given area. They should not be required to read through all of a thread such as this one. Try to be explicit and concise with a single thought, it...

>>If someone wants to box, they are only hurting themselves.<< Not if they are any good at it. :D Chris.

>>7 types of weights<< Of course I’m guessing here but what happens if you ever need 8 or 9 or…? You would not want to keep changing the Form so they might as well be in a subform. There is a small A2003 demo attached which brings all weights forward when a new one-side record is created. It...

Galaxiom. They are all bubble and froth; they couldn’t understand it if it bit them on the arse. For them it’s all repeat, repeat, repeat with no understanding. They have no idea what they are saying. In the short term they might get offended and complain or simply run away. In the long term...

Doc. In reality I do not mind being called a liar, if you did or not say so. What I do mind are posts which state fussy facts and your last post seems to be full of them. Some of the wording in your reply is bordering on the ridiculous. “Complex sensitivity to context” what a load of crap.Do...

Nobody seems to want to have a crack at it so here is a result. We could also use the database properties but that might be too much work for some… Option Explicit Option Compare Text Public con As New clsCon Sub TestIt() Dim strPropName As String Dim strPropText As String Dim...

Global variables are not lost on error under any circumstance. If an unhandled error occurs in an MDB or ACCDB file we can enter debug mode and the global variable still has its value. The error has occurred but the global variable has maintained its value. Furthermore, if global variables...

If you want to drive the Shortcut Menus from table data there is a late bound demo here:- http://www.access-programmers.co.uk/forums/showthread.php?t=202673 Chris.

Mark. No, I am not free to dispute your interpretation simply because you have not given one. And that is one of the problems with making blanket statements like “VBA does not support inheritance.” Clearly it does, at least to some degree. But it certainly could give VBA a bad reputation and...

Mark. The problem I’m speaking of has just been demonstrated. You have posted links to Wiki articles as if to say “Here, Chris, learn all about it.” Well, I had read those articles many times before but I do not go around needlessly throwing big words into conversations. Quite frankly I find...

Understanding the past may very well depend on how we understand the present. Sean Carroll on the Higgs field… (He is a good speaker.) 27 minutes and 55 seconds into this… http://www.youtube.com/watch?v=RwdY7Eqyguo Worth watching the whole thing but it still doesn’t mean it’s the whole...

Mark. Why do you say that it’s “Too bad VBA doesn't support inheritance.” Without defining what you mean by inheritance it becomes rather ambiguous and if you do define what you mean by inheritance then it becomes just your interpretation. And I don’t want a heap of Wiki articles to read...

There might be something else going on here but by the description it seems this would do:- Public Sub LockControls(ByRef frm As Form) Dim ctl As Control For Each ctl In frm Select Case TypeName(ctl) Case "Textbox", "Combobox", "Listbox"...

I can not open the attachment by Apr Pillai, which is a pity because they are usually very good. So I’m just going to go with the assumption that the Form should show a summary of one week of bookings, in the style of a continuous Form. This is not a continuous Form but, hopefully, it looks...

Is PostItGotFocusHandler2() a Function or a Sub? Chris.

Well, this was fun…. I think I’ll have to call this Grouped Forms rather than Continuous Forms. Anyway what it amounts to is one subform per record and in this case that means 8 subforms. Of course there can be more than 8 records; it’s just that only 8 are visible at any one time. That also...

I doubt it… :D Chris.

By no means with “negative waves” but I don’t think you will be able to find a way to do it in a normal Access Continuous Forms (ACF). I mean that in a positive sense because a lot of time can be wasted on looking for something which doesn’t exist. If it existed then someone would know about...

Continuous Forms are just a concept that the user doesn't really want or need to know about. So all we have to do is make it look like a continuous form to keep them happy. Drag, drop, resize and save on what looks like a continuous form. It is going to take a lot more work but it's doable...