Sitemap

• Home
  

• TOPIC INDEX
  
1. Streamlining Form Module Code
2. Animations / Menus and Toolbars
3. Art Work
4. Auto-Numbering In Query Column
5. Command Buttons
6. Custom Wizards
7. E-mails / External Links
8. Forms
9. Graph Charts
10. How-tos
11. List Box / Combo Box
12. Microsoft ListView Control Tutorial
13. Microsoft TreeView Control Tutorial
14. Microsoft Windows APIs
15. MS-Access And Internet
16. MS-Access Class-Module Tutorial Index
17. Process Control
18. Process Monitoring
19. Queries
20. Reports
21. Security - Access 2003
22. User-Defined Data-Type
23. Utilities
24. VBA Class Module Objects
25. VBA Collection Object
26. VBA Dictionary Object
27. WithEvents/Event/RaiseEvent

END OF INDEX ---Go Top---

• TIPS AND TRICKS-I
• Command Buttons
  
  1. Command Button Animation
  2. Double Action Command Button
  3. Colorful Command Buttons
  4. Transparent Command Button
  5. Command Button Animation-2
  6. Create an Animated Button with VBA
  7. Command Button Color Change on Mouse-button-down Action
  8. ---Go Top---


• Animations / Menus and Toolbars
  
  1. Message Box That Closes Itself After Specified Time
  2. MsgBox with Office Assistant: Access 2003
  3. Reminder Ticker Form
  4. Startup Screen Design
  5. Animated Floating Calendar: Access 2003
  6. Calendar and Toolbars: Access 2003
  7. Custom Menus and Toolbars: Access 2003
  8. Custom Menus and Toolbars-2: Access 2003
  9. MsgBox with Options Menu: Access 2003
  10. Office Assistant with Checkbox Menu: Access 2003
  11. Selection of Office Assistant: Access 2003
  12. Wave Shaped Reminder Ticker
  13. Form Menu Bars and Toolbars
  14. Animating Label on Search Success
  15. Color and Picture in MsgBox: Access 2003
  16. Office Assistant and MsgBox Menus: Access 2003
  17. Office Assistant and MsgBox Menus-2: Access 2003
  18. Run Slide Show when Form is Idle
  19. Menus with Options Group Control: Access 2003
  20. Create Menus with Macros
  21. Create Menus with Macros-2
  22. Easy-Ref. Access2003 Commands in Access2007
  23. Legacy Custom Menus, Toolbars in Access2007
  24. ---GO TOP---


• Art Work
  
  1. Create 3D Headings on Forms
  2. Border 2D Heading Style
  3. Border 3D Heading
  4. Shadow 3D Heading Style
  5. Colors 24 Bits and Binary conversion
  6. Memo Field Text Formatting
  7. ---GO TOP---
  8. ---GO TOP---
• Wizards
  
  1. Custom-made Form Wizard
  2. Custom Report Wizard
  3. MsgBox That Closes Itself After Specified Time
  4. MS-Access And Creating Desktop Shortcuts
  5. MS-Access And Transfer SpreadSheet
  6. ---GO TOP---
