October 18th, 2004, 07:13 PM
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.
October 18th, 2004, 07:31 PM
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
October 19th, 2004, 04:25 PM
No, I am using the send via mail in a text format.
I have to enter the data manually when it comes back.
October 19th, 2004, 05:01 PM
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
Experience is something you don't get until just after you need it.