Monday, October 27, 2014

Right-Click on TreeView

I created last time a "My Favorite" popup menu for my ERP app.  This allows my users to easily jump from one module to another without the need to close what they are working on.  The hotkey is F5.   Each of my users have their own My Favorite as well so they can control themselves what they wanted to be there (those modules they have access to).



I used Ctrl+F to add or remove items on the Favorite Menu utilizing the Selected/Highlighted node from the ActiveX TreeView Control (MSComctlLib.TreeCtrl.2) as when I look for a right-click event back then, I cannot find one.  And I do not want to waste my time on finding that missing Right-Click event as all I wanted is a quick fix for my need.

Friday, October 24, 2014

Easy ways to Capture images

I have not blogged for a long time and you guys know why.  Anyway, here is something that may be useful to you so I am making this entry here.  This is about FoxForm shared to us in Foxite Forum.  This combined with other things will allow us to easily capture our form, our app's screen and the desktop itself; with only few lines of codes.  In addition, you can send those captured images as well direct to printer.  Here are the steps:


Friday, September 12, 2014

For you Kuya Obet and for OFWs!

Some of my friends know that my eldest brother recently passed away at a very young age of 46.  We were devastated as it is totally unexpected. During those times I repeatedly thought of creating an entry here because I wanted to immortalize my Brother's memories.  I have done that for other people, so why should I not do it for my departed Brother (Kuya Obet)?

The problem I have is how can I put into words my brother's story without boring readers.  Why am I so concerned about it?  Well any writer's goal is to make the topic interesting that the readers will take time to read the entirety.  Otherwise my goal of introducing my late brother to the world will fail.  Anyway, I will try my best and I hope I will do good here.  The stories come from my memories and from Kuya Obet's own accounts (his life in Papua New Guinea) mentioned to me over bottles of beers in 2006.

My earliest memories

We grew up from a very tightly knitted family which is common to most Filipinos especially the poor ones because that is our only wealth, i.e., strong love and affection for each other.  We were born poor that in most days our meal consists mostly of rice+saluyot, on good days rice+carabao's milk + salt (my favorite) and on worse days rice + plain water + sugar. But while we lack a lot of things, we were very happy growing; abundant with love for each other that we don't care much about those.  We were physically fit and being children do not complain much.

Monday, May 19, 2014

Word Automation - Create Table, Merge Cells

I was pondering a question inside foxite forum about word automation because of the handicap presented by MS that when recording a macro in Word, objects cannot be clicked using mouse.

So the first solution that I can think of is to use keyboard as that is still allowed and that to customize Quick Access Toolbar to include an icon for merging so I can click (and merge cells) for later reviewing of macro recordings.  And this resulted to these codes:

Wednesday, May 14, 2014

3rd party apps within our forms - Detaching


Yesterday, I gave you the ways to place a 3rd party app inside our form.  Today though I thought "What if my users want to work on those excel file outside on its own after I have shown those inside my form?".  And so I decided to find a way to detach those back outside.

Tuesday, May 13, 2014

3rd party apps from within our forms


It is now 1:30am and I still can't sleep again so let us make my time a bit useful.

Inspired by what Bernard Bout has shown here, I decided to see earlier today how it can be done on an excel instance.  Please read it (click on here word above) before proceeding below as I will try to break things apart for our better understanding.

The barest tools of the Trade

Monday, May 5, 2014

More Objects in a Grid Cell - Part III

I shared last time a way to show several objects within a grid's cell and I was surprised that it landed 2nd on my top posts.  Said tutorial and sample uses 4 containers, if I can recall properly, and usage of DynamicCurrentControl.  I did that when I was still in the process of experimenting on my assets masterfile module of which I use a grid with 3 columns with each columns showing different info: