Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 378
  • Last Modified:

Post data from form fields to URL as variables within MS Access

I have a need to create a form within Access, with a button that will send the current values of the form as values within an xml request to a URL.  The remote server will return something, and I will need to have the ability to log or display that information.  

Ive never done anything like this within Access; is it possible?   Ive got all the forms/tables made, I can provide them if needed.  
0
lorsungcu
Asked:
lorsungcu
  • 6
  • 5
1 Solution
 
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPCommented:
Yes it is possible to do with Access. What version of Access are you using?
0
 
lorsungcuAuthor Commented:
2010
0
 
JezWaltersCommented:
I'm not quite sure what you're trying to do, but you can perform HTTP POST requests from code in an Access form by adding a reference to the Microsoft WinHTTP Services library (via the WinHttpRequest object).
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
lorsungcuAuthor Commented:
Thanks, I got it working using objSvrHTTP, and POSTing XML as a string.  What I need now is to pull information from fields within a form, so when a user clicks a button, the values currently displayed are sent as values within the XML.  
0
 
JezWaltersCommented:
Do you mean that you just want help with the string manipulation, to build the XML?
0
 
lorsungcuAuthor Commented:
Essentially, yeah.  Am I able to define a variable as the result of a query?  I must, I'm just not clear on how.  I have a form where a user chooses their username, enters a password, and submits; it just checks that that all matches and send them to a second screen.  I need to use that username/password to query for two other values that I then need to insert into the XML.
My thought was to make a table that stores what user is currently logged in, as well as the values I need, and pull from there?  So when they click log in, create a new unique record of the login in this table, and use a look up to get the values I need?  Or is there a better way?

Thanks for the help!  
0
 
JezWaltersCommented:
The result of a SELECT query is a recordset - although this could contain one record, many records or no records.  The attached sample database should show you how to loop through the records to build up your XML.

Open the form "frmYourForm" and enter User Name = "Fred", Password = "Password1" and then click the Build XML button. Is that the kind of thing you're after?
Q26893917.mdb
0
 
lorsungcuAuthor Commented:
Exactly what I need, but I am going about it a bit differently...I will give this a shot and see if I can apply it.

Thanks!
0
 
JezWaltersCommented:
How were you "going about it a bit differently"?

You could use DLookup() instead, but you'd need 2 calls in order to obtain the 2 values to insert into your XML - which is why the record set approach is better!  :-)
0
 
JezWaltersCommented:
How are you getting on with this question?  Do you need any more help or advice?
0
 
lorsungcuAuthor Commented:
Thanks, works great.
0
 
JezWaltersCommented:
Glad I could help!  :-)
0

Featured Post

Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

  • 6
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now