? Programme language alternative to using Control and Apostrophe keys

[dave k]

I often use the Control and Apostrophe keys to enter the value from the
same field of the previous record in a form. I would prefer to use a
mouse and the double click function. Can anyone help please with the
programming language to type in the Double Click Event procedure
section.

I hope this is clear enough. Many thanks.

Dave k

[Allen Browne]

Dave, if you know nothing about programming, you could try creating a macro.
In the macro, use the SendKeys action, and type this in below it:
^'
(That's a Shift+6, followed by a single quote.)

Then set the DblClick property of your text box to the name of this macro.

If you want a field to automatically default to the last value, see:
http://www.mvps.org/access/forms/frm0012.htm

If you want most of the fields to default to the last value, see:
http://allenbrowne.com/ser-24.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"dave k" <ke*******@yahoo.co.ukwrote in message
news:11*********************@11g2000cwr.googlegrou ps.com...

>I often use the Control and Apostrophe keys to enter the value from the
same field of the previous record in a form. I would prefer to use a
mouse and the double click function. Can anyone help please with the
programming language to type in the Double Click Event procedure
section.

I hope this is clear enough. Many thanks.

Dave k

[dave k]

Dear Allen

Many thanks for your suggestion.

I have set up a macro (called Keystrokes) exactly as you suggested. I
have chosen this from the drop down box in the double click section for
the fields I want to update but it doesn't work. Do I need to add an
instruction in the Event Procedure to open the macro?

dave k
Allen Browne wrote:

Dave, if you know nothing about programming, you could try creating a macro.
In the macro, use the SendKeys action, and type this in below it:
^'
(That's a Shift+6, followed by a single quote.)

Then set the DblClick property of your text box to the name of this macro.

If you want a field to automatically default to the last value, see:
http://www.mvps.org/access/forms/frm0012.htm

If you want most of the fields to default to the last value, see:
http://allenbrowne.com/ser-24.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"dave k" <ke*******@yahoo.co.ukwrote in message
news:11*********************@11g2000cwr.googlegrou ps.com...

I often use the Control and Apostrophe keys to enter the value from the
same field of the previous record in a form. I would prefer to use a
mouse and the double click function. Can anyone help please with the
programming language to type in the Double Click Event procedure
section.

I hope this is clear enough. Many thanks.

Dave k

[Allen Browne]

You're right: just tested, and the SendKeys doesn't work.

This example shows how to copy the value from the last record in the form
into the new record by double-clicking on the Surname field:

Private Sub Surname_DblClick(Cancel As Integer)
If Me.NewRecord Then
With Me.RecordsetClone
If .RecordCount 0 Then
.MoveLast
Me.Surname = !Surname
End If
End With
End If
End Sub

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"dave k" <ke*******@yahoo.co.ukwrote in message
news:11**********************@38g2000cwa.googlegro ups.com...

Dear Allen

Many thanks for your suggestion.

I have set up a macro (called Keystrokes) exactly as you suggested. I
have chosen this from the drop down box in the double click section for
the fields I want to update but it doesn't work. Do I need to add an
instruction in the Event Procedure to open the macro?

dave k
Allen Browne wrote:

>Dave, if you know nothing about programming, you could try creating a
macro.
In the macro, use the SendKeys action, and type this in below it:
^'
(That's a Shift+6, followed by a single quote.)

Then set the DblClick property of your text box to the name of this
macro.

If you want a field to automatically default to the last value, see:
http://www.mvps.org/access/forms/frm0012.htm

If you want most of the fields to default to the last value, see:
http://allenbrowne.com/ser-24.html

"dave k" <ke*******@yahoo.co.ukwrote in message
news:11*********************@11g2000cwr.googlegro ups.com...

>I often use the Control and Apostrophe keys to enter the value from the
same field of the previous record in a form. I would prefer to use a
mouse and the double click function. Can anyone help please with the
programming language to type in the Double Click Event procedure
section.

I hope this is clear enough. Many thanks.

Dave k