Triggers in Microsoft Access 2010

So do we have a solution for Triggers in Access like we have in SQL Server, Oracle etc?. I think yes we do have but the branding and outfit is just a little bit different.

The above pic shows the options to write events just the way you write triggers allowing you to write an event/trigger before change, before delete, after insert, after update, after delete.

Now you can select an Event type to further work on and you can use a conditional statement to express your logic choosing the action from the right pane. This way you can use if else, looping blocks and can check the data on the particular stage and can filter, edit and undo the data based upon your requirement.

Microsoft Office 2010 Installation Error, Setup is unable to proceed

During recent times i came across this screen indicating that Microsoft Office 2010 setup is unable to proceed due to the following error(s):

Microsoft Office 2010 does not support upgrading from a prerelease version of Microsoft Office 2010. You must first uninstall any prerelease versions of Microsoft Office 2010 products and associated technologies.

Following can be a reason behnid this:-

1) You still have TP, Beta or RC of Office 2010. If you have any of them, remove it before you continue.

2) You might not have full installation of Office 2010 TP, Beta, RC but might have any component installed like Outlook Connector for Office 14 (2010) etc. So that needs to be removed as well. So left overs of any Pre-Release version should be present in your PC.

3) Something strange i came across, Visio is never been a part of Office, i was running Visio 2010 Beta alongwith Office 2007 when i tried installing Office 2010 RTM instead Office 2007 it came up with this same error message. And Yes! I had to remove Visio 2010 Beta in order to install Office 2010 RTM, isn’t it strange? as Visio and Project are not a part of MS Office but still their Beta, RC etc have to be removed inorder to install Office 2010.

Microsoft Office 2010 – Web Apps

Microsoft is hitting the web with new online edition of the office 2010 suite. Word, Excel, PowerPoint and OneNote will also be having web-based counterparts to edit, store and share documents online created using these tools. This makes Web Apps interesting and worth investigating.

So Office Web Apps will allow you to create, edit, store and share the documents online and will allow individual users to save their documents through Windows Live SkyDrive service (Microsoft’s free online service).

Before We can download and use Web Apps, we first need to install the office 2010 beta available for download from Microsoft website. Sharing documents with others through Web Apps requires to e-mail each person a link to your document. As we try Office Web Apps, we need to keep in mind that it’s beta.

Web Apps runs IE7, IE8; Firefox 3.5 or higer on Windows, Linux and the Mac.

Download Office 2010 beta:
http://www.microsoft.com/office/2010/en/download-office-professional-plus/default.aspx

Download Office 2010 Web Apps:
http://www.microsoft.com/downloads/details.aspx?FamilyID=27d81b1c-18ae-4983-8e1c-224bb747eb99&displaylang=en