Access
Results 1 to 4 of 4

Thread: Access

  1. #1
    Senior Member Info Tech Geek's Avatar
    Join Date
    Jan 2003
    Location
    Vernon, CT
    Posts
    828

    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.

  2. #2
    Super Moderator: GMT Zone nihil's Avatar
    Join Date
    Jul 2003
    Location
    United Kingdom: Bridlington
    Posts
    17,191
    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
    If you cannot do someone any good: don't do them any harm....
    As long as you did this to one of these, the least of my little ones............you did it unto Me.
    What profiteth a man if he gains the entire World at the expense of his immortal soul?

  3. #3
    Senior Member Info Tech Geek's Avatar
    Join Date
    Jan 2003
    Location
    Vernon, CT
    Posts
    828
    No, I am using the send via mail in a text format.

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

  4. #4
    Just Another Geek
    Join Date
    Jul 2002
    Location
    Rotterdam, Netherlands
    Posts
    3,403
    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
  •