If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Need help with using HTTP from VBA in Access 2003.
Hello, Lauren Wilson.
Please don't multipost the same question in three different newsgroups, especially under different names, as the experts who answer questions are likely to get angry when they find out you wasted their time because your question has already been answered in another newsgroup. Please see the following Web page: http://www.mvps.org/access/netiquette.htm Last time you were posting a similar question as Cheryl Langdon, who was supposedly being helped out of a desperate family crisis, the application was for a charity to tutor disadvantaged youth, yada, yada, yada. So who is Janet supposed to be? A cousin from Georgia on her way to Hollywood to get a job in the movies but needs gas money to get there, so she's working on your software application for you to pay you back the money you've loaned her? http://www.lmc.bz/tblAdvisories.php?..._id%20%3D%2012 You're passing the User ID and password as parameters in the URL to a script? Do you realize what a security risk this is? Am I correct, or is there a simpler way to do it, perhaps using ADO? Have you considered the Web Browser Active-X control? HTH. Gunny See http://www.QBuilt.com for all your database needs. See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials. http://www.Access.QBuilt.com/html/ex...ributors2.html for contact info. "Janet Wilson" wrote in message ... Can someone point me to some good instructions on using the WinInet.dll functions from VBA? I need to interact with a MySQL database via HTTP strings. We already have the database set up and a PHP script that can receive commands via HTTP. The script receives the HTTP commands and performs the database actions, then responds with XML. This system already works when I test it from IE. I simply send it an HTTP string similar to this: http://www.lmc.bz/tblAdvisories.php?..._id%20%3D%2012 The PHP script executes the query and sends back the results in XML. I just need to know how to set up the VBA code to send the requests. I THINK I must use WinInet functions to do this. Am I correct, or is there a simpler way to do it, perhaps using ADO? More info is available if needed. Thanks, JW |
#2
|
|||
|
|||
Need help with using HTTP from VBA in Access 2003.
On Sat, 6 May 2006 07:48:47 -0700, "'69 Camaro"
AM wrote: Hello, Lauren Wilson. Who is this? I don't know what you are talking about. If you don't want to respond, then don't. Looks like you have a lot of time on your hands. Please don't multipost the same question in three different newsgroups, especially under different names, as the experts who answer questions are likely to get angry when they find out you wasted their time because your question has already been answered in another newsgroup. Please see the following Web page: http://www.mvps.org/access/netiquette.htm Last time you were posting a similar question as Cheryl Langdon, who was supposedly being helped out of a desperate family crisis, the application was for a charity to tutor disadvantaged youth, yada, yada, yada. So who is Janet supposed to be? A cousin from Georgia on her way to Hollywood to get a job in the movies but needs gas money to get there, so she's working on your software application for you to pay you back the money you've loaned her? http://www.lmc.bz/tblAdvisories.php?..._id%20%3D%2012 You're passing the User ID and password as parameters in the URL to a script? Do you realize what a security risk this is? Am I correct, or is there a simpler way to do it, perhaps using ADO? Have you considered the Web Browser Active-X control? HTH. Gunny See http://www.QBuilt.com for all your database needs. See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials. http://www.Access.QBuilt.com/html/ex...ributors2.html for contact info. "Janet Wilson" wrote in message .. . Can someone point me to some good instructions on using the WinInet.dll functions from VBA? I need to interact with a MySQL database via HTTP strings. We already have the database set up and a PHP script that can receive commands via HTTP. The script receives the HTTP commands and performs the database actions, then responds with XML. This system already works when I test it from IE. I simply send it an HTTP string similar to this: http://www.lmc.bz/tblAdvisories.php?..._id%20%3D%2012 The PHP script executes the query and sends back the results in XML. I just need to know how to set up the VBA code to send the requests. I THINK I must use WinInet functions to do this. Am I correct, or is there a simpler way to do it, perhaps using ADO? More info is available if needed. Thanks, JW |
#3
|
|||
|
|||
Need help with using HTTP from VBA in Access 2003.
Hello, Lauren Wilson.
Who is this? I don't know what you are talking about. Yes. You do. Each computer leaves a footprint when it connects to the Internet, and you're using the same computer to post this question as you used to post these other questions on the same topic of using VBA and ADO to access a database on the Web via HTTP, but you used various identities: Charles Wilson: http://groups.google.com/group/comp....1337d052d2b604 Charles Wilson: http://groups.google.com/group/micro...572e4c190c9f49 Cheryl Langdon: http://groups.google.com/group/comp....0034ec41e98c0a Lauren Wilson: http://groups.google.com/group/comp....b3d13e1e96fa7d Lauren Wilson: http://groups.google.com/group/comp....dd3e8a4689309e Lauren Wilson: http://groups.google.com/group/comp....f28a78f1faab64 If you don't want to respond, then don't. If I didn't want to respond, then I wouldn't have taken the time to answer your questions and given you good advice, and also remind you not to multipost, so that you get kill filed by any experts for making this mistake -- so that you'll have future opportunities to get your questions answered by the largest number of experts available. Looks like you have a lot of time on your hands. I have the same amount of time on my hands as you do. It may appear that I have more time to do things than you do because I can get the job done quicker, so I still have time left over to answer Access users' questions on how to fix their Access problems. I have a busy schedule, so it's hard to make time to help others with their computer problems on a regular basis, but I wouldn't do it if I didn't enjoy it. As is the same with the other experts who take the time to answer questions in the newsgroups. Our time is precious, so please don't waste it by playing games and multiposting the same question under different identities and subject lines. When you don't intentionally spread your question out to the four winds, the experts can concentrate their efforts on your problem in a single thread, and possibly research the history of your problem by Googling on your name, in order to give you the best advice based upon your unique circumstances, without you having to repeat yourself every time you want to become "someone new." HTH. Gunny See http://www.QBuilt.com for all your database needs. See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials. http://www.Access.QBuilt.com/html/ex...ributors2.html for contact info. "Janet Wilson" wrote in message ... On Sat, 6 May 2006 07:48:47 -0700, "'69 Camaro" AM wrote: Hello, Lauren Wilson. Who is this? I don't know what you are talking about. If you don't want to respond, then don't. Looks like you have a lot of time on your hands. Please don't multipost the same question in three different newsgroups, especially under different names, as the experts who answer questions are likely to get angry when they find out you wasted their time because your question has already been answered in another newsgroup. Please see the following Web page: http://www.mvps.org/access/netiquette.htm Last time you were posting a similar question as Cheryl Langdon, who was supposedly being helped out of a desperate family crisis, the application was for a charity to tutor disadvantaged youth, yada, yada, yada. So who is Janet supposed to be? A cousin from Georgia on her way to Hollywood to get a job in the movies but needs gas money to get there, so she's working on your software application for you to pay you back the money you've loaned her? http://www.lmc.bz/tblAdvisories.php?..._id%20%3D%2012 You're passing the User ID and password as parameters in the URL to a script? Do you realize what a security risk this is? Am I correct, or is there a simpler way to do it, perhaps using ADO? Have you considered the Web Browser Active-X control? HTH. Gunny See http://www.QBuilt.com for all your database needs. See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials. http://www.Access.QBuilt.com/html/ex...ributors2.html for contact info. "Janet Wilson" wrote in message . .. Can someone point me to some good instructions on using the WinInet.dll functions from VBA? I need to interact with a MySQL database via HTTP strings. We already have the database set up and a PHP script that can receive commands via HTTP. The script receives the HTTP commands and performs the database actions, then responds with XML. This system already works when I test it from IE. I simply send it an HTTP string similar to this: http://www.lmc.bz/tblAdvisories.php?..._id%20%3D%2012 The PHP script executes the query and sends back the results in XML. I just need to know how to set up the VBA code to send the requests. I THINK I must use WinInet functions to do this. Am I correct, or is there a simpler way to do it, perhaps using ADO? More info is available if needed. Thanks, JW |
#4
|
|||
|
|||
Need help with using HTTP from VBA in Access 2003.
Hello, Lauren Wilson.
Perhaps I should have listed the other multiposts of this same question, under multiple identities and under multiple subject lines, in addition to the two listed under Charles Wilson in my previous post. I'm mentioning this because five multiposts under multiple identities is excessive, and by using different names you obviously went out of your way to accomplish it. It's not a good way to make people happy to answer your future questions when they find out the question they've spent time answering has already been answered several times by others. Janet Wilson: http://groups.google.com/group/micro...dcc943c3890046 Charles Wilson: http://groups.google.com/group/micro...5b47dd383e27a5 HTH. Gunny "'69 Camaro" AM wrote in message ... Hello, Lauren Wilson. Who is this? I don't know what you are talking about. Yes. You do. Each computer leaves a footprint when it connects to the Internet, and you're using the same computer to post this question as you used to post these other questions on the same topic of using VBA and ADO to access a database on the Web via HTTP, but you used various identities: Charles Wilson: http://groups.google.com/group/comp....1337d052d2b604 Charles Wilson: http://groups.google.com/group/micro...572e4c190c9f49 Cheryl Langdon: http://groups.google.com/group/comp....0034ec41e98c0a Lauren Wilson: http://groups.google.com/group/comp....b3d13e1e96fa7d Lauren Wilson: http://groups.google.com/group/comp....dd3e8a4689309e Lauren Wilson: http://groups.google.com/group/comp....f28a78f1faab64 If you don't want to respond, then don't. If I didn't want to respond, then I wouldn't have taken the time to answer your questions and given you good advice, and also remind you not to multipost, so that you get kill filed by any experts for making this mistake -- so that you'll have future opportunities to get your questions answered by the largest number of experts available. Looks like you have a lot of time on your hands. I have the same amount of time on my hands as you do. It may appear that I have more time to do things than you do because I can get the job done quicker, so I still have time left over to answer Access users' questions on how to fix their Access problems. I have a busy schedule, so it's hard to make time to help others with their computer problems on a regular basis, but I wouldn't do it if I didn't enjoy it. As is the same with the other experts who take the time to answer questions in the newsgroups. Our time is precious, so please don't waste it by playing games and multiposting the same question under different identities and subject lines. When you don't intentionally spread your question out to the four winds, the experts can concentrate their efforts on your problem in a single thread, and possibly research the history of your problem by Googling on your name, in order to give you the best advice based upon your unique circumstances, without you having to repeat yourself every time you want to become "someone new." HTH. Gunny See http://www.QBuilt.com for all your database needs. See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials. http://www.Access.QBuilt.com/html/ex...ributors2.html for contact info. "Janet Wilson" wrote in message ... On Sat, 6 May 2006 07:48:47 -0700, "'69 Camaro" AM wrote: Hello, Lauren Wilson. Who is this? I don't know what you are talking about. If you don't want to respond, then don't. Looks like you have a lot of time on your hands. Please don't multipost the same question in three different newsgroups, especially under different names, as the experts who answer questions are likely to get angry when they find out you wasted their time because your question has already been answered in another newsgroup. Please see the following Web page: http://www.mvps.org/access/netiquette.htm Last time you were posting a similar question as Cheryl Langdon, who was supposedly being helped out of a desperate family crisis, the application was for a charity to tutor disadvantaged youth, yada, yada, yada. So who is Janet supposed to be? A cousin from Georgia on her way to Hollywood to get a job in the movies but needs gas money to get there, so she's working on your software application for you to pay you back the money you've loaned her? http://www.lmc.bz/tblAdvisories.php?..._id%20%3D%2012 You're passing the User ID and password as parameters in the URL to a script? Do you realize what a security risk this is? Am I correct, or is there a simpler way to do it, perhaps using ADO? Have you considered the Web Browser Active-X control? HTH. Gunny See http://www.QBuilt.com for all your database needs. See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials. http://www.Access.QBuilt.com/html/ex...ributors2.html for contact info. "Janet Wilson" wrote in message ... Can someone point me to some good instructions on using the WinInet.dll functions from VBA? I need to interact with a MySQL database via HTTP strings. We already have the database set up and a PHP script that can receive commands via HTTP. The script receives the HTTP commands and performs the database actions, then responds with XML. This system already works when I test it from IE. I simply send it an HTTP string similar to this: http://www.lmc.bz/tblAdvisories.php?..._id%20%3D%2012 The PHP script executes the query and sends back the results in XML. I just need to know how to set up the VBA code to send the requests. I THINK I must use WinInet functions to do this. Am I correct, or is there a simpler way to do it, perhaps using ADO? More info is available if needed. Thanks, JW |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Advice needed: Should we upgrade MS Access 2000? And if so to what? | ship | General Discussion | 43 | November 30th, 2005 10:58 PM |
Suggestion on updating Access 2000 to Access 2003 | Irshad Alam | General Discussion | 5 | August 10th, 2005 01:51 PM |
Why is a French Spellchecker a "required" update for English speak | French Spellcheck Required? | General Discussion | 23 | April 26th, 2005 01:17 AM |
What is the difference between 2002 and 2003? | Red Sonya | General Discussion | 2 | March 1st, 2005 05:10 AM |
Access 2003 | RK | General Discussion | 12 | June 14th, 2004 10:16 AM |