How to pass a parameter from vba to html

[rubertoga]

I need to get an account number from my access form to a url which will be processed by an ASP page.

Can you tell me how I would get the variable by the name of strAccount from the form onto the end of following URL:

http://xyz123/accounts/account.asp?

It's not really covered anywhere i've read/looked up

Thanks

 

[VBslammer]

Append the account number to the url before you call the ASP page:

Dim strURL As String

strURL = "[URL unfurl="true"]http://domain/folder/page.asp?acct="[/URL] & Me.AccountNumber

Application.FollowHyperlink strURL

Your ASP page needs to be expecting a [tt]Request.QueryString("acct")[/tt] argument.

VBSlammer

"You just have to know which screws to turn." - Professor Bob

 

[rubertoga]

Thanks VBSlammer it worked a treat )