[AccessD] Update Query Problem in Access 2000 ADP

Liam Meadows liam at energyexhausts.co.uk
Mon Jul 28 10:58:07 CDT 2003


Sorry to appear daft but what is BOL ?
 
This was the old Access code
 
UPDATE TBLstock INNER JOIN ViewPOLNTGrouped ON TBLstock.Partnumber =
ViewPOLNTGrouped.Partnumber SET TBLstock.OnOrderQty =
[TBLstock]![OnOrderQty]+[ViewPOLNTGrouped]![POQty]
WHERE (((ViewPOLNTGrouped.POTransfered)=False));

 
How do you use stored procedures ?
 
Regards
 
Liam

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Susan Geller
Sent: 28 July 2003 16:35
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Update Query Problem in Access 2000 ADP


I would execute a stored procedure to do that.  The SQL in the sproc
would be similar to an update query in access.  Looks in BOL for a
sample of a SQL server update query.  Let me know if you don't know how
to execute a sproc from your adp.
 
--Susan
 

-----Original Message-----
From: Liam Meadows [mailto:liam at energyexhausts.co.uk] 
Sent: Monday, July 28, 2003 4:58 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Update Query Problem in Access 2000 ADP


Its not the view I want to update but use the views grouped value to
update the stock table
 
How would you update a field in one table based on a field in another
linked by partnumber. ?
( Not as simple as access update query)
 
So TBLstock.OnorderQty.value = VIEW1.TotalQty.value +
TBLstock.OnorderQty.value with join of Partnumber
(Above ref only).
 
 
Liam

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Arthur Fuller
Sent: 25 July 2003 06:58
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Update Query Problem in Access 2000 ADP


AFAIK you cannot update such a view from an ADP file. Since it is
grouped the best you can do (with work) is update the GroupBy fields. Of
course you can do it behind the scenes with a SQL statement but not from
the form. It will take executing an update query.
 
Arthur
 
 -----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Liam Meadows
Sent: July 24, 2003 2:21 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Update Query Problem in Access 2000 ADP



Is there anyway around the problem I have in ADP update queries. I
suppose I have been to use to Access MDB's but I am having problems
trying to update a field from another field.

Firstly I have a view (VIEW1) which is a grouped query listing
partnumbers and an onorder qty total 
VIEW1 
         Partnumber 
         POQTY 

I want to update the stockfile onorder qty by onorder qty+poqty 

STOCK 
         Partnumber 
         OnOrderQty = OnOrderQty+ View1POQty 

Can anyone assist ???? 

Liam 

-------------- next part --------------
A non-text attachment was scrubbed...
Name: winmail.dat
Type: application/ms-tnef
Size: 8098 bytes
Desc: not available
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030728/e408b793/attachment-0001.bin>


More information about the AccessD mailing list