Prev: Adding/Editing Empty String Fields
Next: Primary Key with Symbols
From: Richard on 1 Mar 2010 22:58
Hi

I have a listbox populated with contact names. When I click 'd', it goes to
the names that starts with 'd'.

How do I duplicate it in a continuous subform with a textbox?

Many thanks in advance
Richard
From: Stefan Hoffmann on 2 Mar 2010 04:05
hi Richard,

On 02.03.2010 04:58, Richard wrote:
> I have a listbox populated with contact names. When I click 'd', it goes to
> the names that starts with 'd'.
How do you 'click' a 'd'?

> How do I duplicate it in a continuous subform with a textbox?
Enable the forms key preview property on the Event tab. Add an event
procedure for the Key Pressed event, e.g.:

Private Sub Form_KeyPressed(KeyCode As Integer)

Dim rs As DAO.Recordset

Set rs = Me.RecordsetClone
rs.FindFirst _
"[fieldNameBoundToYourTextBox] LIKE '" & Chr(KeyCode) & "*'"
If Not rs.NoMatch Then
Me.Bookmark = rs.Bookmark
End If
Set rs = Nothing

End Sub


mfG
--> stefan <--
From: Richard on 3 Mar 2010 23:11
Dear Stefan

Many thanks for your help.

Richard

"Stefan Hoffmann" wrote:

> hi Richard,
>
> On 02.03.2010 04:58, Richard wrote:
> > I have a listbox populated with contact names. When I click 'd', it goes to
> > the names that starts with 'd'.
> How do you 'click' a 'd'?
>
> > How do I duplicate it in a continuous subform with a textbox?
> Enable the forms key preview property on the Event tab. Add an event
> procedure for the Key Pressed event, e.g.:
>
> Private Sub Form_KeyPressed(KeyCode As Integer)
>
> Dim rs As DAO.Recordset
>
> Set rs = Me.RecordsetClone
> rs.FindFirst _
> "[fieldNameBoundToYourTextBox] LIKE '" & Chr(KeyCode) & "*'"
> If Not rs.NoMatch Then
> Me.Bookmark = rs.Bookmark
> End If
> Set rs = Nothing
>
> End Sub
>
>
> mfG
> --> stefan <--
> .
>
From: De Jager on 13 Mar 2010 12:55

"Richard" <Richard(a)discussions.microsoft.com> wrote in message
news:88C24F9B-FCF7-4F5B-8D23-BAB4495E2591(a)microsoft.com...
> Hi
>
> I have a listbox populated with contact names. When I click 'd', it goes
> to
> the names that starts with 'd'.
>
> How do I duplicate it in a continuous subform with a textbox?
>
> Many thanks in advance
> Richard

From: joelgeraldine on 17 Mar 2010 09:33
llmo*ùp
*


"Richard" <Richard(a)discussions.microsoft.com> a écrit dans le message de
groupe de discussion : 88C24F9B-FCF7-4F5B-8D23-BAB4495E2591(a)microsoft.com...
> Hi
>
> I have a listbox populated with contact names. When I click 'd', it goes
> to
> the names that starts with 'd'.
>
> How do I duplicate it in a continuous subform with a textbox?
>
> Many thanks in advance
> Richard

 | 
Pages: 1
Prev: Adding/Editing Empty String Fields
Next: Primary Key with Symbols