MS-Access: Calculate Stock From Multiple Table.

 Suppose we have 3 table in an MS-Access database.Sample File Download Link.1. Table 1 tblItems have items details information. Here ItemCode is Primary Key field.2. Table 2 tblPurchase contain transactions of material purchasing.3. Table 3 tblSales contain sales transactions.Output Result:Now we want to calculate stock position from these 3 tables. We will take items...

Read More

How to make masked password character inputbox to MS-Excel/MS-Access.

Sometime we need to enter password via inputbox for many reason. Microsoft excel or access do not have any inputbox to take input password. It take input as clear text and any user can see the password while typing. We can make it in two way. We can create a data input form having Text Box and specify property to mask input character as start (*) or other symbol. Another way...

Read More

Excel-Word: অল্প সময়ে কয়েকশত students এর marksheet তৈরির video tutorial.

আমি আজকে দেখাবো কিভাবে Microsoft excel এবং word ব্যবহার করে অল্প সময়ে কয়েকশত students এর marksheet তৈরি করা যায়। উপরের download link এ ভিডিও সহ marksheet  এর sample এবং student দের তথ্য এবং  subject wise mark entry সহ excel file দেওয়া আছে। Download: Tutorial materials download link. কাজটি করার জন্য আপনাকে প্রথমে আপনার প্রতিষ্ঠানের marksheet এর sample...

Read More

How to get all files name from a folder in Excel (VBA).

In this post I will show, how to get all files name from a folder. Some times we require to type all file names from a folder. Typing for many files a time consume. So to get easily all files name we may use following procedure. Sample File Download Link. 1.       Open a new excel file. 2.       Open Visual Basic code windows (Hit “ALT+F11”). 3.       Insert...

Read More

Excel Advance: Filtering data automatically based on condition using functions.

Sample file download: Filter_Data_Based_On_Condition      Zip File (10 KB) How to filter data using function in Excel. In above screenshot there are some data in left table. In right table filtered data are shown. There are some tasks list and different task is in different status. We want to filter tasks those are already complete. Whenever a task...

Read More

MS Access: কিভাবে Checkbox ও Option Button ব্যবহার করবেন।

Sample File & Video Download: Checkbox_Optionbutton_Program   Zip File (44 KB) Video Link: Checkbox_Optionbutton_Program *** নিচের কোন লাইন না বুঝতে পারলে ভিডিওটা ভাল করে দেখবেন। (1)    প্রথমে একটি নতুন অ্যাকসেস ফাইলে একটি নতুন Form নেই। (2)    ফরমে তিনটি টেক্সট বক্স, একটি Option Group এবং তাতে তিনটি Option button...

Read More

Excel Advance: How to filter data of a column that have specific word?

Suppose I have list of animal (See screenshot). I want to filter data which have word cat. So, for filtering data with word cat use the following formula. =IFERROR(INDEX($A$5:$A$14,SMALL(IF(ISNUMBER(SEARCH("Cat",$A$5:$A$14)),ROW($A$5:$A$14)-ROW($A$4)),ROWS($A$5:$A5))),"") *** Note: This is an array formula. So, you have to must press ‘Ctrl+Shift+Enter’ after typing formula. Download...

Read More