UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

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



Posts: 81
Joined: 28-November 02
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
Joined: 23-June 02
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



RSSSearch   Top   Lo-Fi    22nd May 2015 - 06:30 AM