If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Too much access for past weeks?
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- |
#2
|
|||
|
|||
Too much access for past weeks?
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 "elli" wrote in message ... 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- |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Calculating no of weeks in access and flag recor if no of weeks is | MitziUK | New Users | 8 | September 30th, 2005 11:44 PM |
2002 vs 2003 | Patrick Stubbin | General Discussion | 2 | May 17th, 2005 07:27 AM |
The "Right" web hosting for data access pages?? | Ron Ehrlich | General Discussion | 9 | May 6th, 2005 05:49 AM |
How to stop opening of multiple instance of Access 2000 after upd. | Taika Bilbo | Database Design | 9 | January 12th, 2005 08:34 PM |
You do not have exclusive access... ERROR | Robin | General Discussion | 1 | July 6th, 2004 01:18 AM |