Search results

Insert your records into a new table with an autonumber field and select from that and include the field.

You'd think that you could just have a query like this: select a.first, a.lastname, b.destination from table_one a, table_two b where a.destination_id = b.ID but as you've discovered, Access gets funny about this. You need to include the primary key from both tables in your query (even if...

This problem is often caused by the record sources not being updatable. Have a look here: http://allenbrowne.com/casu-20.html

From the record list you provided, you could use two queries to get what you require. 1. select the records into a temp table with an autonumber field ordered by their account number, then your priority list. You can't simply use the job title field because this will order the records...

Not sure exactly what you're getting at from your description (post your query), but one of the following scenarios may solve your problem; 1. You can replace a field with something else using iif(expression, show if true, show if false) eg. iif(phone_number = '' or phone_number is null, 'na'...

Thanks for your help Bob and Scooterbug. I think have this resolved now. The data source query was 'incorrect'. In terms of a query that returned the data needed, it was fine. However, as a query that will allow the recordset to be updateable it required the b.patient_cycle_pk field to work...

Thanks Bob, a useful site. Unfortunately none of the issues identified in the list apply to my query. It is updateable without the timestamp field, so somehow it's this that is preventing the updates but I'm not sure why. Is there anything further you or anyone else can suggest??

The main form uses the patient table as its data source - this table is not used in the subform data source query. The subform child field is the patient_fk field, the main form master field is the patient_pk from the patient table. I can add records when the timestamp field is omitted from...

The subform relates to the main form using patient_fk. This works fine, and updates the subform data based on the patient selected in the main form. I think the query is okay - at least it returns the correct data. Whether it's correct in terms of what Access requires to make the form...

Thanks for taking an interest... Ok, makes sense. However, I still have the issue of the recordset not being updateable. How do I overcome this? I started playing around with sql server functions, but figured there must be an easier way. Any ideas? because I have to admit I'm stumped...

Hi, I have an Access 2003 project front end on SQL Server 2008 back end. I have a form containing patient data which has a subform containing data about when an examination was performed for the cycle of treatment for the current patient. The subform (the problem form) has a data source as...