VBA Developer with MS Access

13/02/2023

ফ্রিল্যান্সারদের রপ্তানিকারকের রিটেনশন কোটা (ইআরকিউ) হিসাবের সুবিধা দিতে নির্দেশ দি‌য়ে‌ছে বাংলাদেশ ব্যাংক। এখ....

24/10/2019

Sometimes we forget the VBA project password. However, when we need to code in VBA project, we have to remove the password and put new password. To remove the password please follows steps: Steps-1: Open the Access database file by any HEX Editor software. I personally use HxD Hex Editor2.2.0.0 Step...

17/10/2019

Function Trunc(number1 As Double, DecPlace As Integer) As Double Trunc = Fix(number1 * 10 ^ DecPlace) / 10 ^ DecPlace End Function

09/10/2019

Sometimes we need to write multiline in the msg box. For that reason follow the below code: mymsg= MsgBox(

30/12/2016

Happy New Year 2017

12/05/2015

https://nazimdev.wordpress.com/2015/05/12/csv-file-imort-in-access-db/

Write the following code in an click event. [Code] Private Sub Cmd_auto_Click() On Error Resume Next Dim fd As Object Set fd = Application.FileDialog(3) fd.AllowMultiSelect = True fd.Show strFileNa...

12/05/2015

https://nazimdev.wordpress.com/2015/05/12/exporting-csv-file-from-ms-access-database/?fb_action_ids=10208073226332825&fb_action_types=news.publishes&fb_ref=pub-standard

Write the following code in a click event

09/04/2015

The members of this page are requested to post VBA related information to enrich the page....

16/03/2015

Sometime we want to know the file extension in Software development. For that Just follow the below link.

https://nazimdev.wordpress.com/2015/03/16/to-know-file-extension/

Function FileExt(ByVal strFileWPath As String) On Error GoTo Error_Handler FileExt = Right(strFileWPath, Len(strFileWPath) - InStrRev(strFileWPath, ".")) Error_Handler_Exit: On Error Resume Nex...