Search results

Catalin. Why should I not try to see it from Jon’s perspective? If I can advise Jon on some of the problems involved with making the change then that will be less work for Jon. I would like other people to do some of the work and advise Jon as well. Not just say “It would be nice if” and have...

I think it is a matter of balance. We may all want something but would we pay for it? Such a change would cost Jon time (money) even if all he had to do was to find out if it would be cost effective. To find out if it is cost effective one of the things he would have to do is look at both the...

Can someone annotate this code? Certainly…”It is not VBA.” A second annotation: We need to be careful when asking questions. >> I've read it over a few times and I still can't figure out why the underlined isn't redundant...<< The point is that some of the underlined is redundant and some of...

I’m not trying to be entirely negative here but it would take Jon (?) a fair amount of time to make that change. There is still one bug with that display on Bytes: If the line numbers are visible then a copy and paste to the VB editor has a Tab character (4 spaces?) at the start of each line...

To say for sure, I would need to see a copy of the database in Access 2003 version. As a pure guess: Clicking on the detail section may not save changes made to a Text Box. In fact, if one of the Text Boxes is still the Active Control then its After Update event would not have fired and you...

A small Access 2003 demo is attached. Suggest contacting Microsoft. :confused: Chris.

I can’t really say why but it also does that in Access 2003. Wrapping the option group return value in the Val function seems to fix it:- Val(Forms!frmStatus!optStatus) Chris.

Dave. I am talking about this link:- http://access.mvps.org/access/bugs/bugs0005.htm which is the link I posted in post #21. Anyone have any thoughts about that link? Chris.

Did you make the after update events Public? Chris.

Galaxiom. By now I think everyone knows of your dislike for Hungarian Notion. :D And some comments in code can be just ridiculous. Both deserve their own place in the Sun, but also could be a distraction from this thread. ----------- jdraw. >>As Chris has said, the requirement that you MUST...

Dave. No, I mean the link in post #21. Chris.

The code in post #5 should work fine at all levels of Form or subform. Chris.

Well, that’s one of the problems with posting links without testing. That document is already in Access help available using the F1 key on Object. The url says Access-help but it is VB help not VBA help. The code is in error for VBA with Access. Yet people might say “I read it on a Microsoft...

Dave. Because it is hearsay, I will not require anyone to believe this. I can test that code with 41 Forms and there was no memory creepage without the Set to Nothing. I can run it continuously and still get no out of memory. I can’t test it any other way but that is the result I get, no...

Doc. If I assumed proof by posting a link to someone saying it is not necessary then I would be as gullible as those who post links to someone saying it is necessary. That is the very thing I am trying to get away from. I’m trying to get away from the idea that all we need is for someone to...

I would not like to see the current code box changed. I think its real value is in showing exactly the code as written without additions or deletions. To my way of thinking, it should be an exact copy and paste, to and from site, without alteration. Chris.

I think this what you are trying to do and the event procedures will need to be Public:- Private Sub Detail_Click() If Me.ActiveControl.ControlType = acTextBox Then If Me.ActiveControl.AfterUpdate = "[Event Procedure]" Then CallByName Me, Me.ActiveControl.Name...

Are you certain that every [CI Name] actually contains a period? If one of them doesn’t then the Left() function would be using a value of -1. Chris.

I think the process, as described so far, is incorrect. If it is early stages in the life of the database then this is how it did it in the past. With one exception, all of the commercial databases I have created have been ‘databases at a distance’. What the term ‘databases at a distance’...

>>What is the "!Code" and " intType"?<< ‘Code’ is the name of the Field in Table tblCodes. Each Code in the table has a Type flag which has a value of 1 or 2. ‘intType’ is passed to Function IsCode() and it has a value of 1 for DishNet or 2 for Video. ‘intType’ is used to open a recordset of...