A general "How would you code this" question.

[Brave]

I am hoping for a code example of how to do this, and hopefully it will
help me to see an easy way to code what seems to be a huge monster.

I need to create a form that has two pulldown menues (field names
Option1 and Option2). Each will house a list of the 50 U.S. States.
Users would then be able to choose two states, and get a listing for a
courier used for pickup\deliveri es (exp: My order is in Ohio, but I
need it delivered to Maine. Who do I use?)

I am not as familiar with code as I would like, but it seems I would
need something like this:

If option1 = this, and option2 = this, then the answer (field name
Result) = this

I know that looks stupid, but I am hoping to show you how I am
approching this in my head.

Any ideas on how you would approch this project would be great. If you
could offer a sample of code, I'm sure I could use it as a template for
other projects. My idea is that this is just standard IF this THEN that
coding, but I don't know the basics enough to create the code from
scratch.

Thanks for any time you can give.

[Slim]

"Brave" <br*********@ya hoo.comwrote in message
news:11******** *************@e 3g2000cwe.googl egroups.com...

>I am hoping for a code example of how to do this, and hopefully it will
help me to see an easy way to code what seems to be a huge monster.

I need to create a form that has two pulldown menues (field names
Option1 and Option2). Each will house a list of the 50 U.S. States.
Users would then be able to choose two states, and get a listing for a
courier used for pickup\deliveri es (exp: My order is in Ohio, but I
need it delivered to Maine. Who do I use?)

I am not as familiar with code as I would like, but it seems I would
need something like this:

If option1 = this, and option2 = this, then the answer (field name
Result) = this

choosing the states and then submitting the form would give you the 2
values. that is the easy part.
Now how do you expect to select the best courier from this information?

You would need some sort of lookup table.

>
I know that looks stupid, but I am hoping to show you how I am
approching this in my head.

Any ideas on how you would approch this project would be great. If you
could offer a sample of code, I'm sure I could use it as a template for
other projects. My idea is that this is just standard IF this THEN that
coding, but I don't know the basics enough to create the code from
scratch.

Thanks for any time you can give.

[Brave]

Thanks for the reply. I will be given an excel sheet that shows (much
like looking at a map) what courier is used.

States are listed down the side and accross the top of the excel sheet.
(exp: Ohio and Maine = UPS)

On Nov 6, 9:52 am, "Slim" <[e-mail] rote:

"Brave" <bravespl...@ya hoo.comwrote in messagenews:11* *************** *****@e3g2000cw e.googlegroups. com...

I am hoping for a code example of how to do this, and hopefully it will
help me to see an easy way to code what seems to be a huge monster.

I need to create a form that has two pulldown menues (field names
Option1 and Option2). Each will house a list of the 50 U.S. States.
Users would then be able to choose two states, and get a listing for a
courier used for pickup\deliveri es (exp: My order is in Ohio, but I
need it delivered to Maine. Who do I use?)

I am not as familiar with code as I would like, but it seems I would
need something like this:

If option1 = this, and option2 = this, then the answer (field name
Result) = thischoosing the states and then submitting the form would give you the 2

values. that is the easy part.
Now how do you expect to select the best courier from this information?

You would need some sort of lookup table.

I know that looks stupid, but I am hoping to show you how I am
approching this in my head.

Any ideas on how you would approch this project would be great. If you
could offer a sample of code, I'm sure I could use it as a template for
other projects. My idea is that this is just standard IF this THEN that
coding, but I don't know the basics enough to create the code from
scratch.

Thanks for any time you can give.- Hide quoted text -- Show quoted text -

[Slim]

"Brave" <br*********@ya hoo.comwrote in message
news:11******** **************@ e3g2000cwe.goog legroups.com...

Thanks for the reply. I will be given an excel sheet that shows (much
like looking at a map) what courier is used.

States are listed down the side and accross the top of the excel sheet.
(exp: Ohio and Maine = UPS)

ok
well i would load the data into a database, but you can read straight from
the excel file also.

you need to make a connection to the data

then use a SQL query to select the answere and reder it to the client.

do you know how to make a connection to a excel sheet?

do you know how to make a SQL query?

On Nov 6, 9:52 am, "Slim" <[e-mail] rote:

>"Brave" <bravespl...@ya hoo.comwrote in
messagenews:11 *************** ******@e3g2000c we.googlegroups .com...

>I am hoping for a code example of how to do this, and hopefully it will
help me to see an easy way to code what seems to be a huge monster.

I need to create a form that has two pulldown menues (field names
Option1 and Option2). Each will house a list of the 50 U.S. States.
Users would then be able to choose two states, and get a listing for a
courier used for pickup\deliveri es (exp: My order is in Ohio, but I
need it delivered to Maine. Who do I use?)

