|
| 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
October 6th, 2008, 04:16 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
Keep the current date in a field
I need to have a constant calculation of the days on market (DOM) for real
estate in a table as well as on a report. I can get the table to show the current date for new entries. But it will not stay "current". EX: enter a new listing today, the day automatically shows as the 6th. But tomorrow, instead of showing as the 7th, it still shows as the 6th. I need a column that will update to the current date every day. 
|
|
#2
October 6th, 2008, 04:54 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Keep the current date in a field
Use a form to show current date in an unbound text box.
-- KARL DEWEY Build a little - Test a little "Shannon" wrote: I need to have a constant calculation of the days on market (DOM) for real estate in a table as well as on a report. I can get the table to show the current date for new entries. But it will not stay "current". EX: enter a new listing today, the day automatically shows as the 6th. But tomorrow, instead of showing as the 7th, it still shows as the 6th. I need a column that will update to the current date every day.
|
|
#3
October 6th, 2008, 05:19 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Keep the current date in a field
Ok, how do I do that?
"KARL DEWEY" wrote: Use a form to show current date in an unbound text box. -- KARL DEWEY Build a little - Test a little "Shannon" wrote: I need to have a constant calculation of the days on market (DOM) for real estate in a table as well as on a report. I can get the table to show the current date for new entries. But it will not stay "current". EX: enter a new listing today, the day automatically shows as the 6th. But tomorrow, instead of showing as the 7th, it still shows as the 6th. I need a column that will update to the current date every day.
|
|
#4
October 6th, 2008, 06:14 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Keep the current date in a field
Open form in design view and set the source for the unbound text box =Date()
and that will do it. -- KARL DEWEY Build a little - Test a little "Shannon" wrote: Ok, how do I do that? "KARL DEWEY" wrote: Use a form to show current date in an unbound text box. -- KARL DEWEY Build a little - Test a little "Shannon" wrote: I need to have a constant calculation of the days on market (DOM) for real estate in a table as well as on a report. I can get the table to show the current date for new entries. But it will not stay "current". EX: enter a new listing today, the day automatically shows as the 6th. But tomorrow, instead of showing as the 7th, it still shows as the 6th. I need a column that will update to the current date every day.
|
|
#5
October 6th, 2008, 07:58 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Keep the current date in a field
OK I think I got it, we'll know tomorrow when the date does on doesn't
change. One thing; in my table I have the validation rule and the default value for my "Current Date" field set to Date(). Is that ok? Thanks for you help, hopefully I got it right. "KARL DEWEY" wrote: Open form in design view and set the source for the unbound text box =Date() and that will do it. -- KARL DEWEY Build a little - Test a little "Shannon" wrote: Ok, how do I do that? "KARL DEWEY" wrote: Use a form to show current date in an unbound text box. -- KARL DEWEY Build a little - Test a little "Shannon" wrote: I need to have a constant calculation of the days on market (DOM) for real estate in a table as well as on a report. I can get the table to show the current date for new entries. But it will not stay "current". EX: enter a new listing today, the day automatically shows as the 6th. But tomorrow, instead of showing as the 7th, it still shows as the 6th. I need a column that will update to the current date every day.
|
|
#6
October 6th, 2008, 08:13 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Keep the current date in a field
Ok how do I link the form and my current database table so that the results
appear in the table as fell as on the form "KARL DEWEY" wrote: Open form in design view and set the source for the unbound text box =Date() and that will do it. -- KARL DEWEY Build a little - Test a little "Shannon" wrote: Ok, how do I do that? "KARL DEWEY" wrote: Use a form to show current date in an unbound text box. -- KARL DEWEY Build a little - Test a little "Shannon" wrote: I need to have a constant calculation of the days on market (DOM) for real estate in a table as well as on a report. I can get the table to show the current date for new entries. But it will not stay "current". EX: enter a new listing today, the day automatically shows as the 6th. But tomorrow, instead of showing as the 7th, it still shows as the 6th. I need a column that will update to the current date every day.
|
|
#7
October 6th, 2008, 08:18 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Keep the current date in a field
You can not. That is why you use a form to always show the current date.
Maybe Excel is what you need. -- KARL DEWEY Build a little - Test a little "Shannon" wrote: Ok how do I link the form and my current database table so that the results appear in the table as fell as on the form "KARL DEWEY" wrote: Open form in design view and set the source for the unbound text box =Date() and that will do it. -- KARL DEWEY Build a little - Test a little "Shannon" wrote: Ok, how do I do that? "KARL DEWEY" wrote: Use a form to show current date in an unbound text box. -- KARL DEWEY Build a little - Test a little "Shannon" wrote: I need to have a constant calculation of the days on market (DOM) for real estate in a table as well as on a report. I can get the table to show the current date for new entries. But it will not stay "current". EX: enter a new listing today, the day automatically shows as the 6th. But tomorrow, instead of showing as the 7th, it still shows as the 6th. I need a column that will update to the current date every day.
|
|
#8
October 6th, 2008, 08:52 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Keep the current date in a field
Bummer.......but thanks for all your help
"KARL DEWEY" wrote: You can not. That is why you use a form to always show the current date. Maybe Excel is what you need. -- KARL DEWEY Build a little - Test a little "Shannon" wrote: Ok how do I link the form and my current database table so that the results appear in the table as fell as on the form "KARL DEWEY" wrote: Open form in design view and set the source for the unbound text box =Date() and that will do it. -- KARL DEWEY Build a little - Test a little "Shannon" wrote: Ok, how do I do that? "KARL DEWEY" wrote: Use a form to show current date in an unbound text box. -- KARL DEWEY Build a little - Test a little "Shannon" wrote: I need to have a constant calculation of the days on market (DOM) for real estate in a table as well as on a report. I can get the table to show the current date for new entries. But it will not stay "current". EX: enter a new listing today, the day automatically shows as the 6th. But tomorrow, instead of showing as the 7th, it still shows as the 6th. I need a column that will update to the current date every day.
|
|
#9
October 6th, 2008, 09:16 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Keep the current date in a field
Maybe if you explain your process a little more someone might suggest an
alternative solution. -- KARL DEWEY Build a little - Test a little "Shannon" wrote: Bummer.......but thanks for all your help "KARL DEWEY" wrote: You can not. That is why you use a form to always show the current date. Maybe Excel is what you need. -- KARL DEWEY Build a little - Test a little "Shannon" wrote: Ok how do I link the form and my current database table so that the results appear in the table as fell as on the form "KARL DEWEY" wrote: Open form in design view and set the source for the unbound text box =Date() and that will do it. -- KARL DEWEY Build a little - Test a little "Shannon" wrote: Ok, how do I do that? "KARL DEWEY" wrote: Use a form to show current date in an unbound text box. -- KARL DEWEY Build a little - Test a little "Shannon" wrote: I need to have a constant calculation of the days on market (DOM) for real estate in a table as well as on a report. I can get the table to show the current date for new entries. But it will not stay "current". EX: enter a new listing today, the day automatically shows as the 6th. But tomorrow, instead of showing as the 7th, it still shows as the 6th. I need a column that will update to the current date every day.
|
|
#10
October 9th, 2008, 01:30 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Keep the current date in a field
Shannon
if you like the data listed in a table type form, how about adding a query with all the fields of your table. open the query in design view and in an available "field" box put an expression like Days on Market: [Your_Realestate_table]![Date_listed?]-Date() "KARL DEWEY" wrote: Maybe if you explain your process a little more someone might suggest an alternative solution. -- KARL DEWEY Build a little - Test a little "Shannon" wrote: Bummer.......but thanks for all your help "KARL DEWEY" wrote: You can not. That is why you use a form to always show the current date. Maybe Excel is what you need. -- KARL DEWEY Build a little - Test a little "Shannon" wrote: Ok how do I link the form and my current database table so that the results appear in the table as fell as on the form "KARL DEWEY" wrote: Open form in design view and set the source for the unbound text box =Date() and that will do it. -- KARL DEWEY Build a little - Test a little "Shannon" wrote: Ok, how do I do that? "KARL DEWEY" wrote: Use a form to show current date in an unbound text box. -- KARL DEWEY Build a little - Test a little "Shannon" wrote: I need to have a constant calculation of the days on market (DOM) for real estate in a table as well as on a report. I can get the table to show the current date for new entries. But it will not stay "current". EX: enter a new listing today, the day automatically shows as the 6th. But tomorrow, instead of showing as the 7th, it still shows as the 6th. I need a column that will update to the current date every day.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
