Date and Time not updating
in [Form]
|
From: Bob H on 10 Oct 2008 05:13 I have created a switchboard in access 2007 and inserted the Date and Time, but as the database is on a company server, the time does not update itself as it does on a local machine. I find I have to shut down the switchboard and restart it to get thetime to update. Any solution to this problem please? Thanks
From: Douglas J. Steele on 10 Oct 2008 07:17 Not quite sure I understand what you're doing. Are you saying that you've got a text box that displays the date and time, and it's not changing? It won't: if it's got something like =Now() as its Control Source, you need to refresh it on a regular basis. See, for instance, http://www.mvps.org/access/forms/frm0032.htm at "The Access Web" -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "Bob H" <robh(a)bobg4uyi.adsl24.co.uk> wrote in message news:iJmdnYJx9sA8gXLVnZ2dnUVZ8vqdnZ2d(a)bt.com... >I have created a switchboard in access 2007 and inserted the Date and Time, >but as the database is on a company server, the time does not update itself >as it does on a local machine. I find I have to shut down the switchboard >and restart it to get thetime to update. > > Any solution to this problem please? > Thanks >
From: Bob H on 10 Oct 2008 09:26 What I have is 2 labels/controls, 1 for the date which does show and update, and the other one for the time which didn't. Now it does as I found out that I had to put a value in the timer interval of the events property tab, and also to add a line of code in the Private Sub Form Timer event. Thanks anyway "Douglas J. Steele" <NOSPAM_djsteele(a)NOSPAM_canada.com> wrote in message news:%23ToIMnsKJHA.2760(a)TK2MSFTNGP06.phx.gbl... > Not quite sure I understand what you're doing. > > Are you saying that you've got a text box that displays the date and time, > and it's not changing? It won't: if it's got something like =Now() as its > Control Source, you need to refresh it on a regular basis. See, for > instance, http://www.mvps.org/access/forms/frm0032.htm at "The Access Web" > > -- > Doug Steele, Microsoft Access MVP > http://I.Am/DougSteele > (no private e-mails, please) > > > "Bob H" <robh(a)bobg4uyi.adsl24.co.uk> wrote in message > news:iJmdnYJx9sA8gXLVnZ2dnUVZ8vqdnZ2d(a)bt.com... >>I have created a switchboard in access 2007 and inserted the Date and >>Time, but as the database is on a company server, the time does not update >>itself as it does on a local machine. I find I have to shut down the >>switchboard and restart it to get thetime to update. >> >> Any solution to this problem please? >> Thanks >> > >
|
Pages: 1 Prev: 2000 database running inside 2007 runtime Next: Form Control Default property problem |