Posts

Showing posts from September, 2011

Word | Resize all images simultaneously

Situation: You have hundreads of images in a word document. You want to grab them all, and set the same width and height. Solution: - Open Developer Tab (may require activating it on Word Options, Popular, "Show Developer tab in the ribbon") - Create a new macro Public Sub ResizePics() Dim oDoc As Document, oShape As InlineShape Set oDoc = Application.ActiveDocument For Each oShape In oDoc.InlineShapes oShape.Height = 270 oShape.Width = 360 Next oShape Set oDoc = Nothing End Sub Remember to convert cm's to pixels http://www.translatorscafe.com/cafe/units-converter/typography/calculator/pixel-%28X%29-to-centimeter-%5Bcm%5D/

SharePoint 2010 | Enabling Blocked File Types

Image
Problem: We cannot add several file types to a SharePoint Site with SharePoint Designer or through a WSP solution. Examples are: ashx, dll, exe, msi. Error: "Server error: The following file(s) have been blocked by the administrator: /Style Library/Empower/images/Imfuscator.dll" Solutions: - From Microsoft: place your files in a zip and upload them packaged - Configuring Central Admin: Security, Define blocked file types (/_admin/BlockedFileType.aspx) - For SharePoint Online / Office 365: Issue a "Service Request" (https://portal.microsoftonline.com/Support/ServiceRequests.aspx)

Stop creating thumbs.db in Windows Vista/7

1) run "gpedit.msc" 2) go to "User Configuration", "Administrative Templates", "Windows Components", "Windows Explorer" 3) enable "Turn off the caching of thumbnails in hidden thumbs.db files" You can also try a different aproach: Open the Registry Editor (regedit.exe). Navigate to HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\Advanced. Double-click the DisableThumbnailCache value, or go to Edit > New > DWORD value to create a new value by that name. Enter 1 for its value. Click Ok and close the Registry Editor when you're done; you'll have to log off and then log back on for this to take effect. Note: don't confuse with folder options "always show icons, never thumbnails", which disables showing thumbnails on windows explorer views (you will have to open the images to be able to see what they look like)

SharePoint 2010 | Hidding the ribbon VS a SPSecurityTrimmed story

I've been struggling with the SPSecurityTrimmedControl, when using it to wrap controls so they only get seen by anonymous/logged in users. Turns out the control doesn't work right so neither using PermissionString or AuthenticationRestrictions will get the job done. Possible values for PermissionString ( http://msdn.microsoft.com/EN-US/library/ms412690 ): EmptyMask ViewListItems AddListItems EditListItems DeleteListItems ApproveItems OpenItems ViewVersions DeleteVersions CancelCheckout ManagePersonalViews ManageLists ViewFormPages Open ViewPages AddAndCustomizePages ApplyThemeAndBorder ApplyStyleSheets ViewUsageData CreateSSCSite ManageSubwebs CreateGroups ManagePermissions BrowseDirectories BrowseUserInfo AddDelPrivateWebParts UpdatePersonalWebParts ManageWeb UseClientIntegration UseRemoteAPIs ManageAlerts CreateAlerts EditMyUserInfo EnumeratePermissions FullMask Possible values for AuthenticationRestrictions: AuthenticatedUsersOnly ...

Windows 7 | Error Code 5 - cannot boot from disk

Image
Problem: Booting from a Windows 7 DVD in a machine that most likely is using an ASRock/MSI Motherboard, throws "Cannot boot from disk: Error code 5" Reason: Some motherboards are not compatible with Microsoft's boot sector used in Windows 7 install disc Solution: There are two ways of overcoming this: - Boot up from a Vista DVD, bypass language selection, chose repair, and open a command line, then switch to W7 DVD and enter "setup" - Record a new W7 DVD with specific Motherboard http://www.unawave.de/windows-7-tipps/code5-error.html?lang=EN

Troubleshooting problematic PSU/MOBO

Image
Hardware issues can be a derived from a simple hard drive replacement to a more complex issue. Usually, Power Supply Units are though to either work/not work by checking if the computer boots up or not. Mother boards are usually replaced, when the issue could be as simple as replacing the 3V battery. So here are some areas to troubleshoot. A multimeter will surely come in handy. let's disconnect all cables and start. 1) put the multimeter in AC mode and test the power outlet for voltage. expected is a non constant value of 220-230V(EU) or 115V-120V(US). 2) retrieve and check the small CR2032 baterry on the mother board for voltage. A value from 2.90V to 3.10V is expected. Anything lower than that will start to create BIOS and POST issues. 3) to do a basic power supply unit test: if it's a AT PSU (old P8/P9 connectors), just connect the power cable and see if it turns on. if it's a ATX PSU (P1 connector) we can set direct link on it, otherwise it will only turn on when con...

SQL Server | Windows 7

Issue: Getting this issue when picking databases over Management Studio from SQL Server: "The database XXX is not accessible. XXX.Express.ObjectExplorer" Solution: Open Microsoft SQL Server Management Studio with right-click, as admin