Microsoft Office JavaScript Library Will Be Complete Across Office 365, iOS and Mac Early Next Year

Microsoft Office JavaScript Library Will Be Complete Across Office 365, iOS and Mac Early Next Year

Microsoft will be having a consistent JavaScript API across the Windows, Mac and mobile version of Office.

Looking at Microsoft Office development is like looking at an old tree’s cross-section – you will find different layers from different eras. Each layer is carefully maintained for compatibility. Run the just-released Word 2016, enable the Developer ribbon, click VBA, and there is Visual Basic for Applications 7.1, using traditional VB as found in the long-deprecated VB 6.0 from 1998.

microsoft access 2016 vba

Since VBA is built on COM (Microsoft’s object technology) and has fast access to the COM interfaces exposed by Office applications, VBA is well suited to automating Office. The ability to record your actions as editable VBA macros is one great feature for the developers. Apart from that, you can also write COM add-ins for Office applications in any language that supports COM, still fully supported in Office 2016. Continue reading “Microsoft Office JavaScript Library Will Be Complete Across Office 365, iOS and Mac Early Next Year”

Microsoft Access Database Tutorial VBA Code Task Tool To Outlook

Microsoft Access Database Tutorial VBA Code Task Tool To Outlook

It’s very strange how Microsoft Access database systems and processes constantly repeat themselves and once again I’m working on some VBA code to communicate with Microsoft Outlook (Email and contact management system).

Here you can see a quick video of such a simple but effective utility I offer (for only the cost of a couple of pints of beer!) – check it out…

httpvh://youtube.com/watch?v=-gm0aBVfKMg

Microsoft Access Database Tutorial VBA Code Task Tool To Outlook

The Task Tool utility was built to demonstrate the ease of use and how MS Access VBA code can communicate with Continue reading “Microsoft Access Database Tutorial VBA Code Task Tool To Outlook”

Microsoft Access Database – My Very Own Custom Built Utilities

Microsoft Access Database – My Very Own Custom Built Utilities

This time of year and over the last few weeks, we get new users or students entering the Microsoft Access database arena from people of various walks of life whether that is a student learning about IT and computer based systems or starting a new job or career wanting to brush up on their skills that I like to remind all of my custom built utilities which serves more than one objective.

microsoft access database custom built utilities

The tools I offer are not free but they do come with a money back guarantee and 30 day email support so you can at least try and ask questions. The main point to Continue reading “Microsoft Access Database – My Very Own Custom Built Utilities”

Microsoft Access Database Forms: Highlight Current Record For A Continuous Form

Microsoft Access Database Forms: Highlight Current Record For A Continuous Form

As you migrate from version to version, working with Microsoft Access database forms becomes more intuitive and easier to design and implement using the pre-built templates, wizards and improving richer set of formatting tools.

Conditional formatting (once it was introduced) started life as a setting for up to three conditional formats which satisfied most requirements but now the with the later versions, it’s layered and can exceed this number for true flexibility and complex conditioning.

microsoft access database forms highlight current record

The point here is what level of setting conditional criteria for this format do you know?

In this simple example, mixing some Access VBA code into the mix and using just one condition, you get Continue reading “Microsoft Access Database Forms: Highlight Current Record For A Continuous Form”

Sending Email Using Microsoft Access VBA

Sending Email Using Microsoft Access VBA

If you use the later versions of Microsoft Access, you will have probably come across the tool to set and manage emails to normally Microsoft Outlook from a selected table or query and select individual valid records but this can be problematic with connection, server and services if not correctly configured.

There is a custom built solution which talks about sending email using Microsoft Access though it is not a free utility, it does have a free locked demo to evaluate and the following video (5 mins) explains a bit more about it…

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

If you are feeling brave enough, you can build your own version and in fact the author Continue reading “Sending Email Using Microsoft Access VBA”

Concatenating Multiple Rows Into Single Line In MS Access

Microsoft Access Database: Concatenating Multiple Rows Into Single Line In MS Access

Now I’m not going to take credit for this next piece of Microsoft Access database VBA code as it was originally created by a well-known Allen Browne – many thanks!

Instead, I’m going to borrow his code for you (my regular readers) just in case you haven’t seen this before and add an element of quickly adding criteria to a query as a workaround to avoid expanding the VBA code itself.

concatenating multiple rows into single line in ms access

There are potential problems and errors this code will throw at you if you try to add criteria in the normal manner or embed any SQL directly into the calling custom function which means using some common sense and logic to deal with the challenge here.

Microsoft Access Database: Concatenating Multiple Rows Into Single Line In MS Access

First of all, let’s get the function to work and the query understood. In a new module, you will need Continue reading “Concatenating Multiple Rows Into Single Line In MS Access”

Microsoft Access Form Designs: Using VBA With On Timer Event

Microsoft Access Form Designs: Using VBA With On Timer Event

This Access form will self-destruct in 10, 9, 8, 7….

Using the unknown or unused Timer Event for your Microsoft Access form designs can be quite effective and really automate your background processes.

I was recently asked if this application has a timer control which one could illustrate as a count down or trigger code on a set time.

microsoft access form design on timer

You can show a real time count down by using basic controls like a text box or launch another form (or report) or even Continue reading “Microsoft Access Form Designs: Using VBA With On Timer Event”

How To Add A Flash Movie SWF File To A Microsoft Access Form

How To Add A Flash Movie SWF File To A Microsoft Access Form

Working with Microsoft Access form designs requires patience and a plan especially when wanting to work with other form controls over and above the standard tools made available by default.

One particular ActiveX control is the ‘Shockwave Flash Object‘ which will allow you to play flash video (or SWF file formats) in an Access form.

Adding A Flash Movie To A Microsoft Access Form

You will need to first load the library file if not added or enabled in order to render this control ready for use. That means Continue reading “How To Add A Flash Movie SWF File To A Microsoft Access Form”

MS Access Database Forms: Using The SelStart And SelLength Properties

MS Access Database Forms: Using The SelStart And SelLength Properties

Have you noticed when you navigate between control fields in your MS Access database forms that it automatically selects the entire content (if not empty) instead of placing the cursor to the end of the last character?

ms access database design form

Using some simple Access VBA code, you can now control the placement for the cursor to mimic and automate placing the insertion point Continue reading “MS Access Database Forms: Using The SelStart And SelLength Properties”

Microsoft Access Database Tutorial – How To Use Spellchecker On A MS Access Form

Microsoft Access Database Tutorial – How To Use Spellchecker On A MS Access Form

You’ve seen the Microsoft’s spell checker tool across Word, Excel and other Office applications and it’s even available within Microsoft Access database too.

When entering data into any input control, text box, memo fields or anywhere else users enter text, you can quickly call the spell checker tool using the keyboard shortcut F7.

microsoft access database spell checker tool f7

If you use MS Access forms and in all honesty, you should be using them, you could automate the spell checker tool on selective controls using Continue reading “Microsoft Access Database Tutorial – How To Use Spellchecker On A MS Access Form”