Search results

Thank you very much for helping you and cutting off part of your time to help members after test your modification i found error in dcount for example when i search to school-d the counter to "Count Lcd Device in Lab A"= 3 but no lcd in lab a in school-D

I can not do what you ask me. So I attached the file to an example of me. Thank you for following up on my problem. So I did not understand your previous comment" think you will need to create a base query for your SQL join as you have for the search control. Then you can use DCount for your...

yes i beginner i try learn

any help for this problem

I want to count this in form search by school search 1- count all record by school search 2- count device in Lab a as example 3- count Lcd device in Lab a 4- count datashow as kind sony i attach sample SchoolLabsDB many thanks for this group

Thank you for your interest

that work thanks why you ' ? before Me.FrmHlpSearch.Form.Requery and this Me.FrmHlpSearch.Form.Requery is problem thank you

any help for this problem

I had some problems and so I attached the file. Thank you for your help

this is code Private Sub Text1_Change() Dim SQL As String SQL = " SELECT TblSchool.SchoolName, TblSchool.Stage, TblFail.Lab, TblFail.Device, TblFail.DeviceKind, TblFail.DescriFail, TblFail.DoFail, TblFail.DeviceDrag, TblFail.StateRepair, TblFail.Note " _ & " FROM TblSchool INNER JOIN TblFail ON...

i create search form by useing vba but error display . i selected the error but i can't solve it . i attach jpg to error

Good evening to all members I Attached is a simple database The target form "SearchFrm" I want to search in three fields when writing a letter. Note I do not want to use a search button. I tried to use the vba code under the search button. but i failed

thankes for reply I want to modify my request can hlp me by searching by name " when write any letter " filter listbox

Any help pls

I can not complete it. I want help on the existing example

Good evening to all members,I Attached is a simple database my problem in form FrmTraining I want when write any (letter or number) in textbox the result show in list box note I designed when you click on any text in the list box showing filtering on the form Thanks good luck

I would like to have an example of the attached file. Please be thankful

from id 1-20 in paper and 21-40 in paper -etc

i want to calculate total every 20 employees without insert row after row 20 or without separate all employees. to print 20 employees in paper is it possible I attach file

thanks that right