In Access 03, i was using this code to compact my data.
' CommandBars("Menu Bar"). _
' Controls("Tools"). _
' Controls("Database utilities"). _
' Controls("Compact and repair database..."). _
' accDoDefaultAction
but it failed in access 07, how can i compact my data in access...
I have a report in continuous format, how do i add a label control to run a running number in each record? example:1,2,3,4,5,6,7,8,9,10... any one can help? thanks.