simple question.

[Hitesh Joshi]

Hi,

Not sure if this is the right group to ask this question...
I have never worked with asp or vb and I need some starting point clue
on delima I am facing.
I need to access an external website from within an access db. i.e. an
user would click a command button it will open the website. This
website is password protected.
the webserver url is like http://server1/login.asp
is there any simple way I can send username and password from vba/vb?

I tried like http://itgcrm/login.asp?userid=usern...sword=password

but this commdn string is not working.

please exuse my ignorance about asp/vb

thank you,
hj

[McKirahan]

"Hitesh Joshi" <hi*******@gmail.comwrote in message
news:11*********************@d34g2000cwd.googlegro ups.com...

Hi,

Not sure if this is the right group to ask this question...
I have never worked with asp or vb and I need some starting point clue
on delima I am facing.
I need to access an external website from within an access db. i.e. an
user would click a command button it will open the website. This
website is password protected.
the webserver url is like http://server1/login.asp
is there any simple way I can send username and password from vba/vb?

I tried like http://itgcrm/login.asp?userid=usern...sword=password

but this commdn string is not working.

please exuse my ignorance about asp/vb

"I need to access an external website from within an access db." --
this is a VBA question not an ASP question.

This format used to be supported: http://username:password@domain

Embed a User ID and Password in a URL
http://www.devx.com/tips/Tip/5604

However, your URLs are for a "login.asp" page which probably require
the completion of form fields then a submission of the form.

If you provide more details of what you want to do maybe we can help.

[Hitesh Joshi]

Thank you for your kind reply. I want to link a field from one of my
table to CRM website. I have customerID and when user double click that
id, he should be taken to this website.


McKirahan wrote:

"Hitesh Joshi" <hi*******@gmail.comwrote in message
news:11*********************@d34g2000cwd.googlegro ups.com...

Hi,

Not sure if this is the right group to ask this question...
I have never worked with asp or vb and I need some starting point clue
on delima I am facing.
I need to access an external website from within an access db. i.e. an
user would click a command button it will open the website. This
website is password protected.
the webserver url is like http://server1/login.asp
is there any simple way I can send username and password from vba/vb?

I tried like http://itgcrm/login.asp?userid=usern...sword=password

but this commdn string is not working.

please exuse my ignorance about asp/vb

"I need to access an external website from within an access db." --
this is a VBA question not an ASP question.

This format used to be supported: http://username:password@domain

Embed a User ID and Password in a URL
http://www.devx.com/tips/Tip/5604

However, your URLs are for a "login.asp" page which probably require
the completion of form fields then a submission of the form.

If you provide more details of what you want to do maybe we can help.

[McKirahan]

"Hitesh Joshi" <hi*******@gmail.comwrote in message
news:11*********************@m7g2000cwm.googlegrou ps.com...

>
Thank you for your kind reply. I want to link a field from one of my
table to CRM website. I have customerID and when user double click that
id, he should be taken to this website.

Please don't top-post as it makes the "conversation" harder to follow.

[snip]

I need to access an external website from within an access db. i.e. an
user would click a command button it will open the website.

As I said before:

this is a VBA question not an ASP question.

Consider posting in a VBA newsgroups; here are a few:

alt.comp.lang.vba
microsoft.public.access.modulesdao
microsoft.public.access.modulesdaovba.ado
microsoft.public.developer.vba

[SLH]

not if you simply read from the bottom up. you know, like you do with email
every day?
and since a lot of us use our email software to post to the newsgroups, "top
posting" is the default (which must mean something, no?)

either way, this ridiculous conversation has gone on for years. when will
you realize 50% agree with you, 50% disagree. learn to live with the 50%
that "top post" or i suggest you dont bother reading news posts

"McKirahan" <Ne**@McKirahan.comwrote in message
news:47******************************@comcast.com. ..

"Hitesh Joshi" <hi*******@gmail.comwrote in message
news:11*********************@m7g2000cwm.googlegrou ps.com...

>>
Thank you for your kind reply. I want to link a field from one of my
table to CRM website. I have customerID and when user double click that
id, he should be taken to this website.

Please don't top-post as it makes the "conversation" harder to follow.

[snip]

I need to access an external website from within an access db. i.e.
an
user would click a command button it will open the website.

As I said before:

this is a VBA question not an ASP question.

Consider posting in a VBA newsgroups; here are a few:

alt.comp.lang.vba
microsoft.public.access.modulesdao
microsoft.public.access.modulesdaovba.ado
microsoft.public.developer.vba

[Anthony Jones]

"SLH" <SL*@SLH.SLHwrote in message
news:u9**************@TK2MSFTNGP04.phx.gbl...

not if you simply read from the bottom up. you know, like you do with

email

every day?
and since a lot of us use our email software to post to the newsgroups,

"top

posting" is the default (which must mean something, no?)

either way, this ridiculous conversation has gone on for years. when will
you realize 50% agree with you, 50% disagree. learn to live with the 50%
that "top post" or i suggest you dont bother reading news posts

Good point, We've allways got the option to not bother to respond to top
posters. However it helps those who are offering to help to read about an
issue in chronological order. If you want to maximise the range of people
you can get help from then the logical thing to do is to avoid top posting.
That way it is easier for someone who may have something useful to add to
jump in. Top posting tends to lock you into one or two respondants and if
your not finding their comments helpful you've kinda cut yourself off from
others who might have something helpful to add

I personally don't believe in 'laying down the law' in this regards but I
think it is reasonable for someone who is posting a lot of help to ask
'please don't top post'. For example I've responded to this bit here
without bothering to read the rest of the thread below in fact ... there
I've just cut it out. ;)