News, links, downloads, tips and tricks on Microsoft Access and related

About Me Search
Name:Alex Dybenko

Location:Moscow, Russia

Tuesday, June 29, 2010

Terminal server Install mode

If you install any application or library on terminal server – it is necessary to switch server to install mode, else your application or library could work only for one user, who installed it. In my case it was a setup executable with ActiveX controls and libraries for Access application. First I forgot about Install mode, and other user had strange errors running acitvex controls, even saying “you do not have license to run this control”. This blog post explains why it is important.


Friday, June 18, 2010

Paging using Jet SQL

This trick I learned from A.D. Tejpal, Access MVP. Following SQL statement returns records 11 to 30  from Products table:

FROM Products AS T LEFT JOIN [SELECT TOP 10 Products.*
FROM Products ORDER BY ProductName]. AS Q ON T.ProductID = Q.ProductID
WHERE Q.ProductID Is Null
ORDER BY T.ProductName;

Labels: ,

Thursday, June 17, 2010

Community Forums NNTP Bridge

If you missed Microsoft Newsgroups or Discussion groups – here some kind of replacement. Community Forums NNTP Bridge helps to use your old good newsreader to read and post to Microsoft Answers and TechNet forums. And this instruction helps to put everything together.


Wednesday, June 16, 2010

Another way to run Access inside web browser

EQL Access OnWeb – completely different then what Access 2010 together with SharePoint offers. It looks like Access app is running on terminal server or something like this, so you don’t need to do any modifications to your application.


Saturday, June 05, 2010

New Free Ribbon and Access 2010 Navigation Form Tools

from Anthony D'Ambra

1. Access2007 Ribbon Builder and Editor for Microsoft© Access 2007 BETA builds and maintains Access 2007 and Access 2010 Custom Ribbons. It is a simple yet sophisticated tool for building custom ribbonbars using XML files. The ribbon being built is displayed as the active RibbonBar. You use the treeview representation of the ribbon to navigate and build the ribbon by adding, editing, copying, pasting, and deleting controls.

2. Easily Migrate Legacy Access Switchboards to the Access 2010 Navigation Form. In Access 2010 the venerable Native Switchboard Manager has been retired. The old Switchboard form has been replaced by a cool web 2.0 style Navigation Form using a tabs paradigm of up to two levels. The Navigation Form Control and Button controls cannot be created in code, so there is a degree of hard-coding involved. I saw the opportunity to ease the design process by adapting the legacy Switchboard Items table and porting it to the new Navigation Form. I have created a demonstration Access 2010, which can be downloaded from the url below. The code can be used freely in your applications 'as is'. All the required code is behind the custom Navigation Form, which is pre-built with a generic two-level tabs control: 8 level one options and each option having 8 buttons, which are populated at run-time from the Switchboard Items table, using custom code adapted from the Access 2003 vba module behind the native Switchboard form.

3. The Access Switchboard to Ribbon Converter Wizard in just two mouse-clicks turns your legacy Access Switchboard (as built by the native Access Switchboard Manager) into a fully functional Ribbon Switchboard.

Labels: ,

Friday, June 04, 2010

How to delete embedded object

You can insert document object into OLE field, open, and here how to delete it:

Me.oleDoc.Action = acOLEDelete
Me.oleDoc.SourceDoc = ""
Me.oleDoc.Action = acOLECreateEmbed

Got it from this discussion.