Database Query
in [Word VBA]
|
Prev: Thumbnails not showing
Next: converting tabular structures in a Word document into an actual table or reading data from the tabular structures using VBA code
From: spunkymuffmonkey on 2 Jun 2010 11:34 Hi Community, I was hoping to seek some guidance or pointers regarding the extracting/querying of db information into Word Documents. In a nutshell I create many form templates for our end users (Social Workers) which they complete on behalf of or regarding our customers. These customers will most likely have been added in our customer database (an Oracle db) and I was hoping that I would be able to reduce the amount of information end users have to enter into a new form by getting the users to type in the Oracle Customer ID and the document to retrieve what information it can automatically from the db. I am using Word 2003 and any pointers, guidance, links to KB articles would be very much appreciated. Thanking you in anticipation.
From: Doug Robbins - Word MVP on 2 Jun 2010 18:55 Take a look at http://www.databasejournal.com/features/oracle/article.php/3358411/Connecting-with-Oracle-Accessing-Oracle-via-Access-and-Excel.htm Once you get the data in Access or Excel, you could use the information on the following page of Greg Maxey's website to load it into a combobox 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, originally posted via msnews.microsoft.com "spunkymuffmonkey" <spunkymuffmonkey(a)discussions.microsoft.com> wrote in message news:F62D2DF1-498E-4C58-A6E3-78153EFA18BA(a)microsoft.com... > Hi Community, > > I was hoping to seek some guidance or pointers regarding the > extracting/querying of db information into Word Documents. > > In a nutshell I create many form templates for our end users (Social > Workers) which they complete on behalf of or regarding our customers. > These > customers will most likely have been added in our customer database (an > Oracle db) and I was hoping that I would be able to reduce the amount of > information end users have to enter into a new form by getting the users > to > type in the Oracle Customer ID and the document to retrieve what > information > it can automatically from the db. > > I am using Word 2003 and any pointers, guidance, links to KB articles > would > be very much appreciated. > > Thanking you in anticipation.
From: spunkymuffmonkey on 3 Jun 2010 06:05
Many thanks. "Doug Robbins - Word MVP" wrote: > Take a look at > http://www.databasejournal.com/features/oracle/article.php/3358411/Connecting-with-Oracle-Accessing-Oracle-via-Access-and-Excel.htm > > Once you get the data in Access or Excel, you could use the information on > the following page of Greg Maxey's website to load it into a combobox > > 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, originally posted via msnews.microsoft.com > > "spunkymuffmonkey" <spunkymuffmonkey(a)discussions.microsoft.com> wrote in > message news:F62D2DF1-498E-4C58-A6E3-78153EFA18BA(a)microsoft.com... > > Hi Community, > > > > I was hoping to seek some guidance or pointers regarding the > > extracting/querying of db information into Word Documents. > > > > In a nutshell I create many form templates for our end users (Social > > Workers) which they complete on behalf of or regarding our customers. > > These > > customers will most likely have been added in our customer database (an > > Oracle db) and I was hoping that I would be able to reduce the amount of > > information end users have to enter into a new form by getting the users > > to > > type in the Oracle Customer ID and the document to retrieve what > > information > > it can automatically from the db. > > > > I am using Word 2003 and any pointers, guidance, links to KB articles > > would > > be very much appreciated. > > > > Thanking you in anticipation. > |