Search results

I can add and edit just fine from the query and it updates the original tables. Just delete doesn't work.

I have a query based on two tables, joined on one field (this field is the primary key in Table A. Table B doesn't have a primary key). When working inside this query, it gives me the option to delete records. However, when I try, the row disappears from the query but then if I save and close...

I have a macro that, when run, performs the following operations: a) Empties out an existing table b) Uses Application.ImportXML to pull in new data from an XML file c) Uses the following SQL to add a new column DoCmd.RunSQL "ALTER TABLE sampling ADD COLUMN PartStep TEXT;" d) Here's where I'm...

I modified table A so that First and Last are in two separate columns just like table B. And then I built a query and joined First to First and Last to Last. Is this what you were suggesting with "You say you can't change table B, but you should then change table A so that the names are split...

Bob, To expand on that.... Are you referring to using a form when you're talking about an unbound control? I was only referring to updating the query in datasheet view--no forms involved.

Bob, Could you please expand on that. I don't understand.

Table A has a field for Full Name (Bob Jones) Table B has two separate fields for first and last (Bob and Jones). Table B's contents are actually based on an XML import so I can not just change the table structure. I want to join the content from these two tables together based on full name...