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
|
|||
|
|||
automatic entry of previous record
My data base is a record of bank deposits by date. I update the table using a
form and I would like to automatically enter the next date by adding one day to the previous record upon new record creation. Is ther an easy way to do this ?? |
#2
|
|||
|
|||
automatic entry of previous record
Not sure what the definition of easy is, but try this:
Declare a variable that is public to your form: Public LastDate as Date Then in the BeforeUpdate event set that variable to the value of the date field. Then in the OnCurrent event: If IsNull(LastDate) or LastDate="" Then Exit Sub Else YourDateField.value = LastDate EndIf Let me know if it works ... Bill wrote: My data base is a record of bank deposits by date. I update the table using a form and I would like to automatically enter the next date by adding one day to the previous record upon new record creation. Is ther an easy way to do this ?? -- Message posted via http://www.accessmonster.com |
#3
|
|||
|
|||
automatic entry of previous record
How many entries do you make in a day? You might be able to set the Default
Value property of the text box to something like: =DMax("[Date Field]","tblNoNameProvided") + 1 -- Duane Hookom Microsoft Access MVP "Bill" wrote: My data base is a record of bank deposits by date. I update the table using a form and I would like to automatically enter the next date by adding one day to the previous record upon new record creation. Is ther an easy way to do this ?? |
Thread Tools | |
Display Modes | |
|
|