Search results

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

Good Day Access World I want to refer to sub form inside the form class so It can be easy not to edited multi lines in every for Following code I use but giving error that VBA not recognize sub form ' Define Current Form And Sub Form Dim CurrentForm As Form Dim HeaderSubForm As...

Good Day Access World, I use following code to bring data from SqlServer table to access table with same structure columns inside , because I do not like to involve with Passthrough Queries, or record set control, it works fine with me bit 👇👇 I have two question :👇👇 1 - is the following Sql...

Good day Brothers, I tried to replace tables names with a variable , so i can insert specific table , is that right to include table name as variable in method !! Before i include Table1 and Table2 As Variables it was working fine , any solution ? Code Below Code Is Here : Public Sub...

Hello Access Worled , I'm Using Following SQL To Fill My List View , it Works Fine but I need to add some criteria as bellow Access SQL Set rs = db.OpenRecordset( _ "SELECT * " & _ "FROM db_devices_search " & _ "ORDER BY db_devices_search.device_lineid"...

Good Day Access World , In access Arabic Language while using Active X Control not work fine before set PC location to Arab region. So I Create Access DB which has attached RAR file inside and I used some Search Resources codes to run the following 1 - Save Attachment to Desktop (y)Done 2 -...

Hi , Good day everyone I'm Calling following code in Form Open Event So Code set Got and Lost Focus Event For Each Control in the form ,So Each Control On Got Focus Got Bold Font And Reg Border Color , This Code Run in Main Form with no issues, But its not Run in Sub Form Open Event, So Please...

:):) Hello everyone & good day :):) Ahmad Jamal " A J " 34 years old Egyptian Accountant -------------------- * I use MS access since 2004. first database I created in high school, I love work in MS access I'm not professional but i do my best to build helpful applications. * I joined this...

Hello i have database with buttons ( new -Save - Cancel -Delete - Exit) in each form i use keys (F1-F2-F3-F4-F5) on form key down event to run my code , F keys run good when not focused in form objects or sub form objects code as follow Private Sub Form_KeyDown(KeyCode As Integer, Shift As...

Hi, I'm Using following code to connect to sql server , how could assign my recordset as ( Continious form Record Source ), connection is successful But I need help in recordset! Private Sub Command0_Click() Dim cnn As ADODB.Connection Dim rsData As ADODB.Recordset Dim strSQL As...

Good day gentlemen, I have Dlookup code as follow , and its work fine [username_txtbox]=DLookup("user_fullname", "users_data", "[user_id]= [user_txtbox]") but, is that possible to replace it with Sql query in vba and assign result to [username_txtbox] Thanks ☺️,,

Good day every one, I have MS Access as front end, and SQL server database as back end installed in windows server remote machine , and connected by VPN IP Hamachi , I have more than 10 Users , some times some work fine and some times get this only error message , even after error message some...

good day every one , :coffee: 1st , i really like the new cool design of the forums,and i really appreciate your help in the following discussion🥰 subject : - for each data table in my database i use 2 tables to prohibit automatic save , Ex. one is (users) and the second is (users-mod). - both...

Gentlemen, Company (IT) team provide me with SQL Server Query which result in sales query , no errors while running on our MS SQL Server Machine , i already linked required tables in my access database because i need to make more advanced reports , but i can not write this kind of queries in...

Gentlemen, good day i need your help regarding attached database i have 3 tables 1 - invoice lines 2 - store available loots ( every loot has its own cost) 3 - invoice usage material when i click invoice post button , i need loop event , to create records in table (invoice usage materials )...

good day my friends, I have an access database , i want to protect it , then i searched on the internet , i found some steps , but they still can connect to the database and import tables and data , the following steps i made - Cancel bypass Key ( Shift ) - Cancelling Special Keys - Hide...

Good Day Every one I have a form contains 2 sub forms in "data sheet"Layout , But if mistakenly update afield then leave field of couple of fields , data automatically updated in tables before i click save button , is there is any way to Just update if I clicked save button ? especially for...

Hi Every Body, I really need help in this , I Have remote SQL Server 2017 Database on GEAR HOST , and i need Sample code to connect to this Database and Drop This data to Text boxes in my form , I appreciate your help to find sample code to connect to this remote database and select data and...

Private Sub Form_Open(Cancel As Integer) InitialiseEvents Me End Sub Quesion ! when Run this Function on form all form ctrls affected but not Subform ctrls plz help ??????? what Could Change to apply it on Subform Ctrls ????? Public Function InitialiseEvents(frm As Access.Form) Dim...