Hello,
I have a form (Access 2003) which brings up a clients details on screen (name, phone number, etc etc), so that an end-user can modify any of these clients details, and save the updates. Also however on this form is a button, that says "notes", which, in theory, when you click on it, opens up a word (word 2003) file with notes, pictures, text etc etc, all about that particular client
What I need help with is.......say the end-user has freddy jones' record up, open, on screen, and clicks on "notes". I need access to then open the "fredy jones.doc" file.......or it may be mary jones' record that is open, so thus access has to open "mary jones.doc". The (primary key) field in the form that contains the clients name is entitled "clientname ".I dont know to get access to look at the data / value in the "clientnme" field, and then say.....okay, yep, i want to open the corresponding word file, whose *.doc name is the same as the data/value in the "clientname " field
Thanking you in advance,
Jeff
1  3717 
Try here.
http://www.databasedev .co.uk/downloads.html
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: Paolo |
last post by:
Friends,
I have created a form with a list box that shows all my Word files.
I have then added the following code (found on comp.databases
newsgroup) to the Open event of my form and it works fine:
Private Sub Form_Open(Cancel As Integer)
Dim file As String
Dim files As String
files = ""
|
by: Ruby Tuesday |
last post by:
Hi, I was wondering if expert can give me some lite to convert my word table
into access database.
Note: within each cell of my word table(s), some has multi-line data in it.
In addition, there is one row containing picture(s) as well.
So far, what I did is doing it manually for each word docs I have.
Select Table
Convert Table to...
|
by: DaveS |
last post by:
Hi! I need help opening a Word document from within an Access 2000/XP
mdb. I'm using Shell to open the document, but the Access code
continues to run past the Shell statement.
What I need is the ability to stop the code from executing until the
Word doc is closed. Additionally, I need the ability for a new instance
of Word to be created...
|
by: Mike MacSween |
last post by:
tblCourses one to many to tblEvents.
A course may have an intro workshop (a type of event), a mid course
workshop, a final exam. Or any combination. Or something different in the
future.
At the moment the printed output is usually going to Word. It's turning into
an unholy mess, because I'm having to prepare umpteen different Word...
|
by: Asma |
last post by:
Dear Sir,
I am trying to find a way to open a Word document using C language and
read the text of word doc into a variable.
(Turbo C on Dos 6.0).
Can anyone please tell me which libraries in C can be used to perform
this task.
Thanks you so much
| | |
by: Jonathan Trevor |
last post by:
Hi,
For the last couple of releases of a product we're developing we've been
running to very wierd behavior from IE and our ASP.NET web application which
serves up various types of files and I'm getting very frustrated in trying
to solve it!
We content we are serving up is potentially sensitive and therefore we DO
NOT want it cached on...
|
by: Radu |
last post by:
Hi,
I have the following problem: I open a recordset based on excel/csv
files, but then I need to filter (in code) in order to extract only
data pertaining to a specific person. This code is slow....
I am thinking that there might be another way to do it... maybe faster.
Is there a way to filter it as I open it ?
I'm using the...
|
by: Ruben |
last post by:
Hello,
I am using the "Application.FollowHyperlink strFilePath, , True" line
of code from within access forms to launch any file type I want (e.g.,
xls, doc, pdf, etc.). The files open up okay, but open up in the
background. How do I make them open in front where they are visible?
I have tried various things like "Appliction.Visible=True...
|
by: hharry |
last post by:
Hello All,
Does anyone know of a method to automatically detect if a file is
corrupted ?
Due to a failed backup process a number of files were corrupted. The
files are mostly .xls, .doc, .pdf. When you try to open the file, a
dialog box opens stating that the file cannot be opened.
I need to log which files wont open properly, and I'm...
|
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...
|
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. ...
| | |
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...
|
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...
|
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...
|
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...
|
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...
|
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.
| |
