943,569 Members | Top Members by Rank

Ad:
Oct 10th, 2008
0

ms access database form

Expand Post »
Hello Friends,

I am a student. I have to complete a project and would like to learn few things from all you experts on ms access.

I have to make a personal contact directory with id, date, name, address, phone, email and photo.

To feed data, I have to make a form that is to be sent to all my contacts. They should fill it up and send me back as attachment file through yahoo, gmail or any webmail.

I should save all those attachment files into a particular folder in my computer.

My personal contact directory in ms access should update itself using all the files from that particular folder and remove the older data with new one if the ID is same and Date is new.

Please let know the solution if it is possible in ms access 2000 or 2007.

Thanks a lot for your advice,
Kind regards,
dk
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
dk71in is offline Offline
3 posts
since Oct 2008
Oct 10th, 2008
0

Re: ms access database form

This is certainly possible; however I do have a few questions. Does your database support contacts having more than one address, phone, e-mail and photo? Secondly, what type of form will you send around (Access form, Excel Spreadsheet, text file)?

If you send out an access database, then they need access in order to fill out the form; you are able to download the trial version of access, which will work, but I'm not sure how comfortable others would feel about downloading it just to fill out your form. You could have them supply all their information in just a text document and sent a picture with a specific name to you.

Lastly, Microsoft does sell a product called InfoPath that is supposed to be able to handle what you are doing; I haven't used it though, so I'm not sure I can be much help with it.

What you are trying to do is certainly possible; it just depends on how you want to go about doing it.
Reputation Points: 27
Solved Threads: 29
Posting Whiz
timothybard is offline Offline
317 posts
since Mar 2007
Oct 10th, 2008
0

Re: ms access database form

Thanks a lot for your reply.

Yes, all my contacts have ms access. The form should be made in ms access. I will send them the same as attachment by email and they will fill it and send me back again as attachment.

The important thing is that how I will merge all those attachments in my main database.

Thanks for your advice.

Regards,
Dinesh
Reputation Points: 10
Solved Threads: 0
Newbie Poster
dk71in is offline Offline
3 posts
since Oct 2008
Oct 11th, 2008
0

Re: ms access database form

You can write code to link a tables from your database to the databases they send back. Just save the databases in a directory, loop through the directory and relink the tables to each database.

Let me know if you need specifics.
Reputation Points: 27
Solved Threads: 29
Posting Whiz
timothybard is offline Offline
317 posts
since Mar 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in MS Access and FileMaker Pro Forum Timeline: Controls on a form.
Next Thread in MS Access and FileMaker Pro Forum Timeline: ms access database to sql server





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC