ACCESS FEED: RE: [MS_AccessPros] pass through query used to update Access table

Jumat, 05 Agustus 2016

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

Thanks. I found another way to do my process. Have a beautiful weekend all!

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Thursday, August 04, 2016 1:50 PM
To: ms_access_professionals@yahoogroups.com
Subject: 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.

Get Outlook for iOS

_____________________________
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

beaerospace.com

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.