Too much access for past weeks?

E

elli

Hi there, If some of You might have noticed, I've been asking You questions
daily over past week. And Thank You once again, for answering me simply and
kindly.
Today I have struggled with a simple queestion, but can't figure out how to
do it.

I have a table and a query based on that table +one extra field (boolean).
How do I make the query uppdate the records marked with the boolean (Yes
/-1) to the table.

And when updated, none, some or many fields will change and one field
(Inventory) needs to be updated to date as =Now() even if no changes are
being done.

Probably very simple to accomplish, but I think I need a day off from my
databases and relationships and other stuff..
Anyone to point me into right direction....

Thank You

-elli-
 
E

Ed Robichaud

You may have a basic misunderstanding here. Access does opportunistic
record saving, so without an unbound form (and forms are where all data
entry should be done BTW) that has some code to handle your criteria, this
isn't going to happen. In normal bound forms, any changed data is saved
(and remember your query is just another dynaset of your table, so any
changes made in the query are also made to the underlying table) whenever
you move to another control/field, and/or move to another record, etc.

A typical stradagy to capture when a record changes, is to have a date field
ands change its value by code (like: Me!myDate=Date()) triggered by the
form's AfterUpdate event.

BTW, Date() gives you the system date; Now() gives the current date and
time.

-Ed
 
Top