Thursday, March 25, 2010

Access 2010 and Web Databases on Sharepoint 2010

It's an issue that to play with Sharepoint 2010, we need a 64bit Quad Core machine with minimum 4Gb of RAM. Sure, current technology and costs are low enough that this will not be an issue for a production server, but for a play/developer machine we just want to use any old thing near us.

In a rapidly evolving featureset though, the people at Microsoft are mapping Access functionality to Sharepoint data and Sharepoint workflows. A lot of current Office gurus who are not Sharepoint will groan and say "Who asked them for this?" but this is for me a great idea - Access is a great desktop tool and not a bad LAN networked tool. But to bring some of the familiarity of Access to Sharepoint is a win-win for both Access and Sharepoint camps.

Time will Tell.

in reference to: iGoogle (view on Google Sidewiki)

Wednesday, March 24, 2010

Rich HTML content in Microsoft Access Memo fields

I remember years ago, I took a Microsoft VB6 sample and constructed an Access 97 version of HTML Text email using the Web Browser control. I just had a look at it here:

http://members.optushome.com.au/anandasim/asDHTMLEd/index.htm

By Gee, that was 2000, it's now 2010 - 10 years ago!

Anyway, Stephan Lebans added more zest to the project and in his HTML editor webpage, he has an example/demo file that pops up a form where you can edit rich text and most importantly embed a graphic.

The new Access 2007 and 2010 Rich Text formatted memo fields and Text Control can't embed a graphic. Or I haven't figured out how.

My next issue is how to use that content and send it via SMTP - you see, if you embed a local file reference with file:///, that won't go - you need to turn it to a cid reference, then send the graphic as well.....

in reference to: HTMLEditor (view on Google Sidewiki)

Wednesday, March 17, 2010

Access Archon's Archives

Helen Feddema's been steadily amassing a whole bunch of samples for VBA coding in Access over the years. She writes for WAW and for herself.

in reference to: http://www.helenfeddema.com/access.htm (view on Google Sidewiki)

One of several public Australian datasets

I've often wanted datasets for Excel and Access demoes and tutorials. Australian Govt agencies have put them online. There are Public Internet Locations and Toilets - gotta woke on that xml import to Excel though - it's constipated.

in reference to: http://data.australia.gov.au/414 (view on Google Sidewiki)

Microsoft Project 2010 Videos

Finally Project embraces the Office Fuent UI and the Excel team's given them bonus UI behaviours in the grid.

in reference to: http://www.microsoft.com/global/project/2010/en/us/RichMedia/secondary/video_showcase.html (view on Google Sidewiki)

Saturday, March 6, 2010

Office 2010 Upgrade for free

Purchase a qualifying Office 2007 product (with or without a new PC) from an authorized reseller between March 5, 2010 and September 30, 2010. See the eligibility requirements for more information.

in reference to: http://office2010.microsoft.com/en-us/tech-guarantee/ (view on Google Sidewiki)