Search results

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

so he can open form with no data then can call query in that public module I just wanted to help not More , I sent Sample Db , If He Find it Useful to him I will be happy if some expert have a good solution i think we all will find useful Full Respect 🌹 Thanks A.J

I think Access Not Easy To Have What Oriented Programming Languages Had ? I use C# and it has ability to create instance of each included variable , query, object , modules classes , but access not that easy . may he can open another instance of database by copying database file is that true...

I think every thing is possible when you path Criteria to public sub or function , I do not Use Open Form Or Load Form Event I Just Call The Public Module So I Can Optimize the form To Open With Any Criteria from Any Where I'm Not Expert But, Being Happy To Help And Save Expert Guys Time to...

Why Yo Force Criteria In Docmd.open form ? Make Public Module in form you want to open with criteria , so it let you choose between open with/out criteria as attached Example Public Sub GetCriteria(MyCv As String, MyVersion As String) CVName = MyCv Version = MyVersion...

Now It Works Fine Thank you So Much Mr. arnelgp Many Thanks 🌹 🌹 🌹 🌹