Forum home » Delegate support and help forum » Microsoft Access Training and help » access courses - Query with criteria using in another query

	98.1 % recommend us
	More live stats...

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

Training information:

access courses - Query with criteria using in another query

Resolved · Low Priority · Version Standard

Reply Fri 20 Jul 2007, 13:58Delegate Sin said...

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

Query with criteria using in another query

Hello,

I have the following problem:

Query 1 with criteria - editable data
Query 2 - editable data

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?

For upcoming training course dates see: Pricing & availability

Reply Mon 30 Jul 2007, 12:00Trainer Richard said...

RE: Query with criteria using in another query

Hi Sin

Access articles

· Access And Its Uses On The Web
· Microsoft Access Tighten your Security Controls
· How To Import Data Easily Into Access 2010
· Access VBA Training Adds Power to your Databases
· The Three Classes of Databases

Access tip:

Hide Access Tables

One method of stopping your Access tables appearing in Database window, is to rename the table(s) with the prefix usys.

This converts the table into a system object, which cannot be viewed in the Database window.

You can show system objects in the Database window by the following:

Step 1: On the Tools menu, click Options.
Step 2: Click the View tab.
Under Show, select the System Objects check box.
Click OK.

View all Access hints and tips

All prices offered for business users and exclude VAT. E&OE · Terms & conditions · Privacy policy