Serial Date

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

David W - 29 Mar 2005 02:20 GMT

I might be doing this wrong

I am trying to set a textbox to a serial date using

Me.setserial = DateSerial(Me.Combo4, Me.month, 1)

Me.Combo4 is the year(has the years 1970-2050 for a row source)
Me.month is a combobox with the months set in it.

When I am in debug, you can hold the mouse over the year and see the year
2005, and when you hold the mouse over month you can see the March which
were selected.

where did I go wrong?

Reply to this Message

Douglas J. Steele - 29 Mar 2005 02:27 GMT

What's the actual problem you're having?

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

>I might be doing this wrong
>
[quoted text clipped - 10 lines]
>
> where did I go wrong?

Reply to this Message

Dirk Goldgar - 29 Mar 2005 02:33 GMT

> I might be doing this wrong
>
[quoted text clipped - 10 lines]
>
> where did I go wrong?

You don't actually say what the problem is, but maybe you have the
months listed in Me.month by name, rather than by number. If so, what
you can do is have the combo box's bound column be the month number,
1-12, but hide that column and make the second, visible column be the
name of the month.

You should avoid using the name "month" for a control or field, though,
since Month() is the name of a built-in function and you could
potentially run into some confusion some day.

Signature

Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Reply to this Message