Thursday, June 24, 2010

Make a graphical instruction notice to your sharepoint library or list

Scenario: The ordinary document library description does not offer any graphical customization. As a result, it is often overlooked by most users.



Solution: Add some html code with a simple border


Step by step:

  1. Open the document library (or list) and pick Site actions –> Edit page
  2. Click Add Web Part
  3. Add the Content Editor Web Part
  4. Click the Open the tool pane
  5. Open the Source Editor
  6. Paste the following html code:

<TR> <TD><b>Instructions</b></TD> </TR>
<TR> <TD>Choose suitable template under the New menu</TD> </TR>   

  1. Customize the html to fit your needs.

Thursday, June 10, 2010

MS Access – Import Word table with line break

Scenario: You want to import an Word table to Access without loosing line break within the table.

MS Access - How to keep line break when importing from Excel

Scenario: You have an Excel sheet with one column containing text that also has line breaks with the cell, for example bullet lists. You want to import this table to Access and keep the line breaks untouched.


  • Copy and paste the data into Access (or use the import wizard)
  • Make sure that the current column is of type Text or Memo/PM and also check that the field property Unicode Comporession is set to No and the property Text Format is set to Plain Text.
  • Create an update query, where you set the field Update to to Replace([ColumnName];Chr(10);Chr(13) & Chr(10))
  • Run the query

Wednesday, June 9, 2010

Paste Word table to excel with line breaks

Scenario: You have a table in Word that you want to paste to Excel. However the Word table contains line or paragraph breaks, for example bullet lists within the cells. These cause the Word table rows to be slit over several rows in Excel.


  • Paste the Word table into a new Word document
  • Open “Search and replace”, search for ^p and replace with ;
  • The new lines will now replaced with a ; sign.
  • Copy the table and Paste into Excel
  • Open “Search and replace” in Excel, search for ; and replace with *Hold down Alt key and press 010” (ASCII for new line).
  • Done!

I did have som trouble with the search and replace in Exel. It did not insert a new, it inserted like three new lines for each ; . Changing to a different computer did help, so really don’t know what the problem was.

Tuesday, June 1, 2010

Installing and using Jolicloud OS on NC10

Scnario: You want to dual boot a Samsung NC10 running Windows 7 with Jolicloud OS.

1. Download the Jolicloud installer (.exe)

2. Run it and follow the instructions. I chose to install om the same Partition that were Systemdisk for Windows 7 (C:\).

3. Everything went fine, but were not able to register with Jolicloud using Facebook (got ‘Server is Down’, reported it several times and waited for weeks without any change)

4. Created a ordnary account (without using facebook), went well.

5. Used the Jolicloud ‘app store’ to install my favorite apps, such as Spotify, Dropbox, Chrome etc.

6. For those applications that I use but weren’t available on the app store (Pwd Safe, Jungledisk, I used Wine to run them on the Linux Ubuntu system. For a simple guide for how to use Wine, see