access 2003 training course london - Query criteria

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

Resolved · Low Priority · Version Standard

Query criteria

Sinéad has attended:
Access Intermediate course
Access Advanced course
Access VBA course

by - delegate Sinéad [15 posts] (2007 Jun 6 Wed, 10:19) Reply

I set up a LIKE criteria on a query whihc allowed my users to search for a specific organisation and then based a form on it. The form and the criteria worked beautifully bringing up the record needed and then I discovered that no one can acutally edit the data! It seems that if you add a criteria to a query the data no longer becomes editable when you use a form to access it.
Is this true? - if so it would be helpful to mention it in your courses. If not, what am I doing wrong?

Version	Date	Location	Places available	Book	Next place rate:
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Nov 25 Tue	Bloomsbury	4	book now	£207	£215
2002/XP	2008 Nov 26 Wed	Tooting	0	FULL
2003	2008 Dec 2 Tue	Southwark	5	book now	£198	£215
2007	2008 Dec 5 Fri	Bloomsbury	4	book now	£224	£224
2003	2008 Dec 9 Tue	Bloomsbury	0	FULL
2002/XP	2008 Dec 11 Thu	Tooting	0	FULL
Full Schedule: See all 55 Access Intermediate course dates. Bookings currently available until 24th November 2009.

RE: Query criteria

by - trainer Richard platinum contributer [818 posts] (2007 Jun 8 Fri, 09:57) Reply

Hi

I created a basic table with a query like yours, and then based a form on that query. The data seems to be editable.

How did you create the form with the criteria? VBA/macro/command button?

Have you checked the edit properties in the form properties?

Regards

Richard

RE: Query criteria

by - delegate Sinéad [15 posts] (2007 Jul 19 Thu, 13:09) Reply

Hello,
Yes I recreated from scratch and this time it worked! - which leads me to the next problem:

Query 1 with criteria - editable
Query 2 - editable
but when I then add a field from Query 1 to Query 2, the data ceases to be editable. Do you think this is a relationship issue?

· Microsoft Access Cheat Sheet: Tips and Shortcuts
· Microsoft Access: Unleash the True Potential Today
· Microsoft Access 2007: New Features
· Turning your Spreadsheets into Interactive Data Warehouses with MS Access Courses
· MS Access and Database Normalisation

Access tip:

Copy a Previous Record's Values to a New Record

If you often enter the same value in one field of a table, there are two methods to save re-typing the data.

1. Use Ctrl+' (apostrophe) to repeat the value input in the previous record.

2. Change the field's DefaultValue property in Design View to the most commonly used value.

View all Access hints and tips