• MS-Access Forms
  
  1. File Browser (Common Dialog Control)
  2. Closing Forms
  3. Opening Access Forms
  4. Open Forms with Hyperlinks in Listbox
  5. Startup Screen Design
  6. Control Screen Design
  7. Control Screen Menu Design
  8. Edit Data in Zoom-in Control
  9. Saving Data on Forms, not in Table
  10. Find or Filter Data on Forms
  11. Event Trapping and Summary on Datasheet
  12. Data Editing and Security Issues
  13. Custom Calculator and Eval() Function
  14. Drill Down Inquiry Screen
  15. Drill Down Inquiry Screen-2
  16. Combo-Box Column Values
  17. External Files List in Hyperlinks
  18. ControlTip Text and Time Delay
  19. Forms and Custom Properties
  20. Synchronized Floating Pop-up Form
  21. Positioning Pop-up Forms
  22. Change Form Modes on User Profile
  23. InputBox and Simple Menus
  24. Form Background with Gradient Color
  25. Filter by Character and Sort
  26. Label animation style-1
  27. Label animation style-2
  28. Label animation Variant
  29. Label Animation Zoom-in Style
  30. Label Animation in Colors
  31. Label Animation Zoom-out Fade
  32. Digital Clock on Main Switchboard
  33. Lively controls on the form
  34. Microsoft Date & Time Picker
  35. Data Change Monitoring
  36. Updating Sub-Form Recordset from Main
  37. Control SetFocus on Tab-Page Click
  38. Duplicating Fields with Conditional
  39. Defining Pages on Form
  40. Stretching Controls when Resizing Form
  41. Backtracking Open Forms
  42. Time-bound Form Mode Change
  43. Conditional Formatting in Continuous
  44. Setting Focus on Field Inside Sub-Form
  45. Shifting Focus from one Sub-Form to
  46. Form Footer Section Dropping-down Magic
  47. Overlaying Sub-Forms in Real-time
  48. Updating Combobox when Not-in-List Active
  49. Designing About Form for MS-Access
  50. Microsoft Access Form MoveSize Action
  51. Form Recordset and Bookmarks
  52. ---GO TOP---
• Process Control Forms
  
  1. Creating, and Using Custom Properties
  2. Save User Specific Parameter Values
  3. Filter with BuildCriteria Function
  4. Text Search Filter Web Style
  5. Web Browsing within Access Form
  6. Data Upload Controls
  7. Indexing and Sorting with VBA
  8. Budgeting and Control
  9. Primary Key usage with many fields
  10. iSeries Date in Imported Data
  11. ---GO TOP---
• Graph Charts
  
  1. MS-Access and Graph Charts
  2. MS-Access and Graph Charts-2
  3. Working with Chart Objects in VBA
  4. Column Chart and VBA
  5. PIE Chart Object and VBA
  6. Scaling the Chart Object
  7. Missing Lines in Line-Chart
  8. PIE Chart and Live Data on Form
  9. Crosstab, Union Queries for Charts
  10. ---GO TOP---
• Reports
  
  1. Saving Report Pages as separate PDF Files
  2. Opening specific page of PDF File
  3. Highlighting Reports
  4. Report Page Border
  5. Reminder Popups
  6. Useful Report Functions
  7. MS-Access and Mail Merge
  8. MS-Access and Mail Merge-2
  9. MS-Access and Mail Merge-3
  10. Dynamic Report
  11. No Data and Report Error
  12. Textbox and Label Inner Margins
  13. Network and Report Page Setup
  14. Network and Print Page Setup-2
  15. Network and Print Page Setup-3
  16. Hiding Report Lines Conditionally
  17. Hiding Report Lines Conditionally-2
  18. Hiding Report Lines Conditionally-3
  19. Detail and Summary from the same Report
  20. Report Page-wise Summary (Not Report Summary)
  21. Form and Report Open Arguments
  22. Report Design in Access2007
  23. Embedded Macros in Access2007
  24. Percentage of Report Summary
  25. Easy-Read Reports
  26. Continued Page-2 on Report
  27. Creating Watermark on Reports
  28. How to use Form Filter on Report
  29. How to use Form Filter on Reports?
  30. Printing MS-Access Report from Excel
  31. Preview/Print Other Database Reports inside Active Database
  32. Alphabetized Customer List
  33. Sub-Report Summary Value in Main Report Calculations
  34. Activity Dates and Quarterly Reports
  35. MS-Access Object Documenter
  36. ---GO TOP---

• TIPS AND TRICKS-II
  
• E-mails / External Links
  
  1. MS-Access and E-Mails
  2. Configure Outlook for Lotus Notes
  3. Automated E-Mail Alerts
  4. Word Mail_Merge With Access Table
  5. Linking with IBM AS400(iSeries) Tables
  6. Opening External Data Sources
  7. Opening the dBase Table directly
  8. Display Excel Value directly on Form
  9. Opening Excel Database directly
  10. Database Connection String, Properties
  11. MS-Access Live Data in Excel
  12. MS-Access Live Data in Excel-2
  13. Source ConnectStr Property and ODBC
  14. Link External Tables with VBA
  15. Lost Links of External Tables
  16. Attachment Field in Access2007
  17. Copy and Paste Data from Excel to Access2007
  18. Exporting All Access Tables Into Excel
  19. Hyperlink Opens Objects from External Database
  20. ---GO TOP---


