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...
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...