A pass-through query isn't updateable. Any Access query containing a non-updateable query won't allow updates.
_____________________________
From: Liz Ravenwood liz_ravenwood@beaerospace.com [MS_Access_Professionals] <ms_access_professionals@yahoogroups.com>
Sent: Thursday, August 4, 2016 19:43
Subject: [MS_AccessPros] pass through query used to update Access table
To: <ms_access_professionals@yahoogroups.com>
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
From: Liz Ravenwood liz_ravenwood@beaerospace.com [MS_Access_Professionals] <ms_access_professionals@yahoogroups.com>
Sent: Thursday, August 4, 2016 19:43
Subject: [MS_AccessPros] pass through query used to update Access table
To: <ms_access_professionals@yahoogroups.com>
Pros,
I guess this is not an updateable query then? (where pt is the passthrough query and wodepartments is an access table)
UPDATE ptWIP INNER JOIN WODepartments ON ptWIP.OrderNum = WODepartments.WODep SET WODepartments.RequestedCompletionDate = [ptWIP]![RequestDate];
Respectfully,
Liz Ravenwood
Programmer / Analyst
B/E Aerospace|Super First Class Environments
1851 S Pantano Road |Tucson, Arizona 85710
Office +1.520.239.4808| Internal 814-4808
Passion to Innovate. Power to Deliver
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
__._,_.___
Posted by: Duane Hookom <duanehookom@hotmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
Save time and get your email on the go with the Yahoo Mail app
Get the beautifully designed, lighting fast, and easy-to-use Yahoo Mail today. Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.
.
__,_._,___
Tidak ada komentar:
Posting Komentar