• Home
 · 
• Databases/Data Access/DAO/ADO
 · 
• Viewing Filtered data in the DBGRID object though its EMPLOYEE ID number.

Viewing Filtered data in the DBGRID object though its EMPLOYEE ID number.

Viewing Filtered data in the DBGRID object though its EMPLOYEE ID number.

Rate Viewing Filtered data in the DBGRID object though its EMPLOYEE ID number.

• 1
• 2
• 3
• 4
• 5

(2(2 Vote))

   'Put a label on your form and change the Caption into  "ID NUMBER: " 
   'Put a TEXTBOX on your form, name it TEXT1 
   'Put a Command Button and name it cmdfilter then change the caption    
   '   into "&Filter  "
   'Put a DATA CONTROL on your Form (Form1)
   'Set the DATA CONTROL name into data1
   'sand et the DATABASENAME property to your database.

'Step 2(Write this Code)

'NOTE: I only set the table name as tblemployee

   Private sub cmdfilter_click()
       data1.recordsouce="SELECT * FROM tblEmployee where='" & trim(text1.text) 
        & "'"
       dbgrid.refresh
   end sub