
Signature
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
>I have two address lines in my template. If one of the address lines is
>null
[quoted text clipped - 3 lines]
> 2. I want to dynamically fill a form field combo box from a table in a
> dbase. How can this be done.
thank you for the suggestion. I am useing formfields dropdown and the
following code does not work: ActiveDocument.formfields("dropdown1").result
= rs.getrows(noOfRecords). It tells me that there is a type mismatch. Is
there a better newsgroup to use than this userform one?
> I would suggest that you switch over to a UserForm rather than use
> formfields in a protected document.
[quoted text clipped - 61 lines]
> > 2. I want to dynamically fill a form field combo box from a table in a
> > dbase. How can this be done.
Dian D. Chapman, MVP - 22 Apr 2005 23:44 GMT
Try this in place of that line...
Dim strCount As String
strCount = Cstr(rs.getrows(noOfRecords))
ActiveDocument.FormFields("dropdown1"). Result = strCount
Dian D. Chapman, Technical Consultant
Microsoft MVP, MOS Certified
Editor/TechTrax Ezine
Free MS Tutorials: http://www.mousetrax.com/techtrax
Free Word eBook: http://www.mousetrax.com/books.html
Optimize your business docs: http://www.mousetrax.com/consulting
Learn VBA the easy way: http://www.mousetrax.com/techcourses.html
>thank you for the suggestion. I am useing formfields dropdown and the
>following code does not work: ActiveDocument.formfields("dropdown1").result
[quoted text clipped - 66 lines]
>> > 2. I want to dynamically fill a form field combo box from a table in a
>> > dbase. How can this be done.
Dian D. Chapman, MVP - 22 Apr 2005 23:47 GMT
>Is there a better newsgroup to use than this userform one?
Not BETTER than this group...but different. This group caters to a lot
of newbies learning VBA...
http://groups.yahoo.com/group/Word_VBA/
Dian D. Chapman, Technical Consultant
Microsoft MVP, MOS Certified
Editor/TechTrax Ezine
Free MS Tutorials: http://www.mousetrax.com/techtrax
Free Word eBook: http://www.mousetrax.com/books.html
Optimize your business docs: http://www.mousetrax.com/consulting
Learn VBA the easy way: http://www.mousetrax.com/techcourses.html