Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Forms

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Forms

Resolved · Low Priority · Version 2003

Reply Mon 14 Apr 2008, 16:47Delegate Salina said...

Salina has attended:
Access Introduction course

Forms

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

For upcoming training course dates see: Pricing & availability

Reply Mon 2 Jun 2008, 11:33Trainer Rajeev said...

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 articles

· How To Change The Data Displayed In A Linked Field In An Access Table
· The Easy Way To Get Started With Access
· Share And Share Alike With Microsoft Access 2010
· MS Access and Database Normalisation
· Use Microsoft Access to manage your work/life balance

Please browse our web site to find out more about
access vba courses and other Microsoft training courses.

Access tip:

Choosing data types in Access

Not sure which data type to use for your Access fields? Here are some guidelines to help you choose a data type to assign to a field.

- The Text data type can accept up to 255 characters. For information that will be recorded in paragraphs, use Memo.

- Also use Text for numbers that aren't going to be used in calculations, e.g. phone numbers.

- Use the Currency data type for monetary amounts.

- Use Date/Time for dates.

- Most other numbers can use the Number data type, but the Field Size property may have to be altered.

- For fields that have only two alternatives (yes, no) use Yes/No data type. If there is likely to be a third entry option (e.g. maybe or don't know) use Text instead.

View all Access hints and tips