Project Perfect
PROJECT  PERFECT
                 Project Management Information
                          Specialists in Project Infrastructure

Home - Microsoft Access Development

Microsoft Access Development

Access Help and Samples

As well as undertaking Microsoft Access development for clients, we also publish some of the useful Access code we have developed. The following library of Access VBA samples may prove useful for MS Access Developers.

Adding a Field to a Linked Table . If you need to update a linked table from the main Access database, here is the code to do it. You can set it to run on startup and see if the field is in the linked table. If not it will add it.
Microsoft Access Development Expanded Text Box Sample
Expanded Text Box. Click on a text box and display a larger input screen. When you are finished editing the large form, transfer the text to the original form.
Microsoft Access Development Expanded Text Box Sample
Create a temporary copy of a Table. Sometimes you might want to copy a table, do some manipulation and then delete it. This function will create the table by just passing the name.
Microsoft Access Development Create Temporary Table Sample
Count the number of Records. This generic function can be used to count the number of records returned by an SQL query. It is useful for finding if there are any records. If there are no records, it returns zero.
Microsoft Access Development Generic function to count records in a query
Check if a form is open . Another generic function to check if a form is open. Useful to put into a generic module when building databases.
Microsoft Access Development Generic function to check if a form is open.
Change the font size in a label. If you have a fixed length label and the caption text can vary in length (e.g. A person's name on a report header), you can change the font size using this function,
Microsoft Access Development Generic function to change the font size in a label.
Calculate the number of days in a month . This is a simple function to calculate the number of days in a month. Pass a date to the function and it returns the number of days in the month.
Microsoft Access Development Generic function to calculate the number of days in a month.
Generic Functions. Functions you can use multiple times in an application.

  • Check if a field is null, blank or zero
  • Check if a form is loaded
  • Check if a form is a subform
Microsoft Access Development Generic function to check if a field is blank, null or zero; a form is loaded; a form is a subform.
Help Function. This includes a sample database that illustrates how to build a help function in Microsoft Access without using the standard help functionality. The help is stored in a table and users can update their own help.
Microsoft Access Development create a Help Function.
Adding a Field to a Linked Microsoft Access Database Table. How to add a new field to a linked database from the Front End Database
Microsoft Access Development create a Help Function.
Check if it Exists. Check if a form or report exists. Check if it is loaded. Check if a field exists in a table. Check if an external file exists.
Microsoft Access Development create a Help Function.
Sending Emails and Storing Hyperlinks. Send an Outlook Email from Access, create a file, then store the file hyperlink in a table. Download a sample database. Microsoft Access Development create Outlook Email and hyperlink in Access table

.

Return to the top