Access VBA run Query or run Action Query

This Access VBA tutorial explains how to run Query and run Action Query in Access VBA. Access VBA run Query or Action Query Imagine you have to run 10 Action Query (e.g. Create Table, Update, Delete Table) in a row to get the final result, you have to run each Action Query one by one and the most annoying part is to click the confirmation dialogs. With Access VBA we can run a series of Action Query automatically and skip all the confirmation dialogs, saving a lot of time. In the following e...
More

Excel delete all pictures or delete all pictures in specific Cells

This Excel tutorial explains how to delete all pictures in a worksheet or delete all pictures in specific Cells. Excel delete all pictures When you copy contents from website to Excel, it is unavoidable to also copy unwanted pictures. As some websites contains dozens of pictures, it is a waste of time to delete pictures one by one. In this tutorial, I will demonstrate how to  delete all pictures at once. Let's say I want to copy the below table from a website. In the Country of Origin field...
More

Excel assign sequence number to duplicate records

This Excel tutorial explains how to assign sequence number to duplicate records using COUNTIF Function. You may also want to read: Excel check duplicate values using Conditional Formatting Excel delete duplicated data in consecutive rows Excel assign sequence number to duplicate records Suppose you have two sales transactions on the same date but you don't have any transaction timestamp (but records are in ascending order of time), you may want to add a number to each transaction so tha...
More

Access VBA loop through all Tables using DAO.TableDef

This Access VBA tutorial explains how to loop through all Tables using DAO.TableDef in Access. You may also want to read: Access VBA loop through Table records Access VBA loop through all Tables Let's say we use a Macro to import 100 Tables and then we want to delete them all. It is time consuming for us to delete one by one and there is a high risk of manual error of deleting the wrong one. In this case we want to write a Macro to loop through all Tables to delete all Tables that meet c...
More

Access VBA delete Table using DoCmd.DeleteObject Method

This Access VBA tutorial explains how to delete Table (delete single table, delete multiple tables) in VBA using DoCmd.DeleteObject Method. You may also want to read: Access delete table records Access VBA delete Table In Access VBA, deleting Table can be done by DoCmd.DeleteObject Method. It is an extremely simple and straight forward, the syntax is as below. In order to delete Table, use acTable in the ObjectType argument. DoCmd.DeleteObject(ObjectType, ObjectName) Name Requ...
More

Access VBA import txt using DoCmd.TransferText Method

This Access VBA tutorial explains how to import txt using DoCmd.TransferText Method in one Table or separate Table. Microsoft Access - import TXT using DoCmd.TransferText Method In my previous post , I explained how to use DoCmd.TransferText Method to export queries to files such as txt, this tutorial explains how to import txt into Table. First prepare a TXT file such as below Then import the txt file manually. Before the final step, create a specification (which field is what data ...
More

Excel dependent dropdown list | dependent validation list

This Excel tutorial explains how to create dependent dropdown list where dropdown list values depend on another list value. Excel dependent dropdown list / dependent validation list Suppose you have a continent list in Excel (Asia, North America, South America, etc). When an user selects a continent from a dropdown list, the user can then select the second dropdown list which contains all the countries of your selected continent, so the country list is dependent on the continent value. For ...
More

MS Project shift the whole schedule

This MS Project tutorial explains how to shift the whole schedule using Move Project or shift part of the schedule or tasks in Microsoft Project. MS Project shift the whole schedule Before a project begins, it is common to postpone the project schedule due to many reasons, especially when a schedule requires many stakeholders to review and approve. Therefore it is highly likely that we need to adjust our schedule repeatedly before our project begins. This kind of moving schedule action is best...
More

Excel VBA Range PasteSpecial Method

This Excel VBA tutorial explains how to use Range.PasteSpecial Method to paste special such as paste values. Excel VBA Range PasteSpecial Method In Excel worksheet, if you copy a Cell and then Paste Special, you can see a list of options. The most commonly used Paste Special is Paste Values, in order to remove all the formula. In Excel VBA, Paste Speical is done through Range.PasteSpecial Method. Syntax of Range.PasteSpecial Method Range.PasteSpecial(Paste, Operation, SkipBlanks, Tran...
More

MS Project delete Summary Task without deleting subtasks

This MS Project tutorial explains how to delete Summary Task without deleting subtasks in Microsoft Project. Microsoft Project delete Summary Task Suppose we have created a Summary Task for Task 1 to 3.   If we decide to delete the Summary Task, highlight row 1, then press keyboard Delete button. You would receive a warning message that deleting Summary Task will also delete all subtasks.   If we click OK, task 1 to task 3 will be deleted. However, somet...
More