UtterAccess.com
We have detected that you are using an unsupported web browser. We recommend you to upgrade your web browser to get the most from UtterAccess forums.
Why should and how can I upgrade?
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

> Change System Date via VBA    
 
   
mac_baum
post Jul 31 2004, 03:40 PM
Post #1

UtterAccess Enthusiast
Posts: 81
From: Canada



Is there any way to change the system date from VBA code? I need to go back one month.However, a general solution would be appreciated ie change day/month/year.
Thanks for your help.
Go to the top of the page
 
+
 
Start new topic
Replies
truittb
post Jul 31 2004, 04:04 PM
Post #2

Retired Moderator
Posts: 13,562
From: Texas (Is there anywhere else?)



How about
ate() = #7/31/2004#
For you could use a variable
Date() = dtmYourDate
Go to the top of the page
 
+

Posts in this topic
- mac_baum   Change System Date via VBA   Jul 31 2004, 03:40 PM
- - truittb   Re: Change System Date via VBA   Jul 31 2004, 04:04 PM
- - r_cubed   Re: Change System Date via VBA   Jul 31 2004, 07:15 PM
- - truittb   Re: Change System Date via VBA   Jul 31 2004, 09:34 PM
- - truittb   Re: Change System Date via VBA   Jul 31 2004, 09:42 PM
- - mishej   Re: Change System Date via VBA   Jul 31 2004, 11:14 PM
- - kenick   Re: Change System Date via VBA   Aug 2 2004, 07:12 AM
- - truittb   Re: Change System Date via VBA   Aug 2 2004, 08:34 AM
- - Gustav   Set up a separate machine not connected to corpora...   Feb 7 2012, 04:03 AM


Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 



RSS Search  ·  Go to Top  ·  Lo-Fi Version Time is now: 21st August 2014 - 02:59 PM