Access

[Info Tech Geek]

I have an access Database that I use, the problem is I need to get updates from individuals who do not have access to the database. So here is what I did.

I setup a report that I can automatically have sent to the individual. The only problem is the two responses I need are in the form of a check box and do not show up when I use RTF format. What can I do to make it easier for them to input the data. All I need is a Yes/No from them and I will import it into the database myself.

It comes out (example)

Name Date Did You.... Location Need Again?
Samuel J. 11/11/11 Texas

then when they import instead of spacing in the mess us the alignment or they don't do it.

[nihil]

Hi,

Have you tried creating a "form" and making the fields mandatory? That should get round the format problem.

I am assuming that they have Access locally?

Just a thought :)

[Info Tech Geek]

No, I am using the send via mail in a text format.

I have to enter the data manually when it comes back.

[SirDice]

You could use a perl script for that. Run the script on your own server. Have the email received by the script. A nice regular expression should be enough for a YES/NO. You can use this same script to instantly update the database too. All automagicly :D