akhenaton42
Last Activity: Jul 13 '07, 04:20 PM
Joined: Sep 18 '06
Location:
-
If this issue is still not resovled I wrote up a quick sample database to show you what I mean, hopefully it should help. if you want it give me your email address and I'll send it to you... -
What does your form display? The idea behind this was that if your form displays a unique id for the workorder you can pick it out by doing [forms]![nameofyourform]![nameoftextboxdi splayingid].value...Leave a comment:
-
try this idea:
supposing you are viewing your workorders in a form called frmOpenWorkOrde r
build two queries one append query and one delete query
Append query: qMove2ClosedWor kOrder
INSERT INTO tableC
SELECT *
FROM tableB
where tableB.id = [forms].[frmOpenWorkOrde r].[id]
Delete query: qRemoveFromOpen WorkOrder
DELETE [id]
FROM tableB
where...Leave a comment:
-
use IIF statement -
Expr1:IIF([FrameLgt]>=3.2,[FrameLgt]*[SteelRate],[write here whatever you want returned])...Leave a comment:
-
use keywords NOT and AND
SELECT studentname, wordclass, powerpointclass
FROM students
WHERE Not powerpointclass ="completed" AND wordclass="comp leted";Leave a comment:
No activity results to display
Leave a comment: