RE: Increase time by set number of minutes

PLEASE IF ANYONE CAN HELP. I AM UNDER A DEADLINE.
THANK YOU!

"S" wrote:

I should mention - all entries are already entered into the database. I then
group them together by catagory and then manually assign it a catagory
number, an awards ceremony, and then an entry number.

I am not looking for it to automatically input the time when adding a new
record but instead fill in the time of entries already in the database when I
set a start time for each catagory or ceremony.



"TC Blue Boy" wrote:

Assume that you have a table with the time field defined as follows:
Field Name Data Type
EntryTime Date/Time - With Format of "Medium Time"

Also the Form has the EntryTime field on it but not updateable by the user.
Then create a "BeforeUpdate" event like so:

Private Sub Form_BeforeUpdate(Cancel As Integer)
Dim datLastTime As Date

If Form.NewRecord Then
If DCount("EntryTime", "Table1") > 0 Then
datLastTime = DMax("EntryTime", "Table1")
EntryTime = DateAdd("n", 4, datLastTime)
End If
End If
End Sub

This should do it.

==============================

"S" wrote:

I have created a database for running a competition.
I am now trying to automate making a schedule.
I am looking for access to input the time for each record for me to create a
schedule.

Say entry # 001 starts at 8:00AM and each entry is 4 minutes long.
how do i get access to automatically go to entry 002 and fill in the time as
8:04AM
entry 003 as 8:08AM etc etc.
.

Relevant Pages

  • RE: Increase time by set number of minutes
    ... I call the table you wanna update yourtable where I assume there's a field ... group them together by catagory and then manually assign it a catagory ... number, an awards ceremony, and then an entry number. ... I am now trying to automate making a schedule. ...
    (microsoft.public.access.modulesdaovba)
  • RE: Increase time by set number of minutes
    ... I have all the information including catagory numbers already filled in. ... I call the table you wanna update yourtable where I assume there's a field ... number, an awards ceremony, and then an entry number. ... I am now trying to automate making a schedule. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Assign Number Automatically
    ... If you wish to assign an incrementing number as the record is created that can be done as shown here: ... Update button to sort the records by catagory #. ... automtically update the Entry # to 002. ...
    (microsoft.public.access.modulesdaovba)
  • RE: Increase time by set number of minutes
    ... So I would like it to find the first entry # in Session 1. ... Then prompt me for a Time to start the session. ... If I'm not 'nuff clear post the structure of the table you wanna update so ... I have all the information including catagory numbers already filled in. ...
    (microsoft.public.access.modulesdaovba)
  • RE: Increase time by set number of minutes
    ... I should mention - all entries are already entered into the database. ... group them together by catagory and then manually assign it a catagory ... I am now trying to automate making a schedule. ...
    (microsoft.public.access.modulesdaovba)