VBA Developer with MS Access

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

Removing an MS Access VBA Project Password - ডাটা সায়েন্স পাঠশালা 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...

Data Truncation (without Rounding) in VBA Access - ডাটা সায়েন্স পাঠশালা Function Trunc(number1 As Double, DecPlace As Integer) As Double Trunc = Fix(number1 * 10 ^ DecPlace) / 10 ^ DecPlace End Function

Multiline in Msgbox - ডাটা সায়েন্স পাঠশালা Sometimes we need to write multiline in the msg box. For that reason follow the below code: mymsg= MsgBox(

Happy New Year 2017

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

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

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

Exporting CSV file from MS Access Database Write the following code in a click event

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

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/

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