adding times to autofill a field VBA MSAccess

Question

I am making a booking system on MSAccess using VBA. On my form I have fields for creating a new booking which is then to be added to a database on SQL server. I have a combo box set up to allow the user to select and activity and it then fills out the ID of the activity and the duration of the activity. This duration is a number 1 or 2 or 3 etc for how many hours the activity takes.

However my question relates to calculating a finish time for the user. I wish the finish time textbox to be auto filled out when the user selects a start time from a list of times for example, 9:00:00 (To match the format the times are stored on the sql server) and having selected an activity by adding these together. So far I have tried something like this.

    Me.txtFinishTime.Text = Me.cmbStartTime.Value + Me.txtDuration.Value

msdn.microsoft.com/en-us/vba/language-reference-vba/articles/… — braX
– braX, Commented Jan 5, 2018 at 15:27
Are the start times always on the hour? In which case you could display 9 to represent 9am and just add 1,2 to this numeric value. — Andy G
– Andy G, Commented Jan 5, 2018 at 15:28

Gustav · Accepted Answer · 2018-01-05 16:10:49Z

1

It could be:

Me!txtFinishTime.Value = DateAdd("h", Me!txtDuration.Value, CDate(Me!cmbStartTime.Value))

answered Jan 5, 2018 at 16:10

Gustav

56.3k7 gold badges33 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

adding times to autofill a field VBA MSAccess

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related