• Process Monitoring
  
  1. Progress Meter
  2. Progress Bar on Form
  3. Progress Counter
  4. Who changed the data..?
  5. Seriality Control - Missing Numbers
  6. Indexing and Sorting with VBA
  7. Macros and Temporary Variables
  8. Archiving Master Data
  9. ---GO TOP---


• Queries: Auto-Numbering in Column
  1. Auto Numbering in Query Column
  2. Auto-Numbers in Query Column Version-2
  3. Autonumber with Date and Sequence Number
  4. Preparing Rank List
  5. Product Group Sequence with Autonumber
  6. Running Sum in MS-Access Query
  7. Diminishing Balance Calc in Query
  8. ---GO TOP---


• MS-Access Queries
  
  1. Percentage of Total Value
  2. Union Query
  3. Crosstab, Union Queries for Charts
  4. Filtering Data for Different Users
  5. Finding Consecutive Workdays
  6. Multiple Parameters for Query
  7. MS-Access and Data Processing
  8. MS-Access and Data Processing-2
  9. Memo Field and Data Filtering
  10. Sub-Query in Query Column Expressions
  11. Top n Records in Query
  12. Change Query Top Values, Property with VBA
  13. Change Query Top Values, Property with VBA-2
  14. Dynamic DLookUp() in Query Column
  15. Apply Filter to Table directly
  16. IIF vs SWITCH Function
  17. Adding Data directly into External Databases
  18. RUNSQL Action in Macro and VBA
  19. Combining Active and Backup Database
  20. ---GO TOP---


• List Box / Combo Box
  
  1. Refresh Dependent ComboBox Contents
  2. Creating Query with Selected Items
  3. Create a List from another ListBox
  4. ListBox and Date (Part-I)
  5. ListBox and Date (Part II)
  6. Dynamic ListBox ComboBox Contents
  7. Filter Function Output in Listbox
  8. Filter Function Output in Listbox-2
  9. Form Bookmarks and Data Editing
  10. Form Bookmarks and Data Editing-2
  11. Form Bookmarks and Data Editing-3
  12. Limit to List Combo Box
  13. ---GO TOP---


• User-Defined Data Type
  
  1. Function Parameter ByVal and ByRef Usage
  2. Function Parameter Array Passing
  3. Passing Two-Dimensional Array to Function
  4. User-Defined Data Type-2
  5. User-Defined Data Type-3
  6. ---GO TOP---


• VBA Class Module Objects
  
  1. MS-Access Class Module and VBA
  2. MS-Access VBA Class Object Array
     
  3. MS-Access Base Class and Derived Object
  4. VBA Base Class and Derived Object-2
  5. Base Class and Derived Object Variants
  6. Ms-Access Recordset and Class Module
  7. Access Class Module and Wrapper Classes
  8. Wrapper Class Functionality Transformation
  9. ---GO TOP---


• VBA Collection Object
  
  1. Ms-Access and Collection Object Basics
  2. Ms-Access Class Module and Collection Object
  3. Table Records in Collection Object and Form
  4. ---GO TOP---


• VBA Dictionary Object
  
  1. Dictionary Object Basics
  2. Dictionary Object Basics-2
  3. Sorting Dictionary Object Keys and Items
  4. Display Records from Dictionary to Form
  5. Add Class Objects as Dictionary Items
  6. Update Class Object Dictionary Item on Form
  7. ---GO TOP---


• Class Module: Event/RaiseEvent/WithEvents
  
  1. WithEvents Ms-Access Class Module
  2. WithEvents and Defining Your Own Events
  3. WithEvents Button Combo List TextBox Tab
  4. Access Form Control Arrays and Event Capturing
  5. Access Form Control Arrays and Event-2
  6. Access Form Control Arrays and Event-3
  7. WithEvents in Class Module for Sub-Form TextBox Events
  8. WithEvents in Class Module and Data Entry
  9. WithEvents and Access Report Event Sink
  10. WithEvents and Report Lines Hiding
  11. WithEvents and Report Lines Highlighting
  12. WithEvents TextBox and Command Button Arrays
  13. WithEvents TextBox CommandButton Dictionary
  14. WithEvents and all Form Control Types
  15. ---GO TOP---


• Streamlining Form Module Code in Standalone Class Module
  
  1. Reusing Form Module VBA Code for New Projects.
  2. Streamlining Form Module Code - Part Two.
  3. Streamlining Form Module Code - Part Three
  4. Streamlining Form Module Code - Part Four
  5. Streamlining Form Module Code - Part Five
  6. Streamlining Form Module Code - Part Six
  7. Streamlining Form Module Code - Part Seven
  8. Streamlining Form Module Code - Part Eight
  9. Streamlining Form Module Code - Part Nine
  10. Streamlining Form Module Code - Part Ten
  11. Streamlining Form Module Code - Part Eleven
  12. Streamlining Report Module Code in Class Module-12
  13. Streamlining Module Code Report Line Hiding-13.
  14. Streamlining Form Module Code Part-14.
  15. Streamlining Custom Made Form Wizard-15.
  16. Streamlining VBA Custom Made Report Wizard-16.
  17. Streamlining VBA External Files List in Hyperlinks-17
  18. Streamlining Events VBA 3D Text Wizard-18
  19. Streamlining Events VBA RGB Color Wizard-19
  20. Streamlining Events Numbers to Words-20
  21. Access Users Group(Europe) Presentation-21
  22. The Event Firing Mechanism of MS Access-22
  23. One TextBox and Three Wrapper Class Instances-23
  24. Streamlining Code Synchronized Floating Popup Form-24
  25. Streamlining Code Compacting/Repair Database-25
  26. Streamlining Code Remainder Popup Form-26
  27. Streamline Data Editing in Zoom-in Control-27
  28. Streamline Filter By Character and Sort-28
  29. Table Query Records in Collection Object-29
  30. Classes for All Data-Entry, Editing Forms-30
  31. Wrapper Class Module Creation Wizard-31
  32. Wrapper Class Template Wizard-V2-32
  33. ---GO TOP---


• Microsoft TreeView Control
  
  1. Microsoft TreeView Control Tutorial
  2. Creating Access Menu with TreeView Control
  3. Assigning Images to TreeView Control
  4. Assigning Images to TreeView Control-2
  5. TreeView Control Check-Mark Add, Delete Nodes
  6. TreeView ImageCombo Drop-Down Access Menu
  7. Rearrange TreeView Nodes by Drag and Drop
  8. ListView Control with MS-Access TreeView
  9. ListView Control Drag Drop Events
  10. TreeView Control With SubForms
  11. ---GO TOP---


• Microsoft ListView Control
  
  1. Microsoft ListView Control Tutorial
  2. ListView Control Tutorial-02
  3. Assigning Images To ListView Items
  4. ListView Control Drag Drop Sort Events
  5. ---GO TOP---


• Microsoft Windows API
  
  1. Access And Windows API ShowWindow
  2. Get Disk Free Space Windows API
  3. Database Backup Restore From Desktop Shortcuts
  4. ---GO TOP---


• Utility Section
  
  1. Who is Online..?
  2. Keyboard Shortcuts
  3. Sending Alerts to Workstations
  4. Days-in-Month Function
  5. Database Daily Backup
  6. Repairing Compacting using VBA
  7. Database Open/Close Event Alerts
  8. Convert Numbers To Words (25 = Twenty Five Only)
  9. Unsecured Database and User Log
  10. Microsoft Excel-Power in MS Access
  11. Input Masks and Data Entry
  12. Join Split Array Functions
  13. Join Split Array Functions-2
  14. GetRow() Function and Exporting Data
  15. Writing VBA Code with VBA
  16. VBA Module Object and Methods
  17. Prepare Procedures List from Module
  18. Utility - Inserting VBA Error Handler
  19. Assigning Module-level Error-Trap Routine
  20. Centralized Error Handler and Error Log
  21. Calculating Time Difference
  22. Disk Operating System Commands in VBA
  23. Microsoft DOS Commands in VBA
  24. Microsoft DOS Commands in VBA-2
  25. ChDir and IN Clause of Access Query
  26. Deleting Folders with DOS Commands
  27. Accounting Year/Week Calculation
  28. Finding Date Difference between Rows in Column
  29. Exporting/Importing Data in Text Format
  30. Writing Excel data Directly into the Access Table
  31. Appending Data from Excel to Access
  32. Microsoft Access Tutorial Database
  33. PROPER Function of Excel in Microsoft Access
  34. Calculating Workdays from Date Range
  35. DIR TREE DOS Command
  36. Uploading Comma Separated Text Data into Access Table
  37. Uploading Comma Separated Text Data into Access Table-2
  38. ROUNDUP() Function of Excel in MS Access
  39. Time Value Formatting Beyond 24 Hours
  40. DIR Getting File Names from Folder
  41. Directory and File Copy Utility
  42. Rounddown Function of Excel
  43. Date2Text and Text2Date Functions
  44. Call Function from MouseMove Event
  45. Open Access Objects from Desktop
  46. ---GO TOP---

• MS-Access HOW TOs
  
  1. Import Objects with VBA
  2. Create Excel / Word File from Access
  3. Create Text File from Access
  4. Rename File using FileSystemObject
  5. Display Path and File Info
  6. MS-Access How-Tos
  7. Sum() Min() Max() Avg() ParamArray
  8. Rounding Function MRound() of Excel
  9. MS-Access and Reference Library
  10. Date and Time Values
  11. User-Defined Data Type
  12. Learn Binary Numbering System
  13. Learn Binary Numbering System-2
  14. Octal Numbering System
  15. Hexadecimal Numbering System
  16. Create your own Color Palette
  17. Invoke Word Mail-merge from Access2007
  18. SearchForRecord Macro Action Access2007
  19. Storing Bitmap Images in OLEObject/Attachment Fields
  20. External References in Conditional Formatting Expression
  21. Archiving Master Data
  22. Editing Hyperlink Address Manually
  23. ---GO TOP---

• ACCESS 2003 SECURITY
  
  1. Microsoft Access Security
  2. Create User Account
  3. Create Group Account
  4. Add Users to Security Groups
  5. Remove Users from Security Groups
  6. Delete User Account
  7. Delete Group Account
  8. Create or Change Security Password
  9. Clear Security Password
  10. Assign or Remove Permissions
  11. Assign Default Permissions
  12. View or Transfer Ownership
  13. Transferring Ownership of Database
  14. Permission to View / Run Query
  15. Default Permissions for New Query
  16. Run Permissions Property
  17. Convert Old Version Databases
  18. Convert Old Version Workgroup File
  19. Sharing Previous Version Database
  20. Creating User-Account with VBA
  21. Create a Security Group Account with VBA
  22. Users Group and Permissions
  23. Group Account Permissions with VBA
  24. Change Secure DB to unsecured
  25. User and Group Check
  26. User-level Access Security & Access2007
  27. Running Workgroup Admin in Access2007
  28. Restoring disabled Full Menus Access2007
  29. Access Security Key Diagram
  30. Users & Groups Listing
  31. ---GO TOP---

• MS-Access And INTERNET
  
  1. Using MS Access on the Internet
  2. MS-Access and Internet
  3. Example ASP File
  4. Create DSN Connection
  5. Connect to Database
  6. Modify Access Data Online
  7. Inserting Data
  8. Modifying Data
  9. Deleting Data
  10. Example-1 ASP
  11. Example-2 ASP
  12. Example-3 ASP
  13. Insert-form.html
  14. insert.asp
  15. amend-select.asp
  16. amend-change.asp
  17. amend.asp
  18. delete.asp
  19. delete-select.asp

1. ---Back to Top---