Migrate Access database to SQL Server
How to Migrate Access Database to SQL Server There are lots of benefits to migrate Access Database to SQL Server. The most important two benefits are supporting more users than…
Reset Auto Number to Zero
Two methods to reset Auto number to zero in MS Access In Microsoft Access, I use two methods to reset auto number to zero which also has the primary key.…
Clear all controls in a form
MS Access VBA code to clear all controls in a form. You may need to create a button to clear all controls in a form. If so, then the below…
MS ACCESS Resize Fields Within A Form
Resize Form Fields MS Access resize fields within a form is really handy when you publish a Microsoft Access program. Different users have different monitors and different resolutions. Therefore, you…
MS Access Idle Timeout
MS Access Idle Timeout is a very useful feature to add it within any Microsoft Access program. You might ask how to detect user idle time or inactivity so as to…
Copying list item from one list Box to another
In Microsoft Access, the list box is an object that displays a list of values. However, the list in a list box consists of rows of data. Moreover, these rows can have…
Create row numbers on a Form or Report
Report The simplest way to number records on a report despite of filtering or filtering as it always work is to set the below properties in an unbound text box:Control…
MS Access Row Number Using Queries
MS Access Row Number Using Queries can be easily performed within a query then bound it to a continuous form. However, you can use the below code to number the…
MS Access Row Number on Continuous Form
MS Access Row Number on Continuous Form is one of the most asked around Microsoft Access learners. In fact, it gives your form a professional look. Moreover, row numbering on…
MS access highlight row in continuous form
Highlighting the current record of a continuous form makes it very clear to process functions especially if you have a huge list of records. The following steps, however, will guide…
MS Access DCount Function
MS Access DCount Function The MS Access DCOUNT function is used to count the number of records in a specified set of records (a domain). Besides, it can be used…
MS Access Contact List
MS Access Contact List might not be better than the original Microsoft Access imported Database. However, it has the simplicity and almost most of the features that the imported Contact…
MS Access Do-While Statement
MS Access Do-While Statement repeats a block of statements while a Boolean condition is True or until the condition becomes True. In short, use a Do-While statement when you want to repeat a set of statements…
MS Access If-Then-Else Statement
MS Access If-Then-Else statement runs a specific statement or a block of statements depending on the value of a given condition. If–Then–Else Statements can be nested to as many levels…
MS Access Select Case Statement
You can use the Select Case statement in Microsoft Access to evaluate a given expression and then execute a set of instructions based on the result of the evaluation. It…
MS Access DLOOKUP Function
MS Access DLookup function is used to retrieve a single value from a specified set of records. The syntax for the DLookup function is as follows: DLookup(field, domain, criteria). The…
MS Access Form Filter property
MS Access Form Filter property The Filter property of forms in MS Access allows you to specify a subset of records to be displayed when a filter is applied to…
MS ACCESS FREE CALCULATOR
Free Microsoft Access Calculator Do you need to implement a popup calculator within your own Microsoft Access database? Here is another free MS Access Calculator that can be exported to…
MS Access Numbers to Words
Ms Access Numbers to words is mostly needed for billing and invoicing programs. Simply, there will be a field or a label connected to a VBA code which will read…
Microsoft Access Sign in Form
Microsoft Access Sign-In Form is one of the most needed by MS access programmers. Using sign in form will definitely secure your database. However, before creating a log-in form, you…
MS Access: Search As You Type – Multi Fields
MS Access provides many features. For example, you can filter records in a datasheet or form as you type. Once done, any characters you type in the search field will…
MS Excel: Search as you type
MS Excel: Search As You Type Advanced Filtering MS Excel: Search as you type is another feature that will keep your sheet more organized and make it easy for you…
MS Access: Add, Delete, Update using SQL VBA Code
MS Access Add Delete Update Using VBA Code are few entries that are needed mostly by Microsoft Access programmers where almost all access programs must contains these VBA codes. However,…
MS Access: Search As You Type Single Field
MS Access VBA trick that can be used to filter a continuous form. MS Access Search As You Type is a feature that allows your current form to filter the…