any MS Office experts out there?

INFINITE

Limp Gawd
Joined
Nov 22, 2004
Messages
189
Using Office 2007 and here's what I'm trying to do...

I have a Access database and query with filtered results I need.

I want to take that queried data and put it into a drop down / combo box within a Word document. I'm fairly confident this is possible but I'm having a difficult time doing it.

Any help is much appreciated!
 

INFINITE

Limp Gawd
Joined
Nov 22, 2004
Messages
189
Nice idea but you can't copy the combo / drop down box from a from within Access to Word :(

The real bugger of it is - you can create forms all day long in both apps but there's no way to automate the process of populating whats in those fields in Word. This list has about 100+ items in it and I was really hoping to automate that vs manually entering them.
 

PTNL

Supreme [H]ardness
Joined
Jan 2, 2005
Messages
4,190
VBA can handle this.

Looking again at what you're trying to accomplish, I wonder whether this problem is just a tip of the iceberg situation that warrants moving away from disparate and unmanageable connections.
 
Last edited:
Top