-
October 18th, 2004, 06:13 PM
#1
Access
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, 06:31 PM
#2
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
-
October 19th, 2004, 03:25 PM
#3
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, 04:01 PM
#4
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
Oliver's Law:
Experience is something you don't get until just after you need it.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|