var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: query by example
I was wondering if its possible in Access 2003 on a from to implement a qbe(query by example) search.
A dropdown box on, lets say a single table displaying one attribute.
when the user now enters for example an "a" all values beginning with "a"should be listened in the drop down box.
Is that possible? Any ideas? Thanks in advance for your help!!
Yep it can be done. Something like this I think:
Private Sub Text2_AfterUpdate()
Dim strSQL As String, qdf As QueryDef
Set qdf = CurrentDb.QueryDefs("QueryName")
strSQL = "SELECT [TableName].[FieldName]" & _
" FROM [Tablename]" & _
" WHERE ((([TableName].[FieldName]) Like '" & [textboxname] & "*'));"
qdf.SQL = strSQL
Me.(ComboboxName).Rowsource = "QueryName"
Last edited by dwil2g1; 06-16-04 at 13:33.
Actually in any combo box if one types in a letter such as "a" the combo box automatically scrolls down to the first entry that starts with that letter(s).