Thursday, October 17, 2013

Word 2013: Send as e-mail attachment directly from Word

File \ Share

source: How to Send a Word 2013 Document by E-Mail

Add network printer using hostname instead of IP

Add printer
Select Standard TCP/IP Port Local
Add Local Port
Type [Host]name of the printer (can be sought from printer web management)
Select driver, and so on

On XP?
Still don't know but we can use Printer URI
(on Samsung printer's web console can be found on "Network Settings" \ "RAW TCP/IP,LPR,IPP" )


Wednesday, October 16, 2013

Pairing Samsung Galaxy Note with Plantronics Discovery 975 (bluetooth headset)

Turn on the headset
To enter pairing mode, hold the power button down long enough until you see the flashing white and red lights!
Start scanning from your phone

Related:
Googling for "plantronics discovery 975 pdf" to obtain User Guide

Search (and then Backup) old files

Objective:
Want to search for all files on folder MYFILES (and its subfolders) with Date Modified = 2011 or later and then burn them to DVD

Since we can NOT directly search for files modified on 2011 or later AND WRITE THEM TO DVD, we must search for 2012 or later instead then to remove them prior to burning:
Copy MYFILES to MYFILES_2
Perform Windows search on MYFILES_2:
datemodified:‎>31/‎12/‎2011 kind:<>folder
Delete all files found
Burn MYFILES_2 to DVD
Now you can remove MYFILES_2 folder

Related
--------
Get a list of files not accessed (means at least opened, directory-listing not counted) since X days ago
NOT TRIED YET:
Lepide File Server Audit (not free)
Netwrix Auditor (after trial period ends, switch to community edition)

How do I access a file without updating its last-access time? October 10th, 2011
Discuss the "discrepancy between the file system definition and the intuitive definition" of last-access time.

How NTFS Works
Last Access Time
Each file and folder on an NTFS volume contains an attribute called Last Access Time. This attribute shows when the file or folder was last accessed, such as when a user performs a folder listing, adds files to a folder, reads a file, or makes changes to a file.
Note to self:
So it kinda hard to tell when a file is actually opened and when it is just being scanned (by directory listing)

How can I know when a file was last read or accessed on Windows?

Thursday, October 10, 2013

Determine what application is using your external/USB drive so it won't eject

aka. determine what app has a file locked (keep a file in use)

Process Explorer (press Ctrl+F then type drive letter of the drive)
source: Which programs are using my USB flash drive?

alternate way:

From Computer Management \ Disk Management, make the drive offline then re-try to eject
(Next time you plug it, remember to make it online again before use)

Tuesday, October 8, 2013

Suppress "Do you want to rename the record?" when changing PK

Set form property of DelayedInsert to Yes
source: Able to suppress "Do you want to rename"

Data Source file location

Win 8:
C:\Users\dave\AppData\Roaming\Microsoft\Queries