| | |
|
|
|
Browse through record at opening |
|---|
| message from Antonio on 10 May 2004 |
Hello, everybody. Here's what I am trying to do: when a
user opens the database, I would like it to go through all
the record and put a checkmark in a Inactive account
checkbox if the subscription date is < 0. Can somebody
help me? thanks. Antonio
|
| Joseph Meehan replied to Antonio on 10 May 2004 |
Let access do that for you, don't bother with doing that kind of thing
manually. A update query which runs automatically when the database is
opened would do it.
|
| Douglas J. Steele replied to Antonio on 10 May 2004 |
Write an Update query that sets the Inactive Account field to True when the
subscription date is < 0 (whatever that means), and run the query when you
open the database.
It's seldom ever better to loop through a recordset when a single SQL
statement can do the same thing.
|
| Antonio replied to Douglas J. Steele on 10 May 2004 |
Doug, thank you for your time, but the field that's
checked it's unbound...it's the difference of the
subscription setup date and the subscription expiration
date. That's why I was going to put a code to run at db
opening. Antonio
field to True when the
the query when you
a single SQL
|
| Douglas J. Steele replied to Antonio on 10 May 2004 |
The query can calculate the difference, using DateDiff and the Date
function.
|
|
Archived message: Browse through record at opening (MS Access)
