WOW! THIS GROUP IS AMAZING!! Thank you all so much for taking the time to
offer suggestions. The more I think about it, starting this capability now is
really all I need (actually 1 month ago would have been perfect, but this will
definitely do). I will go over Karen, Rachael and Emmitt's suggestions to see
which would be best/easiest for me. It's actually ok if the new autodate
column updates every time I edit for my purposes. My full report is well over
200 pages (even at 7-8 point fonts), so I print out supplemental reports
inbetween which (hopefully) only includes any rows that I have added or made
changes to after my last report printout.
Dennis' suggestion is intriguing, but mostly over my head, and I do not have
another table in this database that has the dates I need. I received a
delightully funny private response from Bruce, so all-in-all, this the people
in this Forum have not only been helpful, but entertaining as well - and this
is only my first day joining! THANK YOU!
I am concerned about James' caution if I create a new .#DATE column, then have
to use RELOAD and RESTORE, which would reset all the dates? Is there any way
around that? I have been backing up my databases only by backing up the 4
files, but if I do unload at some future point, would be nice to keep the dates
the way they are.
THANK YOU ALL AGAIN!
Cathy Grimes
----- Original Message -----
From: Rachael Malberg
To: RBASE-L Mailing List
Sent: Friday, February 27, 2009 8:19 AM
Subject: [RBASE-L] - Re: Help - select by date where date not column
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
