Re: Control Word userform from Access

Did you try the method that I suggested in my last post - using the
System.PrivateProfileString?

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

<x> wrote in message news:uPeo9Oa$FHA.160@xxxxxxxxxxxxxxxxxxxxxxx
> The userform is controlled by a document registration database that uses
> Word to supply custom templates of reports, letters, faxes etc for our
> organisation to use to eliminate holding hard copies of documents and for
> better racking of all correspondence through the organisation. The
> templates are used to standardise all these document types for conformity,
> as in the past each department did their own thing which didn't look
> professional. It also makes finding past documents relating to a subject
> easier to find than looking through a dusty document archive. All incoming
> correspondence is scanned as a TIFF image for recording and the original
> destroyed except for original forms and some other document types. These
> documents are then linked to any replys or reports to keep them all
> together electronically. As you can imagine this is a massive database. It
> can hold all Office document types except Access databases or linked Excel
> spreadsheets (unlinked are fine).
>
> I have created a workplace health and safety database that generates
> monthly reports in Access then pushes the data to Excel for analysis to
> create four charts (easier to control), then on to a custom Word template
> filling in four tables and pasting images of the four charts to report to
> nine department managers and nine safety committee members. This report
> then has to be registered in the document database and to do so requires
> up to six fields to be filled in before registration can take place. Once
> registered the reports are emailed to the recipients. The person running
> this safety database cannot use the document database very well therefore
> I'm trying to automate all that I can. In the past the safety database
> reporting was all done manually with hard copies and took a lot of time to
> do. This now takes less than a minute to run with automation except at the
> registration stage, which the user has trouble with.
>
> The registration is controlled from Word using the normal.dot template to
> create the custom toolbar that runs this process. This and the report,
> letter and fax etc templates are protected even at the module level so
> changing anything isn't an option as the datbase is supplied by a
> contracted third party who periodically updates the system and any
> suggestions we make have to be considered carefully and usually take
> forever to implement as other organisations also use the system for their
> document control.
>
> Well thanks for your suggestions and listening, if there isn't a way to
> automate the registration maybe the user will have to learn to use the
> system I guess.
>
> Regards
> Paul
>
> "Doug Robbins - Word MVP" <dkr@xxxxxxxxxxxxxxxxxx> wrote in message
> news:uOZJdwP$FHA.1408@xxxxxxxxxxxxxxxxxxxxxxx
>>I guess one way you could do it then would be to use the
>>System.PrivateProfileString to write the string to a .txt or .ini file
>>before you called the userform and then, in the Initialize() event for the
>>userform, you could use the System.PrivateProfileString once againt to
>>retrieve the string from the .txt or .ini file and insert it into the text
>>box.
>>
>> I guess I have to ask why you are using a userform in Word and not a form
>> in Access?
>>
>> --
>> Hope this helps.
>>
>> Please reply to the newsgroup unless you wish to avail yourself of my
>> services on a paid consulting basis.
>>
>> Doug Robbins - Word MVP
>>
>> <x> wrote in message news:e9IaJON$FHA.1028@xxxxxxxxxxxxxxxxxxxxxxx
>>> Thanks for the reply Doug.
>>>
>>> The code is run from an Access module so 'Dim oform As UserForm1'
>>> generates
>>> an error in Access and the code halts. I have the Word object library
>>> referenced.
>>> The word object is bound early with 'Dim objWord As Word.Application'
>>> which
>>> references a Word template to start a new report document (protected
>>> company
>>> template).
>>> Then I call the macro to open the form with objWord.Run "OpenForm" and
>>> try
>>> to access the userform with objWord.Userform1.Textbox1 =
>>> strDocumentName.
>>> The template is not editable so I cannnot change it, I just know the
>>> name of
>>> the macro, userform and textbox..
>>> I'm using the ClipBoard_SetData and ClipBoard_GetData functions from the
>>> article 'ACC2000: How to retrieve information from the clipboard', found
>>> on
>>> Microsoft's MSDN site to place the result of the variable on the
>>> clipboard
>>> and then try and send it to the textbox. Pressing Ctrl + 'V' will paste
>>> the
>>> data into the textbox but I want to make it happen automatically.
>>> What do you think?
>>>
>>> Thanks again.
>>> Paul
>>>
>>> "Doug Robbins - Word MVP" <dkr@xxxxxxxxxxxxxxxxxx> wrote in message
>>> news:e0hBiCM$FHA.272@xxxxxxxxxxxxxxxxxxxxxxx
>>>> Dim oform As UserForm1
>>>> Set oform = New UserForm1
>>>> oform.TextBox1.Text = "Your String"
>>>> oform.Show
>>>>
>>>>
>>>> --
>>>> Hope this helps.
>>>>
>>>> Please reply to the newsgroup unless you wish to avail yourself of my
>>>> services on a paid consulting basis.
>>>>
>>>> Doug Robbins - Word MVP
>>>>
>>>> <x> wrote in message news:uf5WZLK$FHA.2264@xxxxxxxxxxxxxxxxxxxxxxx
>>>>> Hi everyone
>>>>>
>>>>> I need help sending a text string to a texbox in a Word userform. I
>>>>> can call the Word macro to open the userform but I can't paste or send
>>>>> the result of a string into the textbox even though the cursor is
>>>>> flashing in the box. How do you access the objects in the userform
>>>>> assuming the userform name is Userform1 and the textbox is Textbox1?
>>>>> Can it be done?
>>>>>
>>>>> Thanks in advance
>>>>>
>>>>> Regards
>>>>> Paul
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>


.

Loading