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.

the thing is I need it to be able to be sent by email..the way we're doing it is our service guys in our company tend to travel alot and make Customer Request Forms, and if they're out of the office for a week or two, we'd like to have it so they can email the single record back here to the office, and have a person located within the office insert it into our database here at the office..and then be able to print, and send it off..just so it doesn't take 2-3 weeks for a request to get through.

I believe we do have access to a webserver...I'd have to double check with my supervisor on that one...but I'm pretty sure(80%) we do...but not everyone within the company is very good with computers so looking for the easy way to do things for their sake heh...

But if we do would the webserver be the better way to do it instead of exporting??

I'm thinking providing an export method within whatever platform the customer requests form are on. Have it place the file on your webserver, then you can pull it down from there. That's just one of a dizzying array of solutions you can provide if everyone has access to a webserver. It takes the confusion and potential for human error out of the equation. Email... well.. doesn't.

And, if you use ado, rather than dao, you can persist a recordset into a file; either an ms proprietary format, or an xml format. The ADO recordset can read a URL path name for this task... (http://www.domain.com/YourRS.rst, for instance)

Lou
使大吃一惊"Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
"I have my standards. They may be low, but I have them!" - Bette Middler
"It's a book about a Spanish guy named Manual. You should read it." - Dilbert

we've gone the exporting the record as an XML document...now is there any way I could have it set up on the form to take the data, and export it as the XML file instead of doing it through File>Export??