A nice tip for databases.

When you have to run a complicated SQL-statement, make a part of it as a predefined query. Then don't open the table but the base query with only the criteria. This goes much faster then putting the whole SQL-statement in your program.

ToolTip

I was reading the tip of larryn and I thought that it might be a good idea to present the best way of reading old or somebody else's code. Goto www.vbcity.com/page.asp?p=pcp_index Registration is free, so no reason for not using this util.

Las but not least,

Don't be affraid to try and ask everything. This board is made for questions. And when it doesn't work you've still gained knoledge. There are more roads leading to rome, I believe is the expression. And don't forget VB World itself. I see many questions that are answered in one of the articals of VB World. Especialy my personal favorite guru Karl Moore. He tought me a lot in a very short time with these articles.

I might have some tips later but I'm not a professional yet. In fact I only work with VB6 for about 6 moths, with a two months of programming expirience in VBA and I have a full time job as programmer now. So you see, there hope for all you amatuers (including myself).