Auto Assign Times

[MTBChik]

Hi there,

I have a report that I have generated that needs to assign start times every 30 seconds automatically.

The basis is a report that I developed that would automatically number a position. So under detail I have a box called Start with the following properties: Control Source = CDATE$("00:00:30") which is assigning a start time every 30 seconds. This is great, except we aren't starting at midnight. How or where should I change the property so that it will assign start times every 30 seconds, say, starting at 10:00am?

Thanks!

__~o
`\<,
(_)/(_)
MTBChick
The day you stop riding is the day you die.

 

[Remou]

You could add another control and set the control source to:
[tt]=CDate("10:00:00") + [NameOfRunningSumControl][/tt]
You can then hide the running sum control.

PS Microsoft: Access Reports Forum
forum703

 

[MTBChik]

Lovely! Now I need to test it with 300 people and make sure it stays on track.

Muchas Gracias!

__~o
`\<,
(_)/(_)
MTBChick
The day you stop riding is the day you die.

 

[MTBChik]

Bummer! Loaded up my 500 starters and it choked...any other suggestions?

__~o
`\<,
(_)/(_)
MTBChick
The day you stop riding is the day you die.

 

[Remou]

What do you mean choked? Any error messages?
For my test I used a table with two fields and 500 entries. The table was built into a report and two additional fields were added:
[tt]=CDate("00:00:30") 'running sum: both Over All and
'Over Group were tested, name: txtRSum
=CDate("10:00:00")+[txtRSum][/tt]

The final line, record 500, showed:
[tt]04:10:00
14:10:00[/tt]
For the two fields.

 

[MTBChik]

Yeah, Error:

"The Value you entered isn't valid for this field.

For example, you may have entered text in a numeric field or a number that is larger than the FieldSize setting."

I'm using a combo box in my data input form to select the state and when I try to use the combo box on the form, that's when the choking was happening. If I leave it as a text box, it shows State as 01, or 49 instead of the actual name....

The next hurdle.

All else seems to be cool with that eliminated.


__~o
`\<,
(_)/(_)
MTBChick
The day you stop riding is the day you die.

 

[Remou]

What you need is a combo box with two columns. It is best that you use the combo box wizard to build it. It also seems to me that if you have a state that is 01, it is quite likely that this is text, not numeric, and needs to be quoted. It is best that you post the code that that is highlighted by the error.