5 Simple To Use Microsoft Access Macros

5 Simple To Use Microsoft Access Macros

microsoft access macrosI recently wrote an Ezine Article for the newbie Microsoft Access Macros user and introduced them to the softly, soflty approach to automating their Microsoft Access database.

 

Take a look…

Learn How To Use 5 Simple Microsoft Access Macros Without Any Programming

When the word ‘Macros’ is mentioned in the context of Microsoft Access Macros, most users feel a little overwhelmed and shy away from implementing any. They know it’s part of the smooth running and the automation for Continue reading “5 Simple To Use Microsoft Access Macros”

MS Access Images – Add, Reuse, And Update Images On Forms And Reports

MS Access Images – Add, Reuse, And Update Images On Forms And Reports

Take a look at this 5 minute video tutorial about MS Access images which demonstrates how to insert, update and manage the image gallery which is a new feature to Microsoft Access 2010.

httpv://www.youtube.com/watch?v=0GsF_F2RXY0

MS Access Images – Add, Reuse, And Update Images On Forms And Reports

The benefit of using MS Access images (via the Access 2010 gallery) is when adding newer or any updated changes takes place and you re-upload images, they are dynamically changed on all form and reports where they had been originally applied (or embedded as OLE).

This can be used for both standard Access forms and reports as well as for the newer web based versions (though there are some restrictions as the video narrator mentions).

Designing forms and reports is a time consuming aspect of database design and the last thing you need to manage are MS Access images. To learn more about Access forms and report, please review my eBook offers – they all come with 100% guarantees.

Problems With Memo Fields When Running A Query In Access 2010

Problems With Memo Fields When Running A Query In Access 2010

I recently wrote an EzineArticle about the Memo fields when running a query in Access and what has changed with the latest version (2010).

It can affect criteria and causes sorting challenges and should be avoided if at all possible. But if you really need it, then read on and know your options…

Creating Microsoft Access Queries – Why You Should Avoid The Memo Data Type In Access Queries

I recently worked on a migration Access database project converting from version 2003 to the current 2010 and as part of my testing Continue reading “Problems With Memo Fields When Running A Query In Access 2010”

Microsoft Access Database: Microsoft Access 64 Bit Versus 32 Bit

Microsoft Access Database: Microsoft Access 64 Bit Versus 32 Bit

By default, when installing Microsoft Access 64 bit it in fact installs the 32 bit version and you have to choose the right version making sure you have the right operating system

microsoft access 64 bitThe following link explains more of the main differences between Microsoft Access 64 bit and 32 bit versions Choose the 32-bit or 64-bit version of Microsoft Office

Keep upto date with my Facebook page and why not ‘Like’ it too.

Microsoft Access Database: Query Data Source Mail Merge To Microsoft Word

Microsoft Access Database: Query Data Source Mail Merge To Microsoft Word

Using Microsoft Office as collaboration between Microsoft Access queries as a data source mail merge into Microsoft Word bypasses the more conventional approach of using either a separate Excel spreadsheet or Word table.

Take a look at how to connect an Access query to a Word document (mail merge)…

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

Microsoft Access Database: Query Data Source Mail Merge To Microsoft Word

There are several approaches when creating the data source mail merge and depending on the complexity of the query you may want to apply criteria direct from an Access query instead of filtering via the connection into Microsoft Word’s document data source.

data source mail mergeYou can combine filtering and sorting of the data source mail merge from both Microsoft Access & Word.

The query is the heart of the system and is dynamic so any new mail merges will always be up to date. Take a look at my eBooks on learning and building Access queries.

Microsoft Access Database: Access VBA Database Refresh or Requery?

Microsoft Access Database: Access VBA Database Refresh or Requery?

access vba database

 

One of the quickest ways when using an Access VBA database and is also a shortcut to relisting and rebuilding data lists and control values is to call the Refresh or Requery command using the Me object which is very handy indeed.

 

Take a look at the following article…

Microsoft Access – Refresh Or Requery?

When using Microsoft Access, many novice developers have difficulty understanding the difference between Me.Refresh and Me.Requery. So, let’s Continue reading “Microsoft Access Database: Access VBA Database Refresh or Requery?”

Microsoft Access Database: Access DLookup Function Example with Access VBA

Microsoft Access Database: Access DLookup Function Example with Access VBA

Take a look at this six and half minute video of how to utilise the Access DLookup function using a little of Access VBA code too (not too difficult but necessary in this example).

httpv://www.youtube.com/watch?v=ZmcGlywA4ss&feature=related

Microsoft Access Database: Access DLookup Function Example with Access VBA

Of course you do not have to use Access VBA code when applying the Access DLookup function. Instead, you can populate fields by using a calculation or auto-lookup query instead.

Access DLookupWith the calculation method however, this is just an expression and will not be updatable should data in fields need to be edited.

Take a look at my eBook on More Access Database Queries to learn about the ‘Auto Lookup’ query and other more adavnced techniques.

Microsoft Access Database: Access Development For Your Business Needs

Microsoft Access Database: Access Development For Your Business Needs

access developmentThe following article I found covers the key reasons and why small businesses in particular use Microsoft Access development for their business needs as it can be tailored to exact requirements whether the client, developer or power user has a go!

 

Take a look at…

Access Development – Perfect Database Solution for your Business Needs

Access development is being preferred by many small and big business organizations as it offers several solutions for managing your data effectively. This database system is the most widely used desktop database system in recent times. The product is from Microsoft and its popularity has Continue reading “Microsoft Access Database: Access Development For Your Business Needs”