The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » Dates Changing in Access

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

Dates Changing in Access

Resolved · Low Priority · Version 2003

ReplyFri 19 Feb 2010, 15:31Delegate Nicola said...

Dates Changing in Access

Is there any way I can stop the dates from changing to American Format when exported from Access?

For upcoming training course dates see: Pricing & availability

ReplyTue 23 Feb 2010, 07:53Trainer Stephen said...

RE: Dates Changing in Access

Hi Nicola

Thanks for your question

This can be done by using a combination of datepart() functions, string cocatenation, and cdate functions to format the date correctly.
I will write a some code to solve this and will post it here later today or tommorrow

Regards

Stephen

ReplyWed 3 Mar 2010, 15:44Trainer Stephen said...

RE: Dates Changing in Access

Hi Nicola

Sorry for the delay in following up

I have written a function which converts the date into UK format. When you pass the calendar's value to a variable you should pass the value as the USdate argument in the function

Public Function DateConverter(USDate As String) As Date



    Dim strMonth As String

    Dim strDay As String

    Dim strYear As String

    Dim strDate As String

    

    strDay = DatePart("d", USDate)

    strMonth = DatePart("m", USDate)

    strYear = DatePart("yyyy", USDate)

    

    strDate = strDay & "/" & strMonth & "/" & strYear

    

    DateConverter = CDate(strDate)

   



End Function

Hope this helps, please follow up if you have any questions

Regards

Stephen

Wed 10 Mar 2010: Automatically marked as resolved.

Access articles

· Want To Get Started With Macros In Microsoft Access?
· Access Corruption Avoidance Tip #3: Stay Connected
· Want To Find Out About Access Queries?
· Use Microsoft Access to manage your work/life balance
· Access Corruption Avoidance Tip #2: Avoid Dangerous Data

Please browse our web site to find out more about
2002 access online training and other Microsoft training courses.

Access tip:

Create An Inaccessible Field On A Form

There is sometimes a need to make a field in a form look like a normal field but be completely inaccessible to the user. To do this:

In the Field's Properties
Set the ENABLED property to No
Set the LOCKED property to Yes

The field will not grey out, but the user will not be able to do anything with it.

View all Access hints and tips

How do I remove the 'Page 1' written behind a worksheet?