Kid's stuff !!

[camador]

I'm not familiarized with Access so I don't know too much things.

My problem is how can I implement a function, macro or what ever you think to compact & repair database when I close it.

And how to move to a new record after I print the actual record.

Hope you can help me, thanks

 

[Jack Cowley]

If you have Access2000 or above you can compact on close by selecting Tools > Options > General and checking Compact On Close checkbox. Access97 does not have this ability...

DoCmd.GoToRecord, , acNewRec

will do the trick in the code that you use to print the record.

hth,
Jack

 

[camador]

Thank's Jack, it solved my problem.