473,573 Members | 2,932 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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

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
2 4941
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
4863
by: Randell D. | last post by:
Folks, I am working on a contact db using PHP and MySQL. My results so far outputs a slimed down version of records to the browser. I would like to implement a method whereby the user can click on a text link which will then show the full record. I don't want to have hyperlinks with values incorporated in the link (thus, I don't want to...
4
34933
by: ry66 | last post by:
Hello All! Is it possible to submit a form using hyperlink? I want to send hidden element when a link is clicked. I read some books, but I found only using button which I don't want to use. Thanks in advance.
0
4181
by: Mike Knight | last post by:
(I've also posted this problem on microsoft.public.excel.programming) I have a MS Access 2003 Database named "AS400 Fields.mdb". This database contains links to tables on an AS400. In MS Excel 2003, I have VBA code that creates and executes queries using the Access database, and returns the results to an Excel sheet. The first time the...
6
3156
by: Thelma Lubkin | last post by:
I am trying to modify an Access form that allows a user to specify the information s/he needs from a census-type database. The form's code builds a SQL statement from the user's request, and creates from this a record set that is used to populate a new Excel workbook. The form's code opens the new workbook and writes both a datasheet and a...
7
7053
by: ddecoste | last post by:
I have a need to add a visual representation to some data in Access. I need to draw a matix of squares inside another square. I have all the data that I need in a record in Access. The data changes according to what the user inputs. I know that Access does not allow you to draw on forms so I decided to put the output in an Excel file for...
7
5754
by: semijoyful | last post by:
OS: Win XP SP2 Access version: 2003 Excel version: 2003 I am new at this, as I am sure you have gathered from this post title:) I am working on a form where users can input data in Access and at the end of the day be able to press a button on the form that would update that data to a single exel spreadsheet. The following is the code for...
1
6187
MitchR
by: MitchR | last post by:
Good Morning Folks; I have a question that is pretty far fetched but here goes nothing... I am looking to find a way to insert a macro into an Excel command button located in an Access VBA generated Excel spreadsheet from an Access Module. I can create the spreadsheet, button, and I have the macro to insert into command button. But I am not...
2
3881
by: eko99312 | last post by:
Dear All, As you know that input data on excel is easy than access, you can simple click the date that you prefer and input the value that you want. For example : Consider that the month that I use is November 2009 : If i use excel it will look like this, Country Day in a month 1 2 3 4 5 Australia ...
0
1181
by: neerja khattar | last post by:
Access form having filtering criteria.It generates a query so I want that query to show the output in excel report. How Should I show access form result on excel report
0
7781
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7699
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
8027
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
8202
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
0
8066
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
1
5594
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
3733
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
1
2216
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
0
1041
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.