Entering Data on a form

The UK's most regular instructor-led training courses.
Training information: 2002 access online training · Microsoft.access.courses · Microsoft Access Training London
See also · microsoft access training · access vba courses · access database course

Resolved · Urgent Priority · Version 2003

3 posts

ReplyFri 23 Oct 2009, 10:53Delegate Suzanne said...

Suzanne has attended:
Access Intermediate course

Entering Data on a form

My Form has been locked and I do not know how to unlock it, Also my form is not pulling through the new information that I am entering onto my table?
I would appreciate an urgent answer as I need to present my database on Monday.

Thanks.

Version	Date	Location	Places available	Book	Next place rate (£)
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2007	Tue 23 Mar 2010	Bloomsbury	3		£224	£225
2003	Tue 30 Mar 2010	Bloomsbury	6		£199	£204
2003	Thu 22 Apr 2010	Southwark	5		£195	£200
2007	Tue 27 Apr 2010	Bloomsbury	4		£224	£225
2003	Fri 28 May 2010	Bloomsbury	9		£156	£161
2003	Wed 16 Jun 2010	Bloomsbury	8		£95	£100
Full Schedule: See all 20 Access Intermediate course dates. Bookings currently available until 17th December 2010.

748 posts

ReplyFri 23 Oct 2009, 12:54Trainer Stephen said...

RE: Entering Data on a form

Hi Suzanne

Thanks for your question

Some initial things to check.

Open your form in design view and bring up the properties sheet, making sure that you have the form selected.

1. Check that the Allow Edits, Allow Deletions and Allow additions properties are all set to yes.
2. Check that the record source property is naming the correct table
2. Then select each control in turn and check that the locked property for the control is no and the enabled property is yes.

If this doesn't solve the problem, please follow up and we can explore other options

Regards

Stephen

· So what's new in Access 2007?
· Microsoft Access Mistakes to Avoid
· When Is Microsoft Access Not The Best Choice For Your Business?
· Take an Access Course to Learn About Relational Databases
· Sub-reports And Sub-forms In Access 2007

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

Access tip:

Splittng a database

Split your database into two (at least).

Keep all of your code, forms, reports, etc. in one 'code' database and all of your tables in another 'data' database which is then linked to the 'code' database.

This makes modifications, updates and back-ups that much easier and allows you to work on a new version of your 'code' database without affecting existing users. It also makes it easier should you wish to convert a single user databases into a multi-user networked version.

View all Access hints and tips