www.msaccesstips.com Tutorials

Remove Users from Security Groups
Learn how to remove users from security groups.

Delete User Account
How to Delete a Microsoft Access security user account.

Assign Default Permissions
Assign default permissions for new tables, queries, forms, reports and macros.

MS-Access Live Data in Excel
Here, we will try linking live MS-Access Data in Excel and see that it stays live reflecting changes made in MS-Access. MS-Access will function as the Server Application and MS-Excel will be at the Client side.

No Data and Report Error
Report Source Query or Table can end up with no output records. In that case some of the controls with formula on the Report will show #Error on them.

Cardinal Text Format in Access
The other day one of my colleagues asked me to open MS-Word and type the expression =Rand() on a separate line and press Enter key. It was a magic that I didn't know till that time.

Configure Outlook for Lotus Notes
We have seen that sending EMails from MS-Access is easy enough like any other method you are familiar with. With few clicks we can send an email with MS-Access Objects as attachment to the mail. Depending on the object selected for attachment the output format options available may be different. The attachment format for VB Code module is Text format only and will be converted into this format before attaching it to the mail.

Creating Query with Selected Items
The items appearing in the List Box themselves are records selected from within a Date-Range from the Main Order File. By creating two text controls for start-date and end-date values we can control the selection of records for the list box, if needed. But for now, we will work with items selected from the List Box, for simplicity.

Create Excel / Word File from Access
Create Excel File or Word Document from Microsoft Access and write information into them. Every application that supports Automation provides at least one type of object. For example, a word processing application may provide an Application object, a Document object and a Toolbar object. To create an ActiveX object, assign the object returned by CreateObject to an object variable.

Convert Old Version Workgroup File
Convert workgroup information file from a previous version of Microsoft Access.

Import Objects with VBA
Normally, Tables, Queries or other objects from another database can be imported manually by selecting Import from Get External Data option from File menu. But this can be achieved through VB Code too and this question, HOW TO? is raised in Microsoft Access Users Forums and I thought it is useful to those who look for this solution. Hence, I present the Code here for importing Tables, Queries and Forms separately. The next method imports all Tables from a Source database into the active database except the Microsoft Access System Tables .

Opening Access Forms
This is the easiest method to open forms from a central point, when you have several forms in your Application. But the problem with this method is that you may end up with several command buttons on your Control Screen. We will look into different methods to organize and open the Forms from the Control Screen. We will look into one of them here and we need little preparation for this method.

View or Transfer Ownership
View or transfer ownership of individual tables, queries, forms, reports and macros in a secure database.

Rename File using FileSystemObject
Renaming a file and displaying Drive & File Information.

Create a DSN connection
At this point you need to create a data link. When you execute an ASP file, Windows must know which database you're connecting to. An ODBC Data source Name (DSN) simply stores the information(the name, the path, the user, and the password) required to connect to a specific database. OLE DB connections are superior to DSN because they're quicker to connect, but you must include the specific connection string in the script, and that's beyond the scope of this article. A DSN connection requires little know-how to set up. There are two types of DSN.

USING MS-ACCESS ON INTERNET
Installing the Personal Web Server (PWS), Internet Information Services (IIS), Create the Example ASP Files, Create a DSN Connection, Connect to the Database, Modify Access Data Online, Inserting Data, Modifying Data, Deleting Data, Data Insert Form.

Opening Excel Database directly
With limited features of Database Functions also built into it with the power of Filter, Sort etc. This is where we step in to introduce a Table in Excel for our new example for Reading/Updating the Excel data from Access. Even though there are facilities in Excel to implement general database rules for creating and maintaining a table it is often not followed. It is left to the user to decide how to create a worksheet and how to create a database when both can go into a single Worksheet side by side.

Highlighting Reports
Analysis of data stored in Tables and providing resultant information in the form of Reports to the outside world is an important function of any Database Management System. An Access Application may contain several Tables logically related but maintained separately for easier handling. When it is time to prepare Reports related tables are selected and joined on common information in them, filtered and placed the output on Reports. Meaningful and timely Reports play a very important roll in decision making. Report designing is an Art in its own merit, like Form designing. MS-Access is equipped with excellent Report Designing Tools and with little practice you can master it.

Open Forms with Hyperlinks in Listbox
We have seen in the previous example that all our Forms can be organized in one place with the use of a ListBox and can Open the Form by Double_Clicking an item in the list. As a result, based on the value in the Type field of the control table, a Form opens directly or runs a macro to perform a sequence of operations to prepare the output before opening a Form with the processed data linked to the Form. The objective of this method that we are going to try out here is same, but we will do it differently. It is better to know more than one method, which we can use in our various Projects, rather than using the same thing everywhere. For this example we need to design a small form (not a listbox) and make it look like a listbox.

PIE Chart Object and VBA
This is the continuation of a discussion on working with Chart Object in VBA. We have created a small Table and a Report with a Chart Object on it, in the earlier Post Working with Chart Object in VBA and gone through few simple Property changes on the Chart Object to get prepared for the Demo of the VBA Programs. Please go through Steps 1 to 7 explained in the earliest Post, by following the link above, and continue.