Date Format in Code (1 Viewer)

[JeffAccess]

Hi
I'm using Access 2007.
I am needing to duplicate a field (It is necessary)

I use the following code.
Private Sub Confirm_Course_Number_KeyPress(KeyAscii As Integer)
Me.Confirm_Course_Number = YearMonth
End Sub

It works exactly the way I want, however the date is showing long. What code do I put in for YearMonth to put it in the format of "ddmm"

Any help appreciated.
Jeff

 

[missinglinq]

Assuming that YearMonth is a Control on the same Form:

Me.Confirm_Course_Number = Format(Me.YearMonth,"ddmm")

Linq ;0)>

 

[JeffAccess]

Assuming that YearMonth is a Control on the same Form:

Me.Confirm_Course_Number = Format(Me.YearMonth,"ddmm")

Linq ;0)>

Hi Missinglinq!
That was perfect!!!! How do you all know these things?
Thanks. Appreciate the help!
Jeff

 

[JeffAccess]

Missinglinq....
Just a quick question?
I was using the same control on the same form.
How does one go about using a control from another form?

Thanks again
Jeff

 

[pr2-eugin]

Try..

Form![COLOR=Blue][B]FormName[/B][/COLOR]![COLOR=Red][B]ControlName[/B][/COLOR]

For a detailed matrix on referring Controls on other forms, Check out the Access MVP site.

 

[JeffAccess]

Try..

Form![COLOR=Blue][B]FormName[/B][/COLOR]![COLOR=Red][B]ControlName[/B][/COLOR]

For a detailed matrix on referring Controls on other forms, Check out the Access MVP site.

Sorry pr2-eugin. I'm still a newbie with this.
So my form name is "Attendance Register Marketing" and the ControlName is "YearMonth". How do I put it in? It tells me Compile Error, Expected end of statement and it highlights Register??

 

[pr2-eugin]

Sorry there was a typo.. Try..

Form[COLOR=Red][B]s[/B][/COLOR]![Attendance Register Marketing]![YearMonth]

 

[JeffAccess]

Sorry there was a typo.. Try..

Form[COLOR=Red][B]s[/B][/COLOR]![Attendance Register Marketing]![YearMonth]

Great stuff! It works! Thanks

 

[pr2-eugin]

Glad to help, and thank you for giving my 1000th Thanks.

 

[JeffAccess]

Glad to help, and thank you for giving my 1000th Thanks.

Haha! My pleasure!!
Maybe you can check out this post I sent?
http://www.access-programmers.co.uk/forums/showthread.php?t=252851