microsoft training access course

microsoft training access course - Date$ Time$

Resolved · Low Priority · Version Standard

Date$ Time$

Clare has attended:
Access Introduction course

by - delegate Clare [6 posts] (2007 Feb 7 Wed, 14:35) Reply

Can you please tell me what the dollar sign represents in the Built in Functions under Functions under the Build option.
There seems to time, time$, date and date$ - what is the difference between them?

Version	Date	Location	Places available	Book	Next place rate:
Access VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 4 Thu + 5 Fri	Southwark	7	book now	£345	£399
2003	2009 Jan 8 Thu + 9 Fri	Southwark	6	book now	£450	£485
2003	2009 Feb 5 Thu + 6 Fri	Southwark	8	book now	£275	£399
2003	2009 Mar 5 Thu + 6 Fri	Southwark	7	book now	£345	£399
2003	2009 Apr 8 Wed + 9 Thu	Southwark	8	book now	£275	£399
2003	2009 May 7 Thu + 8 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 12 Access VBA course dates. Bookings currently available until 5th November 2009.

RE: Date$ Time$

by - trainer Garry gold contributer [188 posts] (2007 Feb 7 Wed, 16:39) Reply

Returns the current time. Time$()gives it as a string.

Gives today's date. Date$() gives it as a string.

A "string" is a series of bits that represents some piece of text in human language. What you're reading now is text. Strings are how this text is represented inside a computer.

· Why go on a Microsoft Access Training Course?
· 3 Useful Things You'll Learn in Microsoft Access Training Courses
· Access Database Optimization: First Normal Form
· Access VBA Handling Errors and Debugging Code
· MS Access: Access your Personal Information with Ease

Access tip:

Closing form after a certain time period

To make a form close automatically after a certain time period, you need to assign the close function to a macro.

Save the macro and ope up the form in design view. open the Properties sheet.

In the TimerInterval property enter the length of time you want the form open for. This should be in milliseconds, so for instance if you want the form open for 5 seconds enter 5000, for an minute enter 60000.

You now need to attach your macro (to execute the Close action) to the OnTimer event property of the form.

View all Access hints and tips

Rate this page: