Microsoft Access Tips
Note: To find a tip on this page (and if you are using
Internet Explorer), click on 'Edit' on your tool bar and select 'Find (on
this page)'. The Find box will open add, a key word into 'Find What' box
and click on Find next. i.e. if you enter 'combo' the first instance of
combo will be found, click on 'Find next' to find the next 'Combo' and so on.
Index
Tables
Appending to an AutoNumber Field
Adding a Prefix to an AutoNumber Field
Duplicating the Previous Value in a Field
Customising the Format of a Number Data Field
Limiting the number of records in a Microsoft Access Table
Hiding a Table in Microsoft
Access
Relationships
Printing a Report of the Relationships
Referential Integrity
Preventing Orphan Records
Queries
Quick Tips for Queries
Append Query
Counting Check Boxes in a Query
Filtering Multiple Fields
Capitalising the First Letter of Each Word (Proper Case)
Please Wait – Query Being Processed
Append
Fields from Different Tables into the One Field
Selecting Specific
Rows to Display in a Query
Excluding values
in a Query
(1)
Excluding values
in a Query
(2)
Using an Update Query to format a field Using the Mid, Left and Right Functions
Union Query Example One
Union Query Example Two Summing the Total of Two Fields in the Same Table
Totals Queries
Cross Tab Queries
Using Cross Tab Queries a Date and Time Example
Forms
Changing Many Properties at One Time
Form Short Cuts
Vertical Alignment
How the User can Move to a New Line in a Memo or Text Field
How to Display the "&" (Ampersand) Symbol in a Label
Filtering Multiple Fields
Selecting Multiple Objects in a Form or Report
Turning Labels Off
Hiding the Property Window in Form View
Message Box if there are No Records in a Form
Conditional Formatting Advanced
Vertical Display of Labels or Text Boxes
Number Format and Decimal Places
Twips and Other Secrets to Sizing Forms and Reports
Adding a Clock to your Form
Combo Boxes
Using a Combo Box to Filter Another Combo Box
Making a Combo Box Drop Down Automatically
Concatenating Fields in a Combo Box
Continuous Forms
Conditional Formatting Introduction
Formatting a
text box depending on the number value
Subforms
Accessing Subforms in Microsoft Access 97
Reports
Adding Sequential Numbers to a Report
Hiding the #Error Message in Reports
Removing Extra Spaces on a Label
Creating a Cover Page for your Report
Inserting Page Breaks After a Grouping in a Report
Selecting Multiple Objects in a Form or Report
Cancel a Report if there are No Records
Reports Snapshot Viewer
Combining Field
Entries when One Value is Empty
Adding Two Query
Results to the one Report
Macros
AutoExec Macro
Active X Controls
Active X Calendar Control
Visual Basic for Applications
Events
Form Events
Code for Forms
Forcing Uppercase
Opening the ‘Browse’ window to add a path of a file or locate a file
Using a combo box to automatically complete another field
Setting Text Font Using VBA
Counting the words in a memo
field
Codes For Tables
Set Primary Keys for a Table using VBA Code
Code for reports
Printing multiple copies of
a report
Code related to
accessing and manipulating other Microsoft Office Programs
Opening a specific Microsoft Word Document dependant on the current record
Calculations
How Many Whole Numbers
Miscellaneous
Copying Objects (Forms, Reports, Tables, etc.)
Display a Particular Form on StartUP
Referencing DAO in Access 2000
Third Party Add Ins
Changing the search default from ‘Whole Field’ to ‘Any Part of Field’
Slow database when split and put on a network
Compacting A DatabaseIIF examples
What is a IIF function?
Message Boxes
Forcing a New Line in a Message Box
Dates and Times
Adding Times Greater Than 24 Hours
Admissions Per Hour
Calculating Time Interval in
Minutes
Enter Today’s Date into a
field using a Command Button
Validating Dates in a Table
Retrieving the last time entry for each day
Emails
Sending
an Email by Double Clicking on an email address
Outlook
Removing Access Attachments
Do you like these tip? Subscribe to my weekly Newsletter to receive tips
weekly via email.
Click Here to subscribe.
|
