Search results

i replaced code but this error show up to me in this line Forms!CurrentForm!HeaderSubForm.Form.ReloadMe

I do following in my application i keep the key in table appear to user but its more than 250 character key collect hexdecimal 2 times Lenth of (harddriver serial & "/\" & Machine name & "/\" &username ) any time you want hexdicimal 2 times value of (harddriver serial & "/\" & Machine...

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

as example , IN C# I Create Stored Procedure On the Server , I call this Proc. and return data in data table = Record Set after i modify this record i call a stored procedure and loop through data table records and return updated to server . that's easy to manage in C# But I can not Manage...

Thank you Mr. Pat Hartman I really appreciate those kind of advices , after more 25Y experience . But Really My Problem That I Work with company server and data, so I just want to figure out a sample code for: - Get Invoice Record from database (so i can modify after that i send it back again i...

i need good example or tutorial for handling dataset in main form and child sub form

Sir , Simply Passthrough Query bring data but i can't handle data in record set so i just bring my data to same structured table so i can handle the table as record source for continuous form

no sir , i just bring the required record only to my pending table so after edit i send back to database

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

Thanks Mr. June7

Thanks Mr. arnelgp

Public Sub PendSpecTable(TableName1 As String, Tablename2 As String, IndexID As String) Dim sql1 As String Dim sql2 As String sql1 = "INSERT INTO " & TableName1 & " SELECT lc_databases.* FROM lc_databases WHERE (((lc_databases.database_id)='" & IndexID & "'))" sql2 = "INSERT INTO...

June7 I tried To Replace but same error

GoodDay Mr. The_Doc_Man I hope you have a nice Day My IndexID is string yes. I did this way because I has many tables in database with different names but same structure data inside for some reasons, So What's the best way to change table name without repeating code every time , Thanks 🌹

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

Use this file , And see video رابط تحميل برنامج ايزي كونت مديا فير https://www.mediafire.com/file/pq3qt92zr6l50a8/EasyCount.rar/file رابط فيديو اليوتيوب ايزي كونت ع اليوتيوب رابط صفحة الفيس بوك ايزي كونت https://www.facebook.com/easycountapp

I Saw your Reply Before I post my reply 🤣 🤣 But I Pressed Post Button 😁 Thanks

Yes I'm Aware sir , I just use it to fill Active x Controls Like Tree view and List View . Thanks A.J Always Remember "A true act of kindness always sparks another"

Mr. arnelgp I Always Waiting Your Help , And I Appreciate the way you use simplify issues for any one , i tried it work very fine (y), but in this case I'm trying not to create 100 Query Object in my database. Mr. @cheekybuddha Already Convert the SQL And Work directly assigned to my list view...