By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,426 Members | 3,338 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,426 IT Pros & Developers. It's quick & easy.

Access Form --> Hyperlink to Excel --> Return to Original Access Form ?

P: n/a
I have an Access 2000 form that has a Hyperlink that opens an Excel
2000 worksheet located in the same network folder as the Access MDB.

The Hyperlink works great.

When users close the Excel File, they must choose the correct open
Access form on the Windows Desktop Taskbar to return to the Access form
that had the Hyperlink.

Is there a way to:

1. Open the Access Form
2. Launch the Hyperlink to the Excel Workbook
3. Exit Excel, then
4. Return to the original Access form automatically - without clicking
anything (such as the the TaskBar)

I just need help with #4.

Or, is there a better way to do this?

Thanks
John

Jul 19 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
John wrote:
I have an Access 2000 form that has a Hyperlink that opens an Excel
2000 worksheet located in the same network folder as the Access MDB.

The Hyperlink works great.

When users close the Excel File, they must choose the correct open
Access form on the Windows Desktop Taskbar to return to the Access form
that had the Hyperlink.

Is there a way to:

1. Open the Access Form
2. Launch the Hyperlink to the Excel Workbook
3. Exit Excel, then
4. Return to the original Access form automatically - without clicking
anything (such as the the TaskBar)

I just need help with #4.

Or, is there a better way to do this?

Thanks
John
See if the code at http://www.mvps.org/access/api/api0018.htm works better.

Jul 19 '06 #2

P: n/a
Thanks for the response.
I will examine the code.

John

salad wrote:
John wrote:
I have an Access 2000 form that has a Hyperlink that opens an Excel
2000 worksheet located in the same network folder as the Access MDB.

The Hyperlink works great.

When users close the Excel File, they must choose the correct open
Access form on the Windows Desktop Taskbar to return to the Access form
that had the Hyperlink.

Is there a way to:

1. Open the Access Form
2. Launch the Hyperlink to the Excel Workbook
3. Exit Excel, then
4. Return to the original Access form automatically - without clicking
anything (such as the the TaskBar)

I just need help with #4.

Or, is there a better way to do this?

Thanks
John
See if the code at http://www.mvps.org/access/api/api0018.htm works better.
Jul 20 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.