VBA Macros | BarcodeFAQ.com

Barcode macros do not run, files do not open or #NAME error is displayed

idautomation — Tue, 25 Sep 2018 15:25:29 +0000

Solution(s): When using Barcode Macros and VBA for Microsoft Office or ActiveX Barcode Controls in a barcode field with Office XP, 2000 & 2003, one of the following may occur: A macro in Excel may return #NAME in the field that is supposed to represent a barcode. The file may open without any warnings and the barcode may not…
Read more

The post Barcode macros do not run, files do not open or #NAME error is displayed first appeared on BarcodeFAQ.com.

Using Access with Word Mail-Merge

idautomation — Mon, 24 Sep 2018 20:47:50 +0000

Solution(s): At the time this page was written, MS Access had no built-in components to apply the formula needed to format the static data appropriately. This conversion must be done either before the data is put into the table, or by using one of IDAutomation’s VBA functions when the data is ready to display in an Access…
Read more

The post Using Access with Word Mail-Merge first appeared on BarcodeFAQ.com.

How to create a Barcode add-in for Excel

idautomation — Fri, 21 Sep 2018 17:26:49 +0000

*This Barcode Addin is only compatible with Office 2010 and earlier. Solution(s): This set up will allow the ability to add the IDAutomation VBA Code and Barcode Macros as an add-in for Excel so the IDAutomation Barcode Macro functions will automatically be available every time a spreadsheet is created. How to create a barcode add-in for Excel:…
Read more

The post How to create a Barcode add-in for Excel first appeared on BarcodeFAQ.com.

Resolve ‘content disabled’ warnings

idautomation — Fri, 21 Sep 2018 16:29:17 +0000

Applies to: IDAutomation Native Barcode Generator for Excel IDAutomation VBA for Barcode Fonts IDAutomation ActiveX Controls IDAutomation Native Barcode Generator for Access Solution(s): When opening a file in Microsoft Office 2007 or later containing Barcode Macros, VBA or ActiveX Controls, a security warning message of “Some active content has been disabled” or “Certain content in the database has…
Read more

The post Resolve ‘content disabled’ warnings first appeared on BarcodeFAQ.com.

Compile Error: Can’t find project or library

idautomation — Thu, 20 Sep 2018 18:37:04 +0000

Problem: When using the VBA Code or Macros in Microsoft Access or Excel, the following error is received “Compile Error: Can’t find project or library” Solution(s): Most likely, the application has lost the reference to an ActiveX or COM object or type library resulting in the above error when using VBA functions in Access or…
Read more

The post Compile Error: Can’t find project or library first appeared on BarcodeFAQ.com.