Recent content by ahmedjamalaboelez

this code work fine with me insert following code in public module don't forget to add reference Microsoft Active X Data Object Library '$<<-- Open Connection-->> Public Function ServerConOpen(ConServer As String, ConUser As String, ConPassword As String, ConDatabase As String) As Boolean...

If I understand well , you do not need to suffer with sub form for statistics from multiple tables and multiple Sql , Just use Active x Control List View and you can handle the code , Sql Statement , Headers , and data Option Compare Database Option Explicit '<<---- Define Listview For Publish...

till today, I am still amazed tools you create amazing Thank you Mr. @arnelgp

2019 support

i'm married 7 years ago, but no childrens

i use it thanks 100% very helpful

yes i got it 🌹 🌹 Thanks

@Gasman I'm not professional as you , so i always ask for help from professional members. Thanks 🌹

Thank You Soooooooo Much Your Code Run Like Magic Here is your Code in sub Private Sub btn_Hold_Click() ServerConOpen Dim cmd As New ADODB.Command cmd.ActiveConnection = cnx cmd.CommandType = adCmdText Dim Item As Object For Each Item In list_search.ListItems...

I Appreciate Your help i have list view with records , when I'm trying to loop through selected items return error please help to loop through listview selected items Private Sub btn_Hold_Click() ServerConOpen Dim cmd As New ADODB.Command cmd.ActiveConnection = cnx...

Good day my friends I have this table in my financial periods details YearID MonthID MonthStart MonthEnd 2022 01 01/01/2022 31/01/2022 2022 02 01/02/2022 28/02/2022 if i have the first date of the year ( 01/01/2022) how could i populate 12 Records...

This is easy Trick we call it in business parking , its need pending table between https://selfhelp.windwardoncloud.com/System5Parking_an_Invoice.htm

ok got it boss , thanks 🌹 AJ