Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

forms

ResolvedVersion 2003

Salina has attended:
Access Introduction course

Forms

can anyone update a form if it is emailed to them- will this automatically updat hte table?

RE: forms - Collecting data remotely!!

Dear Salina

Thank you for attending Access 2003 Introduction course. I hope you enjoyed the training and benefited from it. Sorry for getting back to you with regards to your query.

In 2007 Microsoft has built this facility to send forms via e-mail and collect the information so that you can update the table once the users fill in the forms.

But with previous versions there is some code required which can get bit too much technical.

However there is a Add in that you can install on your computer which will help you to assist in achieving your goal.

Please go to the following link and download this 30 day trial application and then may be if you benefit from it then your company may decide to purchase the software!!

(You just need to copy and paste the link on your internet explorer or any other browser)

http://www.download.com/Easy-Survey/3000-2650_4-10257909.html?tag=lst-1& ;cdlPid=10549641

If you require any extra support please reply to this post and we should be able to assist you!!

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!


Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003

Access tip:

Random sampling

Data is th key to a good database, therefore checking is essential.

A good way of checking data is by random sampling. You can do this in a query, by typing the follow:
1) In the Field box create a RandonID field eg. Randon Id: Rnd(fieldname])

2) sort the field
3)Right click and chage the properties for To value to be the number of randon records you want to see.

4) Change the set to Show row for Randon ID to be False, add all the other fields you want to see and the run the query.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.