Showing posts with label msaccess. Show all posts
Showing posts with label msaccess. Show all posts

Wednesday, August 31, 2016

MS Access Sample Easy Search Filter in easy way

MS Access Sample Easy Search Filter in easy way
Without any programmer jut same-simple knowledge


This the sample macro filter
This use one name on table name
[Name] Like "*" & Forms!sample!Text16 & "*" 
  second you can use together  ID filed
Or [ID] Like "*" & Forms!sample!Text16 & "*"







Friday, August 26, 2016

sample relation ship and over group number ms access

Hi I am going to show in ms aacess database

How to make it overall number groupp and relationship

Example I  have table a user sample
And will add for relationship like activity table

Report form

Include current print add or record
for more visit:
sample ms access download file





Thursday, August 25, 2016

Ms access print current record and new creating db include add attach photo

ms access print current record
New database ms access Trick Technic printing current record

Simaple view first page
 contoh database ms access halaman pertama

Contoh or sample current id record will be single print
atau cuman hanya print yg di harapkan

dan ini untuk bisa print semuannya tanpa Event code di print button




Dan INi Codennya Copy Paste Saja biar cepat di print button yg anda harapkan



Private Sub Command9_Click()
Dim strReportName As String
Dim strCriteria As String

 If NewRecord Then
        MsgBox "This record contains no data. Please select a record to print or Save this record." _
             , vbInformation, "Invalid Action"
        Exit Sub

Else
strReportName = "sample"

 strCriteria = "[ID]= " & Me![ID]

       DoCmd.OpenReport strReportName, acViewPreview, , strCriteria
   End If
      
End Sub





Atau Bila Perlu And download sample Ms. Access Current Print
https://drive.google.com/file/d/0B5WQmQ9o0e5hb1MyMDZvcDBYVU0/view



phprunner view custom filed status

if ($value=="Process") $str.='<img src="1.png">'; if ($value=="Receive") $str.='<i...