Exporting Forms

S

sky

I would like to know if there is a way to export a form to outlook express so
that I can send that form to my customers to fill it out & have them send it
back to me with the information inputted by them & import the information
that they filled out back into access.
 
N

Nikos Yannacopoulos

Sky,

No, I'm afraid you cannot do that :-(

Forms (a) don't "live" outside of an Access app on their own, and (b)
don't store data. They are just an interface to an Access (or other back
end) table, where the data is actually stored.

Nikos
 
S

sky

Is there another way of doing something like this through another program
where I wouldn't have to send it as an attachment?
 
N

Nikos Yannacopoulos

There are many ways to do it, offering varying degrees of convenience
and auomation possibilities.

Ideally you could make a web interface (asp or Access DAP or...) and
publich it on the internet so your customers can enter their data right
into your database through their web browser.

Alternatively, you could use an Excel workbook which customers can fill
in and send back, and then you can store in a specific folder and write
some (fairly advanced) code in Access to import the data from each Excel
file.

A variation of the previous is to make an Excel form with some code to
produce a (flat or delimited) text file, which the customer sends back.
Importing those into Access is rather easier.

That's all I can think of right now.

HTH,
Nikos
 
Top