I am looking to set up a hyperlink control on a form to retrieve letters
that correspond to a record on a form. That is, there may be 100 form
records, and I would like each of those form records to have a hyperlink
button or control on it. that when pushed, pulls up the unique Word document
associated with that form record. In this example, there would 100 unique
letters associated with 100 unique form records. I tried working with this,
but can not get the control to access UNIQUE letters. I am using Access
2000.
Thank you,
- Phil
3  4577 
"Phil" <p.*****@comcas t.net> wrote in message news:<cpYCc.110 491$HG.67523@at tbi_s53>... I am looking to set up a hyperlink control on a form to retrieve letters
that correspond to a record on a form. That is, there may be 100 form
records, and I would like each of those form records to have a hyperlink
button or control on it. that when pushed, pulls up the unique Word document
associated with that form record. In this example, there would 100 unique
letters associated with 100 unique form records. I tried working with this,
but can not get the control to access UNIQUE letters. I am using Access
2000.
Thank you,
- Phil
So you have a field in your table that holds the path to the letter.
Then you just format that field in your form as a hyperlink. What do
you mean "unique" letters? You're getting the same one? Sounds like
you're putting a label or unbound field on your form instead of a
bound field.
Thank you. I am quite new at this, but after adding a column in a table for
the URLs, it worked OK. I thought I could just put something like "View
Letter" on the form, and make that a pointer directly to a document I have
in Word. It appears I must have a list of URLs in an Access table.
If there were 100 records, I would go through 100 occurrences of each form
when it displays each record. What I wanted was that when you clicked on
"View Letter", it would pull up the correct letter for that record. This
means a unique URL or file location for each Access record. It is slow to
enter the URLs in the table, but this is the only way I know how to make
this work.
- Phil
"Pieter Linden" <pi********@hot mail.com> wrote in message
news:bf******** *************** ***@posting.goo gle.com... "Phil" <p.*****@comcas t.net> wrote in message
news:<cpYCc.110 491$HG.67523@at tbi_s53>... I am looking to set up a hyperlink control on a form to retrieve letters
that correspond to a record on a form. That is, there may be 100 form
records, and I would like each of those form records to have a hyperlink
button or control on it. that when pushed, pulls up the unique Word
document associated with that form record. In this example, there would 100
unique letters associated with 100 unique form records. I tried working with
this, but can not get the control to access UNIQUE letters. I am using Access
2000.
Thank you,
- Phil
So you have a field in your table that holds the path to the letter.
Then you just format that field in your form as a hyperlink. What do
you mean "unique" letters? You're getting the same one? Sounds like
you're putting a label or unbound field on your form instead of a
bound field.
"Phil" <p.*****@comcas t.net> wrote in message news:<43jDc.113 757$eu.51359@at tbi_s02>... Thank you. I am quite new at this, but after adding a column in a table for
the URLs, it worked OK. I thought I could just put something like "View
Letter" on the form, and make that a pointer directly to a document I have
in Word. It appears I must have a list of URLs in an Access table.
If there were 100 records, I would go through 100 occurrences of each form
when it displays each record. What I wanted was that when you clicked on
"View Letter", it would pull up the correct letter for that record. This
means a unique URL or file location for each Access record. It is slow to
enter the URLs in the table, but this is the only way I know how to make
this work.
- Phil
One way to find the letters... Use the OpenFile API from http://www.mvps.org/access/api/api0001.htm
to prompt you to browse for/"open" the file, and then just grab the
path to the file, and store that in your database. If all the files
are in the same location it should be pretty easy. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Tony Clarke |
last post by:
Hi,
I'm trying to write a system thats used for about 50 clients that uses html
forms and php to log details. The problem is that when a client loads the
form page it's given a value which is the last record in a table +1 (i.e. so
its the next record). The problem with that is that a client could sit on
that page for 20 mins (or whatever length of time) and a different client
could use that record number and there what be an error...
|
by: schuderfloss |
last post by:
I have a unique ID field in a table of products. And rather than store
the full hyperlink/URL address I decided just to store the unique ID. I
would like to have a button in a form that contains a URL to a web
page, by appending the ID to a base URL.
So when I bring up the form it has created the button's underlying URL
link on the fly.
for example the base URL is www.blank.com/products/
I would like to append my unique ID to the end...
|
by: mstanley71 |
last post by:
Hi All,
I have a problem, I'm using Access 2002 SP3. and am trying to use a
button on each form to link back to a hyperlink on a table based on a
combo box selection on the same form record..ie SELECT NNI_DRAWING FROM
NNI1 WHERE NNI_CKT_ID=FORMS!PVC!NNI_USED;.
I'm able to do this using a combo box to show the hyperlink
(NNI_DRAWING). The problem is that this:
|
by: Bob Sanderson |
last post by:
I have a php page which contains the code:
echo "<tr>";
echo "<th>$JobNumber</th>";
echo "<td>$Description</td>";
echo "<td>$NSN</td>";
echo "<td>$Manufacturer</td>";
echo "<td>$PartNumber</td>";
echo "</tr>";
|
by: steve |
last post by:
Hi all,
Come across a situation I cannot figure how to work out. Im relatively
new to access but have looked around and tried everything to my
knowledge.
I've developed an application whereby users load up the database and
open a form, this form issues them with work to complete, the work is
completed and the next record is offered.
| | |
by: mnemosyne |
last post by:
hi i'm trying to figure out how to have a hypertext link in a form use the information entered from a separate field in order to link to a word document
EXAMPLE
Link to Report is a hyperlink that gets the Medical Record # from another field and uses that to link to ".doc" so that when a patient's Medical Record # is entered as 0001, the hyperlink will open "0001.doc" and so forth
will i have to use code builder to DoCmd a copy object?
or...
|
by: mforema |
last post by:
Hey Everybody, I have an URGENT REQUEST (I need a reply within 24 hours, or I lose my job) I need help writing vba code for a command button. I want this button to locate a hyperlink in a table (the hyperlinks have their own field) based on the record's name (the first field in the table). If the there is a hyperlink for the record, then I want it to be opened. If there is no hyperlink for the record, then I want a message box that states so....
|
by: LAD |
last post by:
Using Access 2003 on Windows 2000.
My Skill Level: Med Low (Some VBA, okay with Access)
Form: Single View - based on Query of single Table to sort by field.
Application: Dealers email 'contract packages' that include as attachments: a contract (PDF or TIF), a pricing tool (Excel), a companion document (Word). Clerks detach these files into a shared drive file on our intranet.
I'm building an 'contract package management' application...
|
by: KevinADC |
last post by:
Note: You may skip to the end of the article if all you want is the perl code.
Introduction
Many websites have a form or a link you can use to download a file. You click a form button or click on a link and after a moment or two a file download dialog box pops-up in your web browser and prompts you for some instructions, such as “open” or “save“. I’m going to show you how to do that using a perl script.
What You Need
Any recent...
|
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 synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
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 captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| | |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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 instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
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 the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
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
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
