Prev: Iff
Next: A good developer's tool?
From: Bobby on 24 Feb 2010 04:12
Hi,
I'm using Access 2007 with Windows XP. I have a pretty uncomplicated
form in continuous forms view, to allow a user to input some simple
data by either typing or clicking on combo boxes.

However, it would also be helpful if he could copy and paste from an
existing record.

Is there anyway in VBA that I can find out if he is pasting rather
that manually entering the data? I want my code to do something
slightly different if he is pasting.

Thanks for any help

Colin
From: Salad on 24 Feb 2010 12:28
Bobby wrote:
> Hi,
> I'm using Access 2007 with Windows XP. I have a pretty uncomplicated
> form in continuous forms view, to allow a user to input some simple
> data by either typing or clicking on combo boxes.
>
> However, it would also be helpful if he could copy and paste from an
> existing record.
>
> Is there anyway in VBA that I can find out if he is pasting rather
> that manually entering the data? I want my code to do something
> slightly different if he is pasting.
>
> Thanks for any help
>
> Colin

A weird request. This might get you startedfrom the keyboard input.
You would need a method to trap from a menu.
Private Sub Text0_KeyDown(KeyCode As Integer, Shift As Integer)
If KeyCode = 86 And Shift = 2 Then
msgbox "You pressed Ctrl+V on " & Me.ActiveControl.Name
End If
End Sub
From: Bobby on 25 Feb 2010 03:22
On Feb 24, 5:28�pm, Salad <sa...(a)oilandvinegar.com> wrote:
> Bobby wrote:
> > Hi,
> > I'm using Access 2007 with Windows XP. I have a pretty uncomplicated
> > form in continuous forms view, to allow a user to input some simple
> > data by either typing or clicking on combo boxes.
>
> > However, it would also be helpful if he could copy and paste from an
> > existing record.
>
> > Is there anyway in VBA that I can find out if he is pasting rather
> > that manually entering the data? I want my code to do something
> > slightly different if he is pasting.
>
> > Thanks for any help
>
> > Colin
>
> A weird request. �This might get you startedfrom the keyboard input.
> You would need a method to trap from a menu.
> Private Sub Text0_KeyDown(KeyCode As Integer, Shift As Integer)
> � � �If KeyCode = 86 And Shift = 2 Then
> � � � � �msgbox "You pressed Ctrl+V on " & Me.ActiveControl.Name
> � � �End If
> End Sub- Hide quoted text -
>
> - Show quoted text -

Thanks for the reply. Life would be boring if we all asked the same
old questions!! lol.

The reason for asking is that I want to record how often the user uses
copy and paste as opposed to manually entering the data. Also, I have
a before insert event on the form, which works fine if you enter the
data manually, one field at a time, but falls over if you paste the
whole line.

Thanks

Colin
 | 
Pages: 1
Prev: Iff
Next: A good developer's tool?