populating a combobox with data from a SQL Database table field 
Author Message
 populating a combobox with data from a SQL Database table field

Hello there developers,
I am rather new to VBA, however I would like to tackle
the job of creating a
letter template.
The new document would have a ComboBox which would be
populated by data
coming from a table in a SQL database. Based on the
user's response the
correct data would be pulled in from the SQL database
table and put into
previously bookmarked fields.

As I see it, there is the part of connecting to the
SQL Server, and to the
SQL Database and table.
Should this be done using ADO? If so, what would be
the code to do this?

The next step is to create a loop that would populate
the combobox with data
from a field coming in from the SQL Database Table.

Then there is the issue of getting the user's choice
and based on that,
putting data from the SQL Database into the new
document at the correct
locations.

It's a lot, so it would be better to picka few points to start with...
Any ideas?



Wed, 14 Jan 2004 09:10:30 GMT  
 populating a combobox with data from a SQL Database table field
Answered duplicate question in one of the .Office.Developer
groups.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister
http://www.mvps.org/word
http://go.compuserve.com/MSOfficeForum

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail
:-)



Wed, 14 Jan 2004 19:02:50 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. populating a combobox with data from a SQL Database table field

2. populating a combobox with data from a SQL Database table field

3. Combobox Populated by Word Table

4. Populating 3 fields in Combobox in VB.Net Windows Forms

5. Populating a ComboBox from linked table

6. SQL table field data types

7. populate combobox with SQL

8. HELP !!! Populating ComboBox and ListBox with data

9. How to populate ComboBox from database

10. HELP !!! Populating ComboBox and ListBox with data

11. HELP !!! Populating ComboBox and ListBox with data

12. sql query to move data between two databases with the same table structure

 

 
Powered by phpBB® Forum Software