Editting data from a Query

[Paranap]

Hello



I have a query which shows a list of training completed but haven't been checked off so this list is for people to check that they are happy they did training. There is a field in the table called confirmation which is a check box and the query is looking at all the records where confirmation is false. I was hoping to run the query then people can click the confirmation box and then update the table. Being new to Access didn't realise standard queries can't update tables.
Any ideas how I can get round that.

Thank you

Neil

[ranman256]

Yes, a 'standard' query WILL update tables. (select query?)
If you have a single table with the boolean field, it will update live, as soon as the person marks it.

If you cant update it, then you may have a join with 2 tables that wont allow it. Simplify the query.

[rpeare]

Typically for a query to be updatable it has to have a RIGHT JOIN or LEFT JOIN (in other words the arrow pointing from one table to another has an arrow on it) and you have to be linking the tables based on a primary key. If you can show a screen shot of your query design that's a starting point.

Also, if you are running any type of aggregate query (the TOTALS line in the query design window is showing) the query will never be updatable.

[Paranap]

As you can see my query does link two tables but the data that is being updated is for the one table. The only reason I need the operative table is to filter so only the current users detatils come up.

[ItsMe]

Perhaps the field HARTFacilitator is not Indexed. Also, why not store the user ID in a Global Variable or in a control within your main menu form?

[Paranap]

The getusername is a global moduale which pulls up the username they are using on the work computer they are on. That then matches the username field in the table which is the only reason I need that second table.

[Paranap]

The getusername is a global moduale which pulls up the username they are using on the work computer they are on. That then matches the username field in the table which is the only reason I need that second table.

[Paranap]

I have just tried it by taking out the relationship between Payroll and the HARTfacililator which then allows me to edit the table thank you.