Kamis, 04 Agustus 2016

Re: [MS_AccessPros] pass through query used to update Access table


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>



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];



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