Forms help

[Mike]

Could use a link to sample code, and general advice, on the following.

I have a macro that imports a CSV file and then queries a SQL Server
database using criteria from the rows in the CSV file. Specifically, it uses
information from two columns and populates the row with three columns from
SQL Server if it finds a match. Right now, if there is no match then a human
has to query the database through the application's front end and key the
information into the spreadsheet by hand.

What I would like to do is have the macro do the initial matching and then
have an operator step through the missing information. I envision a form
with a couple hundred rows of data in a combobox that they'd scroll through
until they found a match. A button would insert the information into the
three columns. The form could either remain up all the time or pop us as
needed. The data in the form can remain static.

Thanks in advance for any assistance.

 

[Mike]

Forgot to mention, this is Office 2003.

 

[dan dungan]

I have a macro that imports a CSV file and then queries a SQL Server
database using criteria from the rows in the CSV file...

What I would like to do is have the macro do the initial matching

This is already working, right?

have an operator step through the missing information. I envision a form
with a couple hundred rows of data in a combobox that they'd scroll through
until they found a match. A button would insert the information into the
three columns. The form could either remain up all the time or pop us as
needed. The data in the form can remain static.

Have you already designed the form?

It sounds like you have a good plan. Where do you get stuck?

 

[Mike]

The initial matching works. I am getting stuck because I do not have much
experience programming forms and could use a pointer toward good tutorials
for Office 2003. Specifically, I need to know the best stock control to
display multiple columns of data and how to populate and display it
efficiently. Thanks.

I have a macro that imports a CSV file and then queries a SQL Server
database using criteria from the rows in the CSV file...

What I would like to do is have the macro do the initial matching

This is already working, right?

have an operator step through the missing information. I envision a form
with a couple hundred rows of data in a combobox that they'd scroll
through
until they found a match. A button would insert the information into the
three columns. The form could either remain up all the time or pop us as
needed. The data in the form can remain static.

Have you already designed the form?

It sounds like you have a good plan. Where do you get stuck?

 

[dan dungan]

Hi Mike,

A combobox can display multiple columns.

A textbox can hold the data entry.

I'd look here for form design tutorial
http://www.contextures.com/tiptech.html


I search these websites when I need ideas:
http://www.cpearson.com/excel/MainPage.aspx
http://spreadsheetpage.com/

Dan