473,326 Members | 2,108 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

How to open up and search through a Word document using Access VBA?

HI all, I'm in a dire need of help right now. I am not sure if it is even possible, but I need to create an application whereby the user enters a search keyword in an Access form, and the form will locate the Word document, which is stored in Sharepoint. The Word document will then open and be immediately directed to the page whereby the search term was found.

E.g. User searches for "ABC phone number" and the form will open ABC's Word document and immediately be at the phone number's page.

How do I go about doing this? Or at the very least, just open up the correct document from Sharepoint?
Oct 23 '14 #1
1 844
twinnyfo
3,653 Expert Mod 2GB
shawnntjr,

What have you tried so far? This is most likely possible. However, a lot of this will depend upon your expertise.

MS Word can be completely automated using VBA (via Access or any other MS Office application), but what you are asking to do can be very complex.

You are asking the DB (or user) to know while file to open, which begs the question, if the user knows which file to open, why could they not simply open the file and do a manual find of the text item?

Granted, I understand the desire for full automation--and I am on your side there--but sometimes the effort required to automate something so simple is not worth the benefit it provides.

Just a few thoughts. We are standing by to assist further if you show us how you have tried to tackle this problem yourself, as we typically don't offer the entire solution, but assist in troubleshooting non-functioning code.
Oct 23 '14 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: Andy Davis | last post by:
How do i or can I open a word document directly from Access? I would like to be able for the user to click a button on my form to open a word document and then also run a macro in Word. Thanks...
8
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...
3
by: ram | last post by:
how do I open a word document within a webform? I need to open the document within the form so the user can edit the document and then click on a button on the form (so that the document is...
8
by: Tim Murphy | last post by:
How do you read/write a Word document embedded in an OLE Object field in an Access table with VB.NET? I have an Access application where users are creating and editing Word documents that are...
1
by: icthus123 | last post by:
I'm trying to open a word document from access and enter some data from my access form into the document. I've used this code: Dim objWord As Object Dim objDocument As Word.Document ...
1
by: vin4tony | last post by:
Anyone plz help to open a word document using asp.net.I used a code ..but it shown access denied...Can anyone help me.. my error is Access is denied. Description: An unhandled exception occurred...
1
by: beemomo | last post by:
Hi everyone and anyone, i have a form in Access named "Invoice" which store information for each particular invoice. After filling in the particular detail of an invoice, I want to click on a button...
3
by: Bobby | last post by:
Hi, I am using Office 2007. I need to be able to open a Word document from Access and insert a customer name and address depending on the record selected. I guess I could do it using Word...
1
by: deegeorge | last post by:
Hi, I want to export crystal report from ASP .Net in word format. I am able to export crystal report but it dosen't give be the Word toolbar as we can see in when Msword document is opened....
9
by: walid geagea | last post by:
Hello, I have written the following codes in order to open a word document from an Access 2007 form. The document was openned correctively but the problem is that I want to be able to go to a...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

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.