Before you can insert the code to call the file selector box you will need to add to your Access database the VBA module that handles some pretty low level stuff. This module has not been written by us, but has been published in the public domain by Microsoft Access MVP Ken Getz. Firstly click here to […]
Category: Office 2003
Now that you have created your form to store the path name all you need to do is type in the filename of your picture for each record, and that’s it! However, if that’s all we were going to do it would be pretty pointless having this long tutorial, we would just tell you to […]
We’re often asked how to store picture along with the records of an Access database application. The short and simple answer is DON’T. Storing images as part of the database recordset can lead to massive bloating of the database tables, as all pictures that are stored within the tables are converted to bitmap format for […]
Microsoft Access Forms are the basic interface between your application, and your users. Whilst form are generally used to provide easy data entry and manipulation, correctly designed and well thought out forms can also be used to create your own menu system. Because the Microsoft Access form provides the main interaction with your users, it’s […]
Splitting an Access database is about the most important thing that you can do to add stability to an application and any experienced developer will almost certainly tell you to ‘split’ your database into a Front End (FE) and Back End (BE) The Front End will contain all the Forms, Queries, Reports, Macros, and VBA […]
Before attempting to create your Microsoft Access database you might want to consider some of the points we have compiled below, these are only suggestions. There are no hard and fast rules, but bitter experience has taught us that following these rules can make application development much easier Do split your database into a front […]
Like most programs, Access has certain terms and phrases that are specific to it. In this Microsoft Access glossary we have attempted to list as many of the terms you are likely to come across below. If you come across a word or phrase that you either don’t understand, or that you think should be […]