I am not as familiar with code as I would like, but it seems I would
need something like this:

If option1 = this, and option2 = this, then the answer (field name
Result) = thischoosing the states and then submitting the form would
give you the 2

values. that is the easy part.
Now how do you expect to select the best courier from this information?

You would need some sort of lookup table.

I know that looks stupid, but I am hoping to show you how I am
approching this in my head.

Any ideas on how you would approch this project would be great. If you
could offer a sample of code, I'm sure I could use it as a template for
other projects. My idea is that this is just standard IF this THEN that
coding, but I don't know the basics enough to create the code from
scratch.

Thanks for any time you can give.- Hide quoted text -- Show quoted
text -

[Brave]

I have done some simple update queries, but nothing very advanced. I
have never connected to an excel sheet

Here is an example of a connection to an MS Access db I did. Would it
structure itself in a similar way?

<%
Set Conn = Server.CreateOb ject("ADODB.Con nection")
Conn.Open "driver={Micros oft Access Driver
(*.mdb)};;DBQ=\ \*********Path to database******* .mdb;"
mySQL="INSERT INTO Table (FieldName) VALUES (Option1)"
Conn.Execute(my SQL)
Conn.Close
Set Conn = Nothing
%>
On Nov 6, 11:39 am, "Slim" <[e-mail] rote:

"Brave" <bravespl...@ya hoo.comwrote in messagenews:11* *************** ******@e3g2000c we.googlegroups .com...

Thanks for the reply. I will be given an excel sheet that shows (much
like looking at a map) what courier is used.

States are listed down the side and accross the top of the excel sheet.
(exp: Ohio and Maine = UPS)ok

well i would load the data into a database, but you can read straight from
the excel file also.

you need to make a connection to the data

then use a SQL query to select the answere and reder it to the client.

do you know how to make a connection to a excel sheet?

do you know how to make a SQL query?

On Nov 6, 9:52 am, "Slim" <[e-mail] rote:

"Brave" <bravespl...@ya hoo.comwrote in
messagenews:11* *************** *****@e3g2000cw e.googlegroups. com...

I am hoping for a code example of how to do this, and hopefully it will
help me to see an easy way to code what seems to be a huge monster.

I need to create a form that has two pulldown menues (field names
Option1 and Option2). Each will house a list of the 50 U.S. States.
Users would then be able to choose two states, and get a listing for a
courier used for pickup\deliveri es (exp: My order is in Ohio, but I
need it delivered to Maine. Who do I use?)

I am not as familiar with code as I would like, but it seems I would
need something like this:

If option1 = this, and option2 = this, then the answer (field name
Result) = thischoosing the states and then submitting the form would
give you the 2
values. that is the easy part.
Now how do you expect to select the best courier from this information?

You would need some sort of lookup table.

I know that looks stupid, but I am hoping to show you how I am
approching this in my head.

Any ideas on how you would approch this project would be great. If you
could offer a sample of code, I'm sure I could use it as a template for
other projects. My idea is that this is just standard IF this THEN that
coding, but I don't know the basics enough to create the code from
scratch.

Thanks for any time you can give.- Hide quoted text -- Show quoted
text -- Hide quoted text -- Show quoted text -

[Mike Brind]

Hmmm. For connecting to Access, you are better off using the OLEDB driver
rather than the ODBC driver in your example

Conn.Open "Provider=Micro soft.Jet.OLEDB. 4.0;Data Source=\somepat h\mydb.mdb;

Excel is pretty much the same:

Conn.Open "Provider=Micro soft.Jet.OLEDB. 4.0;Data
Source=Fullpath \MyExcel.xls;Ex tended Properties=""Ex cel
8.0;HDR=Yes;IME X=1"""

HDR=Yes indicates that the worksheet has a header row. Remove IMEX=1 if you
want to write to the worksheet.

sql="SELECT field1, field2 FROM [Sheet1$]" is an example select statement.
Notice that the worksheet name is followed by a $ sign.

--
Mike Brind
"Brave" <br*********@ya hoo.comwrote in message
news:11******** *************@m 7g2000cwm.googl egroups.com...

>I have done some simple update queries, but nothing very advanced. I
have never connected to an excel sheet

Here is an example of a connection to an MS Access db I did. Would it
structure itself in a similar way?

<%
Set Conn = Server.CreateOb ject("ADODB.Con nection")
Conn.Open "driver={Micros oft Access Driver
(*.mdb)};;DBQ=\ \*********Path to database******* .mdb;"
mySQL="INSERT INTO Table (FieldName) VALUES (Option1)"
Conn.Execute(my SQL)
Conn.Close
Set Conn = Nothing
%>
On Nov 6, 11:39 am, "Slim" <[e-mail] rote:

>"Brave" <bravespl...@ya hoo.comwrote in
messagenews:11 *************** *******@e3g2000 cwe.googlegroup s.com...

Thanks for the reply. I will be given an excel sheet that shows (much
like looking at a map) what courier is used.

States are listed down the side and accross the top of the excel sheet.
(exp: Ohio and Maine = UPS)ok

well i would load the data into a database, but you can read straight
from
the excel file also.

you need to make a connection to the data

then use a SQL query to select the answere and reder it to the client.

do you know how to make a connection to a excel sheet?

do you know how to make a SQL query?

On Nov 6, 9:52 am, "Slim" <[e-mail] rote:
"Brave" <bravespl...@ya hoo.comwrote in
messagenews:11 *************** ******@e3g2000c we.googlegroups .com...

>I am hoping for a code example of how to do this, and hopefully it
will
help me to see an easy way to code what seems to be a huge monster.

I need to create a form that has two pulldown menues (field names
Option1 and Option2). Each will house a list of the 50 U.S. States.
Users would then be able to choose two states, and get a listing for
a
courier used for pickup\deliveri es (exp: My order is in Ohio, but I
need it delivered to Maine. Who do I use?)

I am not as familiar with code as I would like, but it seems I would
need something like this:

If option1 = this, and option2 = this, then the answer (field name
Result) = thischoosing the states and then submitting the form would
give you the 2
values. that is the easy part.
Now how do you expect to select the best courier from this
information?

>You would need some sort of lookup table.

I know that looks stupid, but I am hoping to show you how I am
approching this in my head.

Any ideas on how you would approch this project would be great. If
you
could offer a sample of code, I'm sure I could use it as a template
for
other projects. My idea is that this is just standard IF this THEN
that
coding, but I don't know the basics enough to create the code from
scratch.

Thanks for any time you can give.- Hide quoted text -- Show quoted
text -- Hide quoted text -- Show quoted text -

[Slim]

Better still

I would upload my data into access, is there a reason for the data staying
in excel format?

"Mike Brind" <pa*******@hotm ail.comwrote in message
news:eS******** ******@TK2MSFTN GP03.phx.gbl...

Hmmm. For connecting to Access, you are better off using the OLEDB driver
rather than the ODBC driver in your example

Conn.Open "Provider=Micro soft.Jet.OLEDB. 4.0;Data
Source=\somepat h\mydb.mdb;

Excel is pretty much the same:

Conn.Open "Provider=Micro soft.Jet.OLEDB. 4.0;Data
Source=Fullpath \MyExcel.xls;Ex tended Properties=""Ex cel
8.0;HDR=Yes;IME X=1"""

HDR=Yes indicates that the worksheet has a header row. Remove IMEX=1 if
you want to write to the worksheet.

sql="SELECT field1, field2 FROM [Sheet1$]" is an example select statement.
Notice that the worksheet name is followed by a $ sign.

--
Mike Brind
"Brave" <br*********@ya hoo.comwrote in message
news:11******** *************@m 7g2000cwm.googl egroups.com...

>>I have done some simple update queries, but nothing very advanced. I
have never connected to an excel sheet

Here is an example of a connection to an MS Access db I did. Would it
structure itself in a similar way?

<%
Set Conn = Server.CreateOb ject("ADODB.Con nection")
Conn.Open "driver={Micros oft Access Driver
(*.mdb)};;DBQ= \\*********Path to database******* .mdb;"
mySQL="INSER T INTO Table (FieldName) VALUES (Option1)"
Conn.Execute(m ySQL)
Conn.Close
Set Conn = Nothing
%>
On Nov 6, 11:39 am, "Slim" <[e-mail] rote:

>>"Brave" <bravespl...@ya hoo.comwrote in
messagenews:1 1************** ********@e3g200 0cwe.googlegrou ps.com...

Thanks for the reply. I will be given an excel sheet that shows (much
like looking at a map) what courier is used.

States are listed down the side and accross the top of the excel
sheet.
(exp: Ohio and Maine = UPS)ok
well i would load the data into a database, but you can read straight
from
the excel file also.

you need to make a connection to the data

then use a SQL query to select the answere and reder it to the client.

do you know how to make a connection to a excel sheet?

do you know how to make a SQL query?

On Nov 6, 9:52 am, "Slim" <[e-mail] rote:
"Brave" <bravespl...@ya hoo.comwrote in
messagenews:1 1************** *******@e3g2000 cwe.googlegroup s.com...

I am hoping for a code example of how to do this, and hopefully it
will
help me to see an easy way to code what seems to be a huge monster.

I need to create a form that has two pulldown menues (field names
Option1 and Option2). Each will house a list of the 50 U.S. States.
Users would then be able to choose two states, and get a listing
for a
courier used for pickup\deliveri es (exp: My order is in Ohio, but I
need it delivered to Maine. Who do I use?)

I am not as familiar with code as I would like, but it seems I
would
need something like this:

If option1 = this, and option2 = this, then the answer (field name
Result) = thischoosing the states and then submitting the form
would
give you the 2
values. that is the easy part.
Now how do you expect to select the best courier from this
information ?

You would need some sort of lookup table.

I know that looks stupid, but I am hoping to show you how I am
approching this in my head.

Any ideas on how you would approch this project would be great. If
you
could offer a sample of code, I'm sure I could use it as a template
for
other projects. My idea is that this is just standard IF this THEN
that
coding, but I don't know the basics enough to create the code from
scratch.

Thanks for any time you can give.- Hide quoted text -- Show quoted
text -- Hide quoted text -- Show quoted text -

[Brave]

No, my plan is to do it in access. I was just wondering about the
specifics. I'm assuming that functionality may come in handy on a
future project.

Thanks for everything.

On Nov 8, 12:12 pm, "Slim" <[e-mail] rote:

Better still

I would upload my data into access, is there a reason for the data staying
in excel format?

"Mike Brind" <paxton...@hotm ail.comwrote in messagenews:eS* *************@T K2MSFTNGP03.phx .gbl...

Hmmm. For connecting to Access, you are better off using the OLEDB driver
rather than the ODBC driver in your example

Conn.Open "Provider=Micro soft.Jet.OLEDB. 4.0;Data
Source=\somepat h\mydb.mdb;

Excel is pretty much the same:

Conn.Open "Provider=Micro soft.Jet.OLEDB. 4.0;Data
Source=Fullpath \MyExcel.xls;Ex tended Properties=""Ex cel
8.0;HDR=Yes;IME X=1"""

HDR=Yes indicates that the worksheet has a header row. Remove IMEX=1 if
you want to write to the worksheet.

sql="SELECT field1, field2 FROM [Sheet1$]" is an example select statement.
Notice that the worksheet name is followed by a $ sign.

--
Mike Brind

"Brave" <bravespl...@ya hoo.comwrote in message
news:11******** *************@m 7g2000cwm.googl egroups.com...

>I have done some simple update queries, but nothing very advanced. I
have never connected to an excel sheet

Here is an example of a connection to an MS Access db I did. Would it
structure itself in a similar way?

<%
Set Conn = Server.CreateOb ject("ADODB.Con nection")
Conn.Open "driver={Micros oft Access Driver
(*.mdb)};;DBQ=\ \*********Path to database******* .mdb;"
mySQL="INSERT INTO Table (FieldName) VALUES (Option1)"
Conn.Execute(my SQL)
Conn.Close
Set Conn = Nothing
%>

On Nov 6, 11:39 am, "Slim" <[e-mail] rote:
"Brave" <bravespl...@ya hoo.comwrote in
messagenews:11 *************** *******@e3g2000 cwe.googlegroup s.com...

Thanks for the reply. I will be given an excel sheet that shows (much
like looking at a map) what courier is used.

States are listed down the side and accross the top of the excel
sheet.
(exp: Ohio and Maine = UPS)ok
well i would load the data into a database, but you can read straight
from
the excel file also.

>you need to make a connection to the data

>then use a SQL query to select the answere and reder it to the client.

>do you know how to make a connection to a excel sheet?

>do you know how to make a SQL query?

On Nov 6, 9:52 am, "Slim" <[e-mail] rote:
"Brave" <bravespl...@ya hoo.comwrote in
messagenews:11 *************** ******@e3g2000c we.googlegroups .com...

>I am hoping for a code example of how to do this, and hopefully it
will
help me to see an easy way to code what seems to be a huge monster.

I need to create a form that has two pulldown menues (field names
Option1 and Option2). Each will house a list of the 50 U.S. States.
Users would then be able to choose two states, and get a listing
for a
courier used for pickup\deliveri es (exp: My order is in Ohio, but I
need it delivered to Maine. Who do I use?)

I am not as familiar with code as I would like, but it seems I
would
need something like this:

If option1 = this, and option2 = this, then the answer (field name
Result) = thischoosing the states and then submitting the form
would
give you the 2
values. that is the easy part.
Now how do you expect to select the best courier from this
information?

>You would need some sort of lookup table.

I know that looks stupid, but I am hoping to show you how I am
approching this in my head.

Any ideas on how you would approch this project would be great. If
you
could offer a sample of code, I'm sure I could use it as a template
for
other projects. My idea is that this is just standard IF this THEN
that
coding, but I don't know the basics enough to create the code from
scratch.

Thanks for any time you can give.- Hide quoted text -- Show quoted
text -- Hide quoted text -- Show quoted text -- Hide quoted text -- Show quoted text -