Access Forms VBA: IsLoaded Property Check

Access Forms VBA: Using The IsLoaded Property

Most of the time when developing with MS Access to achieve a really smooth look and feel to your database you will need to eventually code your application and one area where you should start would be with Access forms VBA since end-users will be operating your proud achievements and want to make this a really easy experience for the novice.

With my clients, they like to see something very early on in the development cycle and even though I still need to follow my own planning and designing methodologies, I soon lean towards the front-end namely forms so that my client feels that I’m providing value for money and they can see something really tangible.

If I think of the many times I’ve had to counsel clients during the building phase without seeing any real impact in terms of nice looking screens and other tangible objects – I probably should of added some life coaching time too prior to the project!

Access Forms VBA: IsLoaded Property Wrapped In An If

access forms vba codeOne aspect of Access forms VBA is to test to see if a form is actually open (or loaded) before interacting with it as it will cause errors. One way to validate this is to introduce the IsLoaded property.

Since you want to test it too, you will need to wrap it into a standard Continue reading “Access Forms VBA: IsLoaded Property Check”

Preview Of Access 2013 (First Look At Access 15)

Preview Of Access 2013 (First Look At Access 15)

So what’s new with Access 2013 (or code named Access 15)? Well, to be honest only one thing really and that’s the word ‘apps’.

Since the release of Access 2007, you had the beginnings of being able to publish your database to an online server, host website, SharePoint service or other Access hosting service which required some basic subscription service.

Now you have a feature called apps which brings this current database application even closer to an online collaboration with a set of richer tools.

Preview Of MS Access 2013 (First Look At Access 15)

When you start Microsoft Access, you are Continue reading “Preview Of Access 2013 (First Look At Access 15)”

MS Access Indexing: What And How To Apply

MS Access Indexing: What And How To Apply

Working with your database, Access indexing is often overlooked and ignored – why? Because your application will still run, working well and see no reason to take any action. In fact, ignoring this feature you do open yourself up to more performance issues particularly for the larger database file.

Tale a quick look at an updated video tutorial about Access indexing and why you should seriously consider setting your fields properly.

httpvh://www.youtube.com/watch?v=lX0g1i9tsSg

MS Access Indexing: What And How To Apply – My Thoughts

You need to be clear about the differences between primary and foreign keys as they are both types of indexes and play an important role in setting your database relationships.

Remember, an indexed field makes your field mandatory and cannot be left empty (or as a Null value) so don’t over use them as it will restrict and frustrate users.access indexing

One of the biggest strengths to the Microsoft Access application is the ability to join tables together forming relationships which helps to keep the data integrity as tight as possible. We therefore need to master Access indexing with the concept and practices of understanding database relationships (RDBMS)

How To Convert Numbers To Words: Access VBA Function

How To Convert Numbers To Words: Access VBA Function

Once again, I’ve been asked by a client to create procedure to turn a monetary number (numerical value) into its text equivalent and so I wanted to share with you how to convert numbers to words using Visual Basic code that can also be applied not just to your Access database but with any application that entertains VBA code! how to convert numbers to words

How To Convert Numbers To Words: The Steps

This article is intended for users who know and have some VBA code knowledge but need a little push to Continue reading “How To Convert Numbers To Words: Access VBA Function”

Access Printing & Page Setup Options

Access Printing & Page Setup Options

Unlike other Microsoft Office applications (Excel, Word etc.), Access printing can be a challenge or perhaps just a little disorientating!

There are several ways and places that you can choose to set the page setup and print something (an object) from your database application and in this short concise post I want to cover the basics and know your options.

Access Printing & Page Setup Options – The Basics

Here’s a quick tip for you! If you select (not necessarily open) any object say a table or a report, then press CTRL + P from the keyboard (which is the shortcut key to load the Print dialog box), you can send that object to print and applies to all versions.

The print command for any object prints the Continue reading “Access Printing & Page Setup Options”

Access Datasheet View: How To Apply Formatting

Access Datasheet View – Formatting Options

Take a look at the following two and half minute video tutorial on how you apply formatting to your Access datasheet view in your tables; the back-end area of your Acess database file.

httpvh://www.youtube.com/watch?v=DT5Pb4pY6RA

Access Datasheet View – My Comments

In the video, it quickly showed you how to change the column widths and row heights plus setting Continue reading “Access Datasheet View: How To Apply Formatting”

How To Write SQL Queries In Access

How To Write SQL Queries In Access

Just in case you haven’t heard, SQL stands for Structure Query Language and is the backbone code to asking those all important questions in your Access database or any database application as a matter of fact.

This post will introduce you in how to write SQL queries and why in some cases this is the only option open to you but taking advanatge of both the QBE grid (another acronym for Query By Example) and SQL View screens will get you started quickly and easily.

How To Write SQL Queries In Access – Some Simple Steps

If as with like most Access databases you have related tables or joins between tables the likelihood will be to bring two or more tables or queries together in a query and apply various criteria, calculations and sorting to output and answer your request.

Therefore, this example is a typical one where two tables with a ‘many-to-one’ relationship is established between the Customers and Orders tables.

how to write sql queries

Using the QBE grid one does not need to know how to write SQL queries as this grid provides for 95% of most Continue reading “How To Write SQL Queries In Access”

Working With Access Form Subform Controls

Working With Access Form Subform Controls

Here’s a quick video tutorial on how Access form subform controls work together showing the ease of setting the simple properties (via the Property Sheet) to manage their relationships which is optional as not all subforms have to be related.

httpv://www.youtube.com/watch?v=M9IUXN8Szh4

Working With Access Form Subform Controls

To create a subform or subreport (for reports), you can also use the wizard approach too which steps you through various prompts for you to complete giving you that head start.

access form subformThis video is actually part of a series of creating and designing Access form subform controls and how to add calculations (using expressions) with other controls and any form of calculation for a form or report always starts the equal ‘=’ sign (the same as with Excel).

Form designing is an art and may developers take a lot of time and effort in producing good looking forms and have a real polished application to be proud of. You need to master the main concepts and some useful design tips and recommend considering my eBook on How to build Access database forms.