oh and to prevent those records with 'null values' being recorded with a
current date, if the record is opened in the form to edit, I'd run and update
statement and plug a dummy date, my preference is 04/01/1900 (ie april fool's
long, long, time ago) and when I run queries I sometimes do 'where date=.vDate
or date='04/01/1900''...
----- Original Message -----
From: Rachael Malberg
To: RBASE-L Mailing List
Sent: Friday, February 27, 2009 10:11 AM
Subject: [RBASE-L] - Re: Help - select by date where date not column
again for FUTURE record entry
1 (click and drag) to add db edit field to the table's form
2 (douple click) to open the db edit fields properties
3 -set db edit field to the table's 'EnteredDate' field
4 - click the effects tab and enter in the default value ...
.#date
and then hit ESC to close properties
5 - right click
or sorry there are 6 clicks
6 - select hide on start up
and done save the form and everytime you enter a new record using that form,
that edit field is hidden but populates the field with date the record is
entered.
----- Original Message -----
From: James Bentley
To: RBASE-L Mailing List
Sent: Friday, February 27, 2009 9:07 AM
Subject: [RBASE-L] - Re: Help - select by date where date not column
Rachael,
Do tell. What are the steps?
Jim Bentley
American Celiac Society
[email protected]
tel: 1-504-737-3293
--- On Fri, 2/27/09, Rachael Malberg
<[email protected]> wrote:
From: Rachael Malberg <[email protected]>
Subject: [RBASE-L] - Re: Help - select by date where date not column
To: "RBASE-L Mailing List" <[email protected]>
Date: Friday, February 27, 2009, 9:01 AM
Hi Cathy!
As far as I know, if you did not capture a date at the time the
record was entered there isn't a way to get that 'date entered' for them. If
you are not collecting this yet and wish to for future records, with 7.6/V8 I
can do it in 5 mouse clicks.
----- Original Message -----
From: cfgrimes
To: RBASE-L Mailing List
Sent: Friday, February 27, 2009 7:46 AM
Subject: [RBASE-L] - Help - select by date where date not column
This group is way out of my league, so I hope this is an
acceptable question for you. I am an individual RBase user -not a programmer
and have only intermediate computer knowledge. Though I have used RBase since
early Dos days, my expertise/knowledge of this program is limited only to what
I needed to learn for my personal data entry, forms and reports. So I'm sure
98% of the complex programming you will be discussing here will be way over my
head, but thought it couldn't hurt to ask for help if I had a few questions. I
have the latest RBase version now.
Question.
Is there any way I can search for rows (or print out report)
in a database table by the actual date the row was entered if the table does
NOT have an autodate column to search by (i.e., does R:Base create a date
(hidden) for each row that is added or modified that is searchable)? I have
thousands of rows and didn't want to take space in the old days for autodate
column, and if I try to add now, will only get the same current date the column
is added (invalid for all previous entries).
Thank you in advance.
Cathy
Huntington Beach, Ca
