Keith
I add the next code:
Dim strStudentRef As String
Dim strSearch As String
'Check txtSearch for Null value or Nill Entry first.
If IsNull(Me![Text10]) Or (Me![Text10]) = "" Then
MsgBox "Please enter a value!", vbOKOnly, "Invalid Search Criterion!"
Me![Text10].SetFocus
Exit Sub
End If
and now the...
Buineugenio
Last Activity: May 13 '08, 02:58 PM
Joined: Mar 17 '08
Location:
-
Keith
Now I am trying to find and fix, why the form do not open? I how in the actual situation can I use again, without closing, a new search, I want to reset the search and write a new client's name without closing the form, that actually do not open.
Thanks
Buineugenio
Maputo, Mozambique, Africa...Leave a comment:
-
Keith
I delete [forms] from the criteria and works fine. First appear a small popup window asking for the parameter to search, I entered 2 non equal Cliente name and show a datagrid with all of them in the Query. This is more or less what I wanted.
By the moment I am glad with the results. Thanks for your help
Buineugenio
Maputo, Mozambique, Africa...Leave a comment:
-
Keith
Here is the criteria:
[forms].[Cliente].[Text10]
Text10 is the name of the Text box
Cliente is the form's name
Thanks again
Buineugenio...Leave a comment:
-
Keith
The Query opens immediately, I have no chance to write in the text box!
But when I open the Query directly, not using the form, appear a small windows asking for the parameter to search, in this case, the Client's name, when I enter the name, the query works fine. Show all the records in the datagrid with that Client.
They work separately, seems that a link is missing between the form and the query.
Thanks for your...Leave a comment:
-
Keith
I follow your instruction, step by step but when I open the form, only appaer the datagrid with the name of the fields, empty.
Maybe in your instruction something is missing?
Buineugenio
Mozambique, Africa...Leave a comment:
-
Keith
I follow the steps in your answer and every thing work fine!
Now, I have a next step in this same question.
How to add a text box and a command button in the form to find any Client's name entered in the text box?
I think that is possible to do that.
Thanks again, your help was very useful, I get the answer that I wanted, show all records for a Client in a datagrid!
Buineugenio
...Leave a comment:
-
Search form
Dears Experts
I have a small database with one table; the fields are Id, Obra, Material, SNumber, Cliente and several others.
I want a form to search and filter for Cliente = Client; and show all records in a list for this client. Of course my database has several clients.
Any detailed help will be useful for me.
I am beginning to learn Access but I have certain knowledge in programming, in particular, Clipper, Visual... -
Thanks, is that I want, only I need to insert in the code, the searching string from a text box in a form.
Thanks a lot
Buineugenio
Maputo, Mozambique, Africa...Leave a comment:
-
Searching a field via code
Mr Experts
I am a new user using Access and I want to know how is possible search a field using wildcard (*) to find anything begining with a certain char and display in a form showing a list of records.
By example; the name begin with e and there are many records with names beginning with e but they are similars.
Thanks a lot
Buineugenio
Maputo, Mozambique, Africa
No activity results to display
Leave a comment: