Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-08-21 : 10:34:55
|
| Sara writes "I am trying to take information from an existing database form. It is using access data projects on the front end and sql server on the backend. I want to use a stored procedure to take all the information on the form, click a submit button and have the information automatically populate a web form for fed ex. Is there any way to do this?" |
|
|
royv
Constraint Violating Yak Guru
455 Posts |
Posted - 2002-08-21 : 11:25:17
|
| What is access data projects?*************************Someone done told you wrong! |
 |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2002-08-21 : 11:44:29
|
| Access Data Projects (ADP) is a way to use Access to "link" to SQL server to get it's tables etc, but use Access's report and form designers.Sara, do you have an Access form that needs to send data to a FedEx HTML form? Or do you have a HTML form that pulls data from your SQL server and this form needs to send data to FedEx?Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
steelkilt
Constraint Violating Yak Guru
255 Posts |
Posted - 2002-08-27 : 15:58:01
|
| If I understand your situation properly, you are first querying a SQL Server database from within MS Access. This query results in an Access-based form being populated with data from the query. Next, you wish to click a "submit" button on the Access form, which will strip the data from your Access form and place this data in the related fields on a web-based "fedex" form. If I have described your situation correctly, we're almost there. We next need to know where this "fedex" form resides. Is it a form on the fedex website or is it a form you've created on your own that resides on your machine or on a web server that you have administrative rights to? If your own machine/web server, which platform, Microsoft/IIS?If all this is happening in-house on your own machines, and you're on a Microsoft platform, you can use a combination of Visual Basic for Applications (within Access) and Active Server Pages (on the website) to strip the Access form values and populate the "fedex" form. As you can see, the "fedex" form is the wildcard here. Need more info on this. Of course, I'm assuming a MS platform here. I could be wrong.Cheers. |
|
|
|
|
|
|
|
|
Web form question