From Form to HTML

CCIDBMNG

Registered User.
Local time
Today, 09:22
Joined
Jan 25, 2002
Messages
154
I was just curious if it's possible to take information typed in a form and paste it into HTML. We need to data-enter customer info into our database but we also need to enter info into a form on web page. The web page is not ours so I can't set the page up to send the info to access. Is this at all possible?
 
CCIDBMNG said:
I was just curious if it's possible to take information typed in a form and paste it into HTML. We need to data-enter customer info into our database but we also need to enter info into a form on web page. The web page is not ours so I can't set the page up to send the info to access. Is this at all possible?

Why would you wan't too change someones elses web page for your own use?

If you are giving someone else info over the web they will provide a means for you to do this.

And if you are using someone elses info from the web then you should have their permission and in that case they will, again, provide you with a way to do it.
 
Once the data is resident in the tables then it is possible to output it in a variety of ways. Now output in HTML format maybe needs a similar approach to the method I used to output data in SGML.

It really does depend on how your tables are set up. If they are fully normalised then thats good for lots of reasons.

Basically you use a query to output the data that you want and then use an alias to wrap the output in the tags you require.

so maybe you have a field Name that outputs Fred for example.
An alias of HTML_Fred in the query as

HTML_Fred:"<BOLD>" & Name & "</BOLD>"

will hopefully output <BOLD>Fred</BOLD>

Base a report on this query
Use Tools Office links Publish with MS Word and then save as a text file and you have a file that contains HTML that you can copy and paste into an application.


Okay a simple example but is this the sort of thing you are looking for.

I have used this technique very successfully to output SGML tagged data that is pasted directly into a framemaker application

I quit for the weekend at noon UK time today

Len B
 
Parker said:
Why would you wan't too change someones elses web page for your own use?

If you are giving someone else info over the web they will provide a means for you to do this.

And if you are using someone elses info from the web then you should have their permission and in that case they will, again, provide you with a way to do it.

I'm not trying to change someone's web page. We are data-entering customer info into a form. We need to do a credit check on the customer so we need to fill out a form on a web page. To receive their credit score. The web form asks for a lot of the same info our database asks for. So I'm wondering if it's possible to take the info entered in the database and paste it in to the form so my users do not have to enter the information twice.
 

Users who are viewing this thread

Back
Top Bottom