Normally, a Graph Chart is designed to the required size and formatting on a Form/Report. The design stays with its dimension for ever, unless the developer has second thoughts and modifies it. But, there is a way to resize the Chart Object automatically when the user resizes the Chart Form ... Read MoreFeatured News
Scaling the Chart Object
Normally, a Graph Chart is designed to the required size and formatting on a Form/Report. The design stays with its dimension for ever, unless the developer has second thoughts and ...
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 ...
Column Chart and VBA
In our earlier example, Working with Graph Chart in VBA, we have made preparations to try out Charts with VBA and did sample Runs for three Types of Charts viz. ...
Working with Chart Object in VBA
Working with Chart Object in VBA is a complicated matter, but interesting too. Once the code is developed it is very useful and can be used across Applications to prepare ...
MS-Access and Graph Charts2
Continued… If you have landed straight on this page please go through the earlier Post MS-Access & Graph Charts and then continue. Sample Data for Pie-Chart ...
MS-Access and Graph Charts
Access Reports are excellent in presenting information in Numbers and Text. But, Charts goes one step further in providing information in the form of pictures and a quick look at ...
Scaling the Chart Object
Published On 30 Aug 2010 By a.p.r.pillai. Under Graph Charts.
Normally, a Graph Chart is designed to the required size and formatting on a Form/Report. The design stays with its dimension for ever, unless the developer has second thoughts and modifies it. But, there is a way to resize the Chart Object automatically when the user resizes the Chart Form ... Read More
User and Group Check
Published On 26 Aug 2010 By a.p.r.pillai. Under MS-Access Security.
In a secured Database; basic access rights to Objects like Tables, Forms, Queries and Reports are defined for specific Workgroups/Users as a one time exercise. This takes effect automatically when a User belongs to a particular Workgroup accesses the Database Objects. For example: Assume that the Employees Table ... Read More
VBA have several predefined data types like Integer, String, Date and so on to use in Programs. These can be used to hold only one type of data in them. Integer Variable can hold Numeric Values ranging from –32768 to +32767 and String Type stores Alpha-Numeric Values and so on. ... Read More
The local Charity Organization for Children allocate funds for disbursement to eligible individuals or entities under various categories. Accounts Section supervises the disbursement activities. It is part of the responsibility of Accounts Section to ensure that the total value of all payments of a particular category is not exceeding the ... Read MoreChange Secure DB to Unsecured
Published On 25 Jul 2010 By a.p.r.pillai. Under MS-Access Security.
It is very unlikely that you want to change the status of a Secured Database (implemented with Microsoft Access Security) to an unsecured one. This exercise become necessary when you want to install/share a Database in an unsecured environment. Before we embark on this simple exercise to remove ... Read MoreDate and Time Values
Published On 14 Jul 2010 By a.p.r.pillai. Under How Tos.
Technorati Tags: Microsoft MS-Access have Date/Time Data Field Type to store Date or Time or both Date and Time together. When you enter a Date Value into the Field (such as 14/07/2010) the actual value stored in memory is a whole number 40373, the number of ... Read MoreLimit to List Combo Box
Published On 28 Jun 2010 By a.p.r.pillai. Under Combo Boxes.
Combo Boxes on Tables/Forms are for inserting frequently used common values quickly and easily into Data Fields. The Source Data Values of the Combo Box comes from Table or Query. The User is expected to click on the Drop Down control of the Combo Box to display the list of ... Read MoreInput Masks and Data Entry
Published On 19 Jun 2010 By a.p.r.pillai. Under Accesstips.
Technorati Tags: microsoft Input masks are special group of characters that can be used in the InputMask Property of data fields to make data entry work easier in Microsoft Access. You can use them on Forms too. Keyed-in Text Value changes into upper case ... Read More
We can create cascading Menus with Tab Control and Option Group Controls on Form. Several Menus can be arranged neatly one behind the other and allow the User to make the one he/she would like to see by selecting the Main Menu Option. For example: the Sample ... Read More
You may find several pieces of gadgets like Clocks, Wrist Watches and so on around you to check the Date and Time. How about inserting a Digital Clock into your Project’s Main Switchboard Form so that your User can check the Date and Time with a casual glance in the ... Read More
Technorati Tags: msaccess animation Computer Programming is interesting because when you start doing something it will definitely lead to more than that and give you more ideas to try different things all the time. I have started with the Label Animation methods and thought of presenting one or two ... Read More
We have learned several label animation methods, through last few Posts dedicated to this topic, but we will try another trick, with the last design that you have created to try out the Zoom-in method. In this method we will play with colors and each letter of ... Read More
This week we will learn a different style of Label Animation technique. Those who would like to have a look at the earlier simple label animation methods, the page links are given below to visit those pages:
I have several Label Animations Styles in store for you and we have already seen two of them through last two Articles:
Here, we will examine two variants of the last animation method we have tried last week. If you have gone through the procedures in creating the sample labels and programs then we can try the same animation method with slightly different settings of the labels.
Last week we have learned a simple label animation method to display Employee Names, and made it to appear character by character from right side of the label to full view. The animated label gives the Form a lively look and makes it more interesting to the User to work with the Screen.
A Form with lively Objects like Animated Command Buttons or Animated Giffs or Moving Text etc. makes it more interesting to the User to work with our MS-Access Applications. MS-Access doesn’t have any of those things built-in or ready made to use it quickly. Our imagination and ingenuity is the only tool available to create something with the existing strictly business like features provided in MS-Access.
Group Account Permissions with VBA
Published On 17 Mar 2010 By a.p.r.pillai. Under MS-Access Security.
We have learned how to remove all permissions from all Objects for Users Group Account as all Users belongs to this default Group Account and inherits permissions, if available, besides other Group Accounts each user belongs to. If you have not gone through the earlier Articles on Microsoft Access Security with VBA, you may take a look at the following links before continuing:Creating User-Account with VBA
Create Security Group Account with VBA
Users Group and Permissions
Users Group and Permissions
Published On 07 Mar 2010 By a.p.r.pillai. Under MS-Access Security.
When you create a new Workgroup Information File, as part of the Microsoft Access Security implementation, it is important that the following two steps you follow immediately after creating the new Workgroup Information File (.mdw) file on priority basis:
Create Security Group Account with VBA
Published On 01 Mar 2010 By a.p.r.pillai. Under MS-Access Security.
Last week we have learned how to create a Microsoft Access Security User Account(SMITHJOHN) with VBA and learned how to join him as a member of the default Group Account Users. The Users and Admins Group Accounts are already present in the default Workgroup Information File (Sytem.mdw) or in the new Workgroup Information File that you create separately.
Creating User-Account with VBA
Published On 22 Feb 2010 By a.p.r.pillai. Under MS-Access Security.
For creating a Microsoft Access User-Account manually in the Workgroup Information File (.mdw) we go through Tools – -> Security – -> User and Group Accounts – ->User Name Option. There, we need to provide a unique User Name and a Personal ID to create a User-Account.
We have seen this ... Read More
