Search results

Yep, same here - or just continue holding Ctrl-z down on the third try; the keyboard spams another Ctrl-z.

@The Doc Man Great. This means it'll never be fixed. I thought perhaps I could simply cancel any use of Ctrl-z in the KeyDown event, but the bug occurs in precisely the same fashion if, instead of using Ctrl-z during the steps to reproduce it, I use the Undo Typing button in the Quick Access...

One thing is not clear in the steps to reproduce the issue. 12. Repeat steps 03 through 07 This is done to demonstrate that the conditions that allow the bug to exist are not reset when the Form is closed. In other words, if I close the Form before issuing the third Ctrl-z, then reopen the...

Thank you, jleach. That would be much appreciated. Agreed, BeforeUpdate is the place for validation (after the fact, so to speak). My goal is to manage the state of a nearby button. If either of two textboxes contained invalid data, the "Add" button is disabled. Once valid, the "Add" button is...

I am creating new tree nodes based on the text in a pair of textboxes, actually. I do plan to make use of AfterUpdate at some point. However, it is the wrong event in which to validate/correct user input. And it is that validation/correction I'm working on at the moment. I have studied the bug...

I think I've found a decent way of getting around this odd behavior. In the Form's KeyDown event, if Ctrl-z is pressed, I call the TextBox's Undo method. I already have button state management code in the Undo event handler. Calling the Undo method fires the Undo event. I'll probably run into...

Well my goal is to use a couple of TextBoxes to add new child nodes to a nearby TreeView. As such there are no Fields in the underlying RecordSource to bind them to, and the Undo event is not fired. I did experiment with placing these TextBoxes on a Subform, binding them to a local Table. The...

I'm using: Microsoft Office Professional 2016 Version 1710 (Build 8625.2139 Click-to-Run) It is possible this odd behavior has always existed, but in the many years I have developed Access applications, I have not noticed it. I have placed a TextBox on a Form. I note this behavior whether the...

I calculate a width using the Form's .InsideWidth property. It works just fine, so it's not really an issue. The behavior is another matter. It would be quite a tedious read were I to fully detail the misbehavior. It will suffice to say that, after manually setting the control's width, the...

Consider please a Form with two controls on it. On the left is any control - say, a TextBox. On the right is another TextBox. LeftTextBox anchoring is Stretch Down. RightTextBox anchoring is Stretch Down and Across. I'd like to show/hide LeftTextBox, the effect being that the control is...

Having a heck of a time trying to find the answer to what seems like a really simple thing to do: After defining a range of a single point (blinking cursor), I set the range's .Text property to some string. No problem here. I then want to position the cursor at the end of that text. The text...

Not much in the way of complexity, if you dismiss the fact that I'm checking the .Dirty property of a custom object. One could be checking the .Dirty property of a bound subform, or the .Enabled property of a command button, etc. Private Sub lstReports_BeforeUpdate(Cancel As Integer) Dim frm...

Hi all, this is something I've had trouble understanding, despite years of not understanding it... I have a form with one listbox and one subform control. Listbox contains list of reports. Subform control contains an options form for whichever report is selected in the listbox. None of the...

Thanks very much. I'll experiment with this. Looks like it should do what I need.

Thank you very much. In the meantime, I'll be taking on the task you describe. Cheers.

Is it possible to create a range consisting of all cells with duplicate values contained in a different range? Conversely, is it possible to remove all non-duplicated cells from a range? I foolishly posed this question at the tail end of a post regarding another matter, so I'm creating a new...

Thanks again. Yes, I'm extending your function (I've actually added a second column to be tested for the criteria) and was just testing precisely the edit you've posted here. The results are what I need. Truthfully, though, I am attempting to do a bit more. I'm taking this a step at a time...

Correction: I misread the Offset function. Told ya I'm not used to this :D So the loop adds the cell to the right, which is actually what I need. The resulting range, however, does include one cell from the criteria column (in a nutshell) Many thanks for your help!

chergh, Thank you for your help. I really appreciate this. I tested your function. Following are the results. The function call, set myRange = bigrange(worksheets("Sheetname").range("A"), "Test") caused a run-time error 1004. Since the function is asking for Startrange, I assume it needs...

In that case, you will need a structure which contains each cell in the given column, to iterate through. I would imagine the best object to use would be a Range. You would likely do this iteration with a For Each loop. This might be wrapped in, as you suggest, a Do Until loop, or you might...