Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Compact on Open Add In

Status
Not open for further replies.
CarrieR

CarrieR

Technical User
Nov 9, 2001
60
US
I have downloaded the Compact on Open or Close add-in available from the net. Is it possible to have this run by a macro? I am using Access 97, can't find any information on how to do this. I am not very VB literate, can handle simple code...
 
Sort by date Sort by votes
Got it to work by creating a command button which on it's on click event put in the following: Call Application.Run("Compacter.DoCompact", True). Works great. This is a very easy way to do this on Access 97 compared to the other methods I have seen. The compactor.zip file was available on
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

ameedoo3000
  • Locked
  • Question
switch between two open database
Replies
12
Views
1K
Andrzejek
Andrzejek
BallunarCrew
  • Question
ODBC Driver Struggles on new computers
Replies
2
Views
378
BallunarCrew
BallunarCrew
renigar
  • Locked
  • Question
Access 365: Search LastName in one table to put EmployeeID in another
Replies
8
Views
950
renigar
renigar
lameid
  • Locked
  • Question
Execution Slowing on iterative generation of PDF's
Replies
3
Views
794
lameid
lameid
lmcate
  • Locked
  • Question
How to Open ACCESS (MDB) from an HTML Page 1
Replies
2
Views
4K
lmcate
lmcate

Part and Inventory Search

Sponsor

Back
Top