fbpx
Logo

Category Archives: Reports

Setting Your Forms And Reports In Access As The Defaults


MS Access

If you are regular as clockwork like me (I mean creating Access databases that is), then setting your forms and reports in Access other than using the ‘Normal‘ blank default should help – but does it? Just to bring everyone else up to speed, you can set your MS Access form and report defaults by typing the name of your custom form or report in place of the standard ‘Normal‘ option which means all new objects will inherit these designs […]

Tags: , , , , ,

Microsoft Access Database Articles: Check Out My EzineArticles


Microsoft Access Database

It’s too hot to work – taking a vacation! While I’m away, checkout my Microsoft Access Database EzineArticles or click that big ‘Diamond Expert Author’ logo to the right of my home page. Microsoft Access Database Articles: Check Out My EzineArticles Here are some of the direct links to popular articles: Microsoft Access Database Design Tips – Want To Know 7 Quick Tips To Designing Your Access Database? I’m often asked How do you design a good Access database? My simple […]

Tags: , , , ,

Access Database Forms: How To Print A Record In Access Through A Form


Access Database Form

Interacting with Microsoft Access database form provides that rich, smooth and harmonious way to control data with functionality.  One popular feature is the ability to call another object namely a report for the active/current record and either preview or print a hard copy avoiding the extra steps of navigating and finding the same record via the database or navigation window. So, how do you print just the one record you are viewing via the form? You will first need to create […]

Tags: , , , , ,

Access Report VBA: Using Some VBA Report Properties To Automate Your Microsoft Access Reports


VBA

Working and automating an Access report VBA will require some knowledge of the module window (VBE), the defined sections and an insight to pre-defined events for each element of a report design interface. However, let’s take a step back and identify some of the report properties that can be used in a module that do not appear in a standard design view layout for a report. The three I want to highlight here and you may want to note are: […]

Tags: , , , , ,

MS Access Report Design Tip: How To Hide Duplicates (Selectively) In Your Access Reports


MS Access

One of the many tips within the access database design vault are normally hidden secrets of unknown properties. For your MS Access report design collection of properties, you may have noticed a wealth of useful attributes to choose and one in particular I want to highlight is the ‘Hide Duplicates‘ property for reports. However, this property is not perfect as I will explain in a moment. Instead, you may want to use another hidden property (outside of the Access VBA library) that can actually […]

Tags: , , , ,

Bar Code Font That Can Be Freely Used With Microsoft Access


Microsoft Access

Many Microsoft Access databases are designed to manage the products and order workflows of any production based or manufacturing business and with any delivery note or dispatch document using bar codes makes capturing data very easy. However, your operating system (typically Microsoft Windows) will not have a default bar code font installed but with this free resource courtesy of BarcodesInc, you can now download and install the free fonts that is available across Windows and not just for MS Access. When you download and install this new font, […]

Tags: , , , , ,