I'm glad we could stimulate "The little grey cells" as Hercule Poirot would say!
Dennis McGrath ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of cfgrimes Sent: Friday, February 27, 2009 10:51 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Help - select by date where date not column 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<mailto:[email protected]> To: RBASE-L Mailing List<mailto:[email protected]> 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<mailto:[email protected]> To: RBASE-L Mailing List<mailto:[email protected]> 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<mailto:[email protected]> To: RBASE-L Mailing List<mailto:[email protected]> 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]<mailto:[email protected]> tel: 1-504-737-3293 --- On Fri, 2/27/09, Rachael Malberg <[email protected]<mailto:[email protected]>> wrote: From: Rachael Malberg <[email protected]<mailto:[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<mailto:[email protected]> To: RBASE-L Mailing List<mailto:[email protected]> 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
