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

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

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,144,567
Messages
5,725,028
Members
422,589
Latest member
JohnnyBravo1

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