|
|
Hi All, I used to do this but it was too long ago to remember and things
have changed drstically since then.
Would someone please tell me the following,
I have a form template in Word for which we have to fill out the address of
up to 7 thousand properties a year. I would like to have the address and
other associated info placed into this form by accessing the Access
database. I assume VBA is the correct method but I need to know where to
look to find the codes. I also need to make other smaller databases for drop
down lists of 40 or so items as Word only allows 25 items in a list. Any
help or even sending me off in the right direction (ie:which is the best
book to read) would be most appreciated.Thanks very much in Advance.
-Bramston
|
|
See the following page of fellow MVP Greg Maxey's website:
http://gregmaxey.mvps.org/Populate_UserForm_ListBox.htm
--
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
"Bramston" <bramston[ at ]rogers.com> wrote in message
news:64B9208F-26F7-4AE9-9F99-1666C8A623BC[ at ]microsoft.com...
[Quoted Text] > Hi All, I used to do this but it was too long ago to remember and things
> have changed drstically since then.
>
> Would someone please tell me the following,
>
> I have a form template in Word for which we have to fill out the address
> of up to 7 thousand properties a year. I would like to have the address
> and other associated info placed into this form by accessing the Access
> database. I assume VBA is the correct method but I need to know where to
> look to find the codes. I also need to make other smaller databases for
> drop down lists of 40 or so items as Word only allows 25 items in a list.
> Any help or even sending me off in the right direction (ie:which is the
> best book to read) would be most appreciated.Thanks very much in Advance.
> -Bramston
|
|
"Bramston" <bramston[ at ]rogers.com> wrote in message
news:64B9208F-26F7-4AE9-9F99-1666C8A623BC[ at ]microsoft.com...
[Quoted Text] > Hi All, I used to do this but it was too long ago to remember and things
> have changed drstically since then.
>
> Would someone please tell me the following,
>
> I have a form template in Word for which we have to fill out the address
> of up to 7 thousand properties a year. I would like to have the address
> and other associated info placed into this form by accessing the Access
> database. I assume VBA is the correct method but I need to know where to
> look to find the codes. I also need to make other smaller databases for
> drop down lists of 40 or so items as Word only allows 25 items in a list.
> Any help or even sending me off in the right direction (ie:which is the
> best book to read) would be most appreciated.Thanks very much in Advance.
> -Bramston
More specifically, If I type in the address onto the Word doc form I need
the rest of the form filled out with the current owners name, address, etc.
All that info is in an access database which gets updated my another
department as required or I can update the access database from info I have
collected. I know I can use the reply from Mr. Robbins but I am not sure of
the exact process to do so. Of course any more info will help tremendously,
Thanks very much,
-Bramston
|
|
With 7,000 properties, you are likely to the same Owner Name applying to
more than one property so a solution that relied on typing the owner name
into a Word document is not likely to be satisfactory. I believe therefore
that you should follow the method that I suggested.
--
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
"Bramston" <bramston[ at ]rogers.com> wrote in message
news:483CA90F-7AD4-47F7-AA41-39EAAD605051[ at ]microsoft.com...
[Quoted Text] >
> "Bramston" <bramston[ at ]rogers.com> wrote in message
> news:64B9208F-26F7-4AE9-9F99-1666C8A623BC[ at ]microsoft.com...
>> Hi All, I used to do this but it was too long ago to remember and things
>> have changed drstically since then.
>>
>> Would someone please tell me the following,
>>
>> I have a form template in Word for which we have to fill out the address
>> of up to 7 thousand properties a year. I would like to have the address
>> and other associated info placed into this form by accessing the Access
>> database. I assume VBA is the correct method but I need to know where to
>> look to find the codes. I also need to make other smaller databases for
>> drop down lists of 40 or so items as Word only allows 25 items in a list.
>> Any help or even sending me off in the right direction (ie:which is the
>> best book to read) would be most appreciated.Thanks very much in Advance.
>> -Bramston
> More specifically, If I type in the address onto the Word doc form I need
> the rest of the form filled out with the current owners name, address,
> etc. All that info is in an access database which gets updated my another
> department as required or I can update the access database from info I
> have collected. I know I can use the reply from Mr. Robbins but I am not
> sure of the exact process to do so. Of course any more info will help
> tremendously,
> Thanks very much,
> -Bramston
|
|
Sorry for my confusing statement. Actually, the address is the unique
identifier and that is the required to be typed entry, I hope the rest-
owners name etc. will be drawn from the database and filled into the word
form at the required locations. I have every intention and desire to follow
your suggestion to the letter but due to my ignorance am not sure if it will
get me where I need to go. I really appreciate your help.
-Fred
"Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> wrote in message
news:eZJuYKyUJHA.5080[ at ]TK2MSFTNGP02.phx.gbl...
[Quoted Text] > With 7,000 properties, you are likely to the same Owner Name applying to
> more than one property so a solution that relied on typing the owner name
> into a Word document is not likely to be satisfactory. I believe
> therefore that you should follow the method that I suggested.
>
> --
> 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
>
> "Bramston" <bramston[ at ]rogers.com> wrote in message
> news:483CA90F-7AD4-47F7-AA41-39EAAD605051[ at ]microsoft.com...
>>
>> "Bramston" <bramston[ at ]rogers.com> wrote in message
>> news:64B9208F-26F7-4AE9-9F99-1666C8A623BC[ at ]microsoft.com...
>>> Hi All, I used to do this but it was too long ago to remember and things
>>> have changed drstically since then.
>>>
>>> Would someone please tell me the following,
>>>
>>> I have a form template in Word for which we have to fill out the address
>>> of up to 7 thousand properties a year. I would like to have the address
>>> and other associated info placed into this form by accessing the Access
>>> database. I assume VBA is the correct method but I need to know where to
>>> look to find the codes. I also need to make other smaller databases for
>>> drop down lists of 40 or so items as Word only allows 25 items in a
>>> list. Any help or even sending me off in the right direction (ie:which
>>> is the best book to read) would be most appreciated.Thanks very much in
>>> Advance.
>>> -Bramston
>> More specifically, If I type in the address onto the Word doc form I need
>> the rest of the form filled out with the current owners name, address,
>> etc. All that info is in an access database which gets updated my another
>> department as required or I can update the access database from info I
>> have collected. I know I can use the reply from Mr. Robbins but I am not
>> sure of the exact process to do so. Of course any more info will help
>> tremendously,
>> Thanks very much,
>> -Bramston
>
>
|
|
You might find it easier to do this from Access
Take a look at the information referred to in the following post from
fellow MVP, Albert Kallal.
Quote
Actually, use my merge sample. it don't give that warning, and you don't
have to change registiry stuff etc.
The sample I have can be found here:
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html
What is nice/interesting about my sample is that is specially designed to
enable ANY form with ONE LINE of code....
Thus, each time you build a new form, you can word merge enable it with
great ease.
Make sure you read the instructions from above, and you should eventually
get to the follwoing page
http://www.members.shaw.ca/AlbertKallal/wordmerge/page2.html
Note that the merge can also use a query, and thus you don't have to merge
just "one" record..
After the merge occurs, you get a plain document WITHOUT any merge fields,
and this allows the end user to save, edit, or even email the document
(since the merge fields are gone after the merge occurs).
Give the above a try.
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal[ at ]msn.com
Unquote
--
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
"Bramston" <bramston[ at ]rogers.com> wrote in message
news:e44%23FfyUJHA.584[ at ]TK2MSFTNGP06.phx.gbl...
[Quoted Text] > Sorry for my confusing statement. Actually, the address is the unique
> identifier and that is the required to be typed entry, I hope the rest-
> owners name etc. will be drawn from the database and filled into the word
> form at the required locations. I have every intention and desire to
> follow
> your suggestion to the letter but due to my ignorance am not sure if it
> will
> get me where I need to go. I really appreciate your help.
> -Fred
>
>
> "Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> wrote in message
> news:eZJuYKyUJHA.5080[ at ]TK2MSFTNGP02.phx.gbl...
>> With 7,000 properties, you are likely to the same Owner Name applying to
>> more than one property so a solution that relied on typing the owner name
>> into a Word document is not likely to be satisfactory. I believe
>> therefore that you should follow the method that I suggested.
>>
>> --
>> 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
>>
>> "Bramston" <bramston[ at ]rogers.com> wrote in message
>> news:483CA90F-7AD4-47F7-AA41-39EAAD605051[ at ]microsoft.com...
>>>
>>> "Bramston" <bramston[ at ]rogers.com> wrote in message
>>> news:64B9208F-26F7-4AE9-9F99-1666C8A623BC[ at ]microsoft.com...
>>>> Hi All, I used to do this but it was too long ago to remember and
>>>> things
>>>> have changed drstically since then.
>>>>
>>>> Would someone please tell me the following,
>>>>
>>>> I have a form template in Word for which we have to fill out the
>>>> address
>>>> of up to 7 thousand properties a year. I would like to have the address
>>>> and other associated info placed into this form by accessing the Access
>>>> database. I assume VBA is the correct method but I need to know where
>>>> to
>>>> look to find the codes. I also need to make other smaller databases for
>>>> drop down lists of 40 or so items as Word only allows 25 items in a
>>>> list. Any help or even sending me off in the right direction (ie:which
>>>> is the best book to read) would be most appreciated.Thanks very much in
>>>> Advance.
>>>> -Bramston
>>> More specifically, If I type in the address onto the Word doc form I
>>> need
>>> the rest of the form filled out with the current owners name, address,
>>> etc. All that info is in an access database which gets updated my
>>> another
>>> department as required or I can update the access database from info I
>>> have collected. I know I can use the reply from Mr. Robbins but I am not
>>> sure of the exact process to do so. Of course any more info will help
>>> tremendously,
>>> Thanks very much,
>>> -Bramston
>>
>>
>
|
|
|