Tutorials and Tips

[Beacon]

I'm hoping people will add to this and that the thread will stay at the top as John said.

Here for all to see is my tutorial on storing Images in an Access Database. Last time i'm posting it.

Also here's the link to the latest VB Service Pack it's big so only get it if really needed and you have a good connection.

SP5

Also i've started an FAQ with links to posts for answers.
PM me to have an FAQ included or answered.

Ciao
Beacon

DATABASE - Quick Tips\FAQ

General

Q) How can i show a progress bar when retrieving records from a database?
A) This is using an ADODB Recordset(RS) and a progress bar(pb1).

Dim intRecCount As Long
    Dim intCounter As Long
 
RS.MoveLast
intRecCount = RS.RecordCount
pb1.Max = intRecCount
RS.MoveFirst
 
For intCounter = 1 To intRecCount
'add stuff to fill any other controls like list views, boxes or grids   
    pb1.Value = intCounter
 
RS.MoveNext
 
Next intCounter

Q) Where can i learn ADO?
A) Either Here Or www.vb-world.com

VB & Access

Q) Why does the size of my Access Database increase even when i'm deleting records?
A) Click Here


edit: The attachment below is now also available as a thread in the FAQ, here.