Search results

I am able to do this with a form but not a subform. Any ideas how to do the same with the subform?

I have some texboxes that I want them to appear in datasheet view with a specific order. How can I control the order given that I tried tab index and tab order but did not achieve the desired result?

Hi all, I have a form consisting of textboxes and I open it in datasheet view. I want to be able to ctrl+v something if I am selecting only one control(one textbox). But if several texboxes are selected , or the whole record ...then I want to pop up a user-friendly message and disable...

I initialized a control Dim ctrl as Control then added If (ctrl.ItemsSelected.Count > 1) Then But the control need to be initialized and I guess there is still something missing. Any help please?

Something like Dim Pasted As Boolean Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer) Pasted = KeyCode = vbKeyV And Shift = acCtrlMask End Sub Private Sub Form_BeforeInsert(Cancel As Integer) If (the count of active controls are more than one) Then <--what VBA code...

The approach of sending a message after capturing Ctrl+V has a problem: I want it to not paste only if the whole record is selected , but to paste in a control(single field) is actually needed.

The approach of sending a message after capturing Ctrl+V has a problem: I want it to not paste only if the whole record is selected , but to paste in a control(single field) is actually needed. I thought that by putting it in the form's event rather than control , this would be it . but it...

It turns out that the solution of disabling the context menu is problematic since I delete other functionalities with it . So as you suggested, after disabling it I can create my own which would be the same as the old one without the paste functionality. Can you please help with this one...

Thank you very much for your immediate help. Is there any way to handle the right clicking of a menu using a mouse and checking any of the menu items in it ? I mean if I will be able to do it with a context menu I created, then perhaps I can do the same with an existing menu ?(Just be able to...

I am not sure how do I create a context menu without paste and remove this one (since this is a client application I am supporting so I am not sure if it is OK to do this but I want to learn how to anyways). Also , besides this is there a way to do this by handling this if we assume I will not...

Hi all, I want to handle the event when I right click and choose "Paste" to pop up a message to the user that he cannot paste; disabling the pasting functionality. I understand that the Button parameter refers to right or left button , but I need further help on which event to best use...

The problem was that I put a breakpoint and on any key press I would jump straight away to the event handler without waiting for the next press after Ctrl. When I did not add a breakpoint , I got the message "Can't paste"

Thank you vbaInet , I misread the previous post - sorry my mistake :) It is working fine now ...will move to the deletion and mouse event handling

I want the application to wait till I press Ctrl then V before it fires the Key Down event and not as soon as I press any key . How can I handle this?

Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer) If Shift = acCtrlMask And KeyCode = vbKeyV Then KeyCode = 0 Shift = acShiftMask MsgBox "Can't paste" End If End Sub Form's Key Down after checking Key Preview to Yes.

As soon as I press any key, the event is fired... it doesn't way for a Ctrl+C or +V so it never enters the If Condition Any suggestions?

The arguments in Key Down event are Key Code and Shift. So we can use Shift instead of the intKeyControl? I mean, you just declared a long variable - what will ever make the condition If intKeyControl = vbKeyControl Then true?

Thanks for your response, vbaInet Excuse me if I am new to this (the thing is that I am supporting a client's application so I did not create the application nor can I alter the original settings). As far as I know, the form can be viewable as a datasheet and as other forms but what is a...

pr2-eugin, Thank you :) Actually, I have tried the Form's Key Press event handler which seems the most relevant and this did not trigger any event. So I was wondering how to do it. I was just checking now the Detail event but this doesn't seem to work either. Regarding the before delete , I...

Hi all, I want to handle the event when a user clicks Ctrl+C for a complete record in a datasheet then goes to a new record and presses Ctrl+V. I have added the following Private Sub Text40_KeyPress(KeyAscii As Integer) Select Case KeyAscii Case 22 MsgBox "Please copy and paste the desired...