Substitute for Switchboard OnActivate event in A'07 ?

pooratlas

Board Regular
Joined
Apr 17, 2007
Messages
166
When revising a linked table in the '03 database window and then returning to frmSwitchboard, an OnActivate event would occur.
Now, in 2007, leaving the frmSwitchboard to revise a linked table in 'Navigation Pane' and returning to frmSwitchboard does not trigger the OnActivate or GotFocus event.

The event is necessary for running a sequence of delete & append in order to display a summary of the current linked xl.

Short of manually closing & reopening the frmSwitchboard or a 'refresh this form' button, any ideas for initiating VBA code in Access '07, while still maintaining a manual link manager process?
 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

HiTechCoach

Well-known Member
Joined
Aug 29, 2010
Messages
1,008
I would use a form to for ALL table edits.

I would also use a command button to first the code, not the on activate event of the form. .
 

pooratlas

Board Regular
Joined
Apr 17, 2007
Messages
166
possibly I was not clear-

I need to refresh a summary subform view of a linked xl.
I need an event to initiate code.
 

HiTechCoach

Well-known Member
Joined
Aug 29, 2010
Messages
1,008
Still not real clear what you are doing from your brief description.

Why not use a command button?
 

Forum statistics

Threads
1,148,145
Messages
5,745,049
Members
423,917
Latest member
Frank1931

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top