Append queries...

[h3llz]

INSERT INTO tblProductsLog ( staffID, productID, [timestamp], quantity )
VALUES ([staffID], [productID], now(), -[quantity]);

i got that in a query, but when i use DoCmd.OpenQuery it asks me for
variables which is already set before i execute it, therefore i need to do
the query some other way? please help :<

 

[Stefan Hoffmann]

hi,

INSERT INTO tblProductsLog ( staffID, productID, [timestamp], quantity )
VALUES ([staffID], [productID], now(), -[quantity]);

i got that in a query, but when i use DoCmd.OpenQuery it asks me for
variables which is already set before i execute it, therefore i need to do
the query some other way? please help :<

You cannot set parameters for query when using DoCmd.OpenQuery. You need
to use a QueryDef object for that, e.g. something like that:

Dim qd As DAO.QueryDef

Set qd = CurrentDb.QueryDefs.Item("nameOfYourQuery")
qd.Parameters.Item(<NameOrIndex>).Value = <yourValue>
qd.Execute
Set qd = Nothing


mfG
--> stefan <--