Monday, May 13, 2013

Access Security Notice - Fix

To stop Access Security Notices from popping up.

Create a Trusted Location (Local Folder) for the Parts Frontend.

click on image to view

















Steps to Create a Trusted Location in Access:
  • Launch (Run) Access
  • Select Options (bottom left side of dialog)
  • Trust Center (left)
  • Trust Center Settings (button) on far right
  • Trusted Locations (left pane)
  • Add new location (button)
  • Enter Folder Path (to the Parts Frontend)
  • Check Subfolders of this Location are also trusted
  • Click Ok

Notes:

The Parts_Frontend.accde should be placed in a Trusted Location on the User's PC.

The Parts_Frontend.accde application does not contain malicious code or viruses. 
This can be verified by using any popular virus scanner.

The Parts backend database only contains data. The security warnings apply to the Parts_Frontend.accde file which contains compiled VBA code for Access.

Contact Parts if have questions or need technical support.

That's It !

Sunday, May 12, 2013

Non-breaking space - Wikipedia, the free encyclopedia

Non-breaking space - Wikipedia, the free encyclopedia:

The Non Breaking Space (NBSP) character can create issues when searching or comparing database fields.


When Save is selected from the Parts Frontend Command Bar data entered in the currently displayed record is Trimmed and Cleaned.


That's It !