Solved Dropdown list

[Springblossom]

Hello dear accessworld friends,

Could you please help me with a dropdown list, where by writing a word, all the possible results having that word in them, appears in the dropdown list?

 

[theDBguy]

Do a search on "FAYT" in this forum.

 

[Springblossom]

Do a search on "FAYT" in this forum.

Thank you theDBguy.

 

[theDBguy]

Thank you theDBguy.

Let us know how it goes.

 

[arnelgp]

see this also.

 

[Springblossom]

Let us know how it goes.

see this also.

Thank you. I will try it now.

 

[Springblossom]

see this also.

Could you please guide me through the steps?

 

[oleronesoftwares]

SELECT wordsearch.word
FROM wordsearch
GROUP BY wordsearch.word
HAVING (((wordsearch.word) Like '*' & [Forms]![Query1]![searchtext] & '*'));

Try the sql above, your combo box will be based on a query similar to it.

In the sample , you are selecting from a table called wordsearch, field called word

The form with the search text box is called query1, and the search text box is called searchtext.



Finally in VBA do the following
On the after update event of the search text box, you have to requery the combo box e.g
combobox1.requery

 

[Gasman]

Private Sub ProjectName_Change()

If Nz(Me.ProjectName.Text) = "" Then
Me.Form.ProjectName = ""
Me.ProjectNameOn = False

ElseIf Me.cboProjectName.ListIndex <> -1 Then
Me.Form.ProjectName = "[ProjectName] = " & _
Replace(Me.cboProjectName.Text, "' ", """) & "' "
Me.ProjectNameOn = True
Else
Me.Form.ProjectName = "[ProjectName] Like '*" & _
Replace(Me.cboProjectName.Text, "'", """) & "*'"
Me.ProjectNameOn = True
End If
Me.ProjectName.SetFocus
Me.ProjectName.SelStart = Len(Me.cboProjectName.Text)


End Sub



In this code how can I show that the [ProjectName] is from a table called projects?

Please start using code tags and indentation.

 

[Springblossom]

Let us know how it goes.

It is not going well. I can not edit the codes correctly. It ends up in multiple errors each time I tried for the past 6 hours.

 

[MajP]

Post in thread 'FAYT for Multi Column combo code from MajP question' https://www.access-programmers.co.u...o-code-from-majp-question.319205/post-1781383

Requires one line of code

 

[Springblossom]

Post in thread 'FAYT for Multi Column combo code from MajP question' https://www.access-programmers.co.u...o-code-from-majp-question.319205/post-1781383

Requires one line of code

Should I enter the code in the on click, after update or on Dbl click? or all of them are connected?

 

[MajP]

None

 

[arnelgp]

Could you please guide me through the steps?

i made some remarks on the code of form Customers.
open the form in Design view and see the Load Event
of the form.

 

[arnelgp]

if you can Upload your db, i will help you set it up.

 

[arnelgp]

i did not test it since there are no table.

 

[Springblossom]

Thank you very much. It is working perfectly.

 

[Springblossom]

i did not test it since there are no table.

Would you please help me with doing the same to the employeename drop down list?

 

[arnelgp]

i also did it with employeename. see the demo.

 

[Springblossom]

Thank you very much.