I have an Access application that opens a word document, searches for text and gets the next paragraph and inserts it to an Access field.
I need to be able to do this with Dialog box but the box hides behind the access forms, doesn't show the document and locks up the access application.
I...
HI,
I got a solution.
Seems the forms lock the tables and links when the form opens.
With yourWordAppObject.Dialogs(wdDialogEditFind)
I created a copy of my subform and called it subformDummy
Thene I
Me.Subform.SourceObject = "SubformDummy"
before I reset the links
and after setting new...
I thought I coul use the dialog box feature to use the "Find Next" button of the dialoge box.
With each hit I could display the paragraph following the hit and if the paragraph was not the text I wanted to save (to my access DB table) I could "find Next" for the next occurance of the search...
NOt sure how that would work.
The code is running in VBA from an access form and is activated when i click a button.
MAybe some explanation.
I have text in a field in an access form
I highlight the text I want to find in a word document on my pc.
THe vba code then opens the word document and...
Best I can find is that MSChart.ocx is a Visual Basic 6 control
http://support.microsoft.com/?kbid=194784&sd=msdn
Replacing MSCOMCT2.OCX:
I found the d=following at:
http://www.ascentive.com/support/new/support_dll.phtml?dllname=MSCOMCT2.OCX
SOLUTION:
In order to fix this problem...
In access I open a word document to find text.
Then I use the dialogs box
With Dialogs(wdDialogEditFind)
.Find = strText
.Show
End With
The box hides behind the open form and locks up the application.
How can I open it on top of the active forms?
After resetting the liknks I do the following:
CurrentDb.Relations.Refresh
CurrentDb.TableDefs.Refresh
DoEvents
Me.Refresh
Me.Requery
Me.SummarySubform.Form.Requery
Nothing changes the old data shows even with the new links
Don
Help.
I open a form and from a combo box select a vendor table.
Once selected I unlink the vendor table and link to the selected vendor table.
Then I open a subform and query the file to display the fields.
When I go back to the first form and select another vendor. The program (DoCmd) unlinks...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.