Search results

Mr. cheekybuddha Thank you So Much It's Work Like Magic :giggle::giggle: I just modified little in code just replaced * With % Dim rs As ADODB.Recordset Set rs = New ADODB.Recordset ' Replace Up Sql With Following Access Sql , Dim strSQL As String strSQL = "SELECT...

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

is there is any code could help me to modify those values in registry editor ! Thanks

Sir, I really understand and I really appreciate that every one is trying to help , I solve issue No2 after hours of search, but I still cant solve No.3 , that's why we ask experts to help us and save our time , I really do my best before create threat , because I want to save your valuable...

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

yes I really agree with that , I will use first code for main form textboxes , and your code for continuous sub forms and datasheet . Thank you so much sir 🌹 🌹 🌹 🌹 AJ

Thank You Mr. arnelgp I tried this it works fine But It not Possible to change border style or border Color !! .BorderColor = 16711680 !!! A.J

I tried to refer to Sub Form then Control , But Still Not Work!

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

every Time I Need Something , I just find you solve it Thanks Mr.arnelgp 🌹 🌹

thank you so much jdraw 🌷

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

i need code sample idea , so i can write mine , thanks

i agree with you in one case if i already modify or entering data directly to the database table , but actually iam using pending table to bring data from sqldatabase table to access table , after modifying or entering data local table directly update or insert data to the sqldatabase table ...

the problem is iam using remote sqlserver database as backend , and Dlookup work fine with access database as backend , but with remote Sqlserver it takes some time specially when it concern many records with slow connection as attached image ,,

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 ☺️,,

Its Really Amazing I really needed this

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