Sausagefingers
Registered User.
- Local time
- Today, 13:22
- Joined
- Dec 14, 2006
- Messages
- 51
Hi,
I need to find a simple and efficient way to log past transactions into our database. Our deliveries can be anything from one day up to a week old before transaction data (including actual dates) is recorded. As we log in excess of 275 records a day, I'm hoping to save a few keystrokes by being able to set an arbitrary date (within the above parameters) on the form and have each new record added use the set date automatically.
Currently, our input form uses the MS OLE Calendar class (MSCAL.Calendar.7 in Access 2000) however, our database ops find it a somewhat cumbersome and sometimes inaccurate method of inputting past dates. I tend to agree in this case as speed is of the essence.
I'm working on a simple fix that would use an unbound combo box with a value list containing days up to one week in arrears.
The basic If statement in vb might look something like this:
If Forms!frm_deliveryTransactions!ammendDateBy = "2 DAYS AGO" Then
Forms!frm_deliveryTransactions!ammendedBy = date - 2
...and so on and so forth.
This works as expected but only on a per record basis. I really need to have this date carry forward to each new record until a new date is set via the combo.
Has anyone a vb code snippet or example db which can demonstrate the use of such a technique?
Any help would be greatly appreciated...I seem to be beating my head against a brick wall today
/
Thanks In Advance
I need to find a simple and efficient way to log past transactions into our database. Our deliveries can be anything from one day up to a week old before transaction data (including actual dates) is recorded. As we log in excess of 275 records a day, I'm hoping to save a few keystrokes by being able to set an arbitrary date (within the above parameters) on the form and have each new record added use the set date automatically.
Currently, our input form uses the MS OLE Calendar class (MSCAL.Calendar.7 in Access 2000) however, our database ops find it a somewhat cumbersome and sometimes inaccurate method of inputting past dates. I tend to agree in this case as speed is of the essence.
I'm working on a simple fix that would use an unbound combo box with a value list containing days up to one week in arrears.
The basic If statement in vb might look something like this:
If Forms!frm_deliveryTransactions!ammendDateBy = "2 DAYS AGO" Then
Forms!frm_deliveryTransactions!ammendedBy = date - 2
...and so on and so forth.
This works as expected but only on a per record basis. I really need to have this date carry forward to each new record until a new date is set via the combo.
Has anyone a vb code snippet or example db which can demonstrate the use of such a technique?
Any help would be greatly appreciated...I seem to be beating my head against a brick wall today
/Thanks In Advance
