Microsoft Access Help
The following is an example of thoroughly documented code. It is an extract from a program we produced for a client.
The following is an example of thoroughly documented code. It is an extract from a program we produced for a client.
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.
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
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.
Another generic function to check if a form is open. Useful to put into a generic module when building databases.
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,
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.
- Check if a field is null, blank or zero
- Check if a form is loaded
- Check if a form is a subform
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.
How to add a new field to a linked database from the Front End Database
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.
We have done lots of development of Microsoft Access over the last twenty years and include a number of code snippets and guidance to developers using VBA macros.