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:

Friday, May 2, 2014

Health Benefits - Super Fruits - Part I

One constant problem that I have is hypertension.  Originally I was given 5mg amlodipine (I won't name the brand) and I constantly argued with my sister who is a head nurse and my mother.. and oh plus my wife... that it does nothing to improve my condition. But one time in December last year I got really sick when I recorded an all time score of 199/113.   Yippee!!!!  Well I sometimes get a higher Diastolic such as 130 but that is the first time my Systolic reached 199 (see http://en.wikipedia.org/wiki/Blood_pressure).  Only one worm less waiting for a pen?

Anyway, that forced me to experiment increasing my intake from that 5mg to the whole 10mg on that day.  And immediately I felt better (plus 1 hour exercise over my stationary bike to sweat out whatever it is that needs to be sweat out).  Although I do not recommend that you guys do an exercise when having an HBP.  Majority cautions against it.

Improper Dosage