Search results

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...

Willknapp. There are errors in your posted code:- Post #8. strFile is passed in but you are testing for strFilename. Post #8 If Not Dir(strPath & strFilename) = "" Then Kill strPath & strFilename (You say: that specifically refers to the Dir call. But how do you know that it doesn’t refer to...

Well, specifically the proof of this from post #9:- >>This is where two basic concepts come into play. First, when you open a structure, you close it. Like.... rsX.Close But then, after you close it, you need to tell Access that you are done with the data structure - so.... SET rsX = Nothing...

Tony. As far as I can see, with Option Explicit turned off, all variables would be Variants and there is nothing to set any of them to Class MyStuff. Hence, I don’t think that it would be possible to get at the variable Name in Class MyStuff. Chris.

Doc. Yes, post a link if you like but there is already something on this site which might help:- http://www.access-programmers.co.uk/forums/showthread.php?t=225415 There is even a demo for people to test. And on my SkyDrive site there are plenty more demos which use pointers to other Objects...

Doc. Please try to prove any of that with an uploaded posted coded solution which can be substantiated by others. Chris.

Making guesses is fine but they must be followed by testing else they remain just guesses. That is why I asked you to make your changes to the database I posted and post it back. I think if you had done that then you would have picked up the deletion problem. Yes, it is confusing, even down to...

Well, that’s what I thought you meant but it is incorrect. Records could still be deleted so:- Me.ctlForm.Form.AllowDeletions = False would be required if the Form’s RecordsetType was in Dynaset mode. So, why don’t we just leave it up to the original poster as to which way they wish to go...

I do not understand this point:- >>Locking the subformcontrol and changing the RecordsetType to Snapshot are two different ways of achieving very similar user experiences. Locking the control and dispalying the dynaset will reflect updates to the records. The Snapshot won't. Either way the data...