August 2006
M T W T F S S
« Jul   Sep »
 123456
78910111213
14151617181920
21222324252627
28293031  

Archives

Archive for August, 2006

Pattens

( General )

some cool pattens:
http://bgmaker.ventdaval.com/
Good for back drops in dictor apps ;-)
And as pattern fills (in shapes) are getting binned from 07, there will be a use there as well!

Free VS2005 - [trial]

( General )

If you’ve been following xlDennis’ excellent set of post over at DDOE then you might be tempempted to try your hand at a .Net managed code addin. If you do, this might be of intrest to you:
http://www.microsoft.com/emea/msdn/visualstudio/enxu/getthetrials/
You can download it too if you scroll down the page:

List Box Resizing problems

( General )

Ran in to an old friend today, and it took me a while to remember what to do. After adding a list box to your user form, you’ll want to resize it so that it looks nice. At design time you can get all your controls lined up without too much effort. Like this:

However […]

In cell graphing

( General )

A few ideas have been floating about recently, each have there own pros and cons here a new one to me, looks good!
http://www.juiceanalytics.com/weblog/?p=239

Icons, Icons, Icons

( General )

Adding the finishing touches to a user form cab be fun, here are some cool Icons to help you out!
particularly noteworthy
http://www.yellowpipe.com/yis/download/free-icons.php?seenIEPage=1
and a really full list here:
http://www.maxpower.ca/free-icons/2006/03/05/
UPDATE, UPDATE, UPDATE:

there are some amazing works of icon art here too:
http://interfacelift.com/icons-win/index.php?sort=date

A better way with a Make Table Query?

( General )

The situation.  
Back end Access DB, front ended with an Excel Form. Add a new record to a table in the DB and run a Make Table Query to sort the whole table in to alphabetical order. Reload the table into a list box.
I need to make a new table because simply sorting the existing table does [...]

Securing VBA code in Office

Most of us know that .dll’s are the only real option if security is a genuine issue, but I think the following might be a possible (bodge) solutions for those who many not have VB, and need better security for their VBA code. Anyway, I was looking at this site:
Tech Net - Office 2000/Visual Basic [...]

The trouble with data…

( General )

Here's a new blog that should be good! It's from Uk base developer Will Riley, and Xl Dennis is helping out too. You might even find out some floor tips, so there you go!

http://www.wills-blog.com/
oh, and good luck Will!

Some links and content form real bloggers!

( General )

A few intresting items have appread in my bloglines tonight:
Firstly some Office Developer vedios are up on MSDN:
http://msdn.microsoft.com/office/ 
Second, tell me if you've ever been developing in this office:

I don't think she's gunna get much done.....
and lastly some VBA/VSTA info...now I've not even read this yet my self, but I'm going to just to find out [...]