
May 9, 2009 16:22 by
Paul
To navigate or go between screens using Visual Basic simply use formName.Show()
Replace fromName with the name of your form. This will open the form specified.
Be the first to rate this post
- Currently 0/5 Stars.
- 1
- 2
- 3
- 4
- 5

April 23, 2009 11:07 by
Paul
SQL provides a number of different date formatting options. Use getdate() to get the date
then convert to a string and format as desired.
Number: SQL Query: Sample:
1 select convert(varchar, getdate(), 1) 12/28/09
2 select convert(varchar, getdate(), 2) 09.12.28
3 select convert(varchar, getdate(), 3) 28/12/09
4 select convert(varchar, getdate(), 4) 28.12.09
5 select convert(varchar, getdate(), 5) 28-12-09
6 select convert(varchar, getdate(), 6) 28 Dec 09
7 select convert(varchar, getdate(), 7) Dec 28, 09
10 select convert(varchar, getdate(), 10) 12-28-09
11 select convert(varchar, getdate(), 11) 09/12/28
101 select convert(varchar, getdate(), 101) 12/28/2009
102 select convert(varchar, getdate(), 102) 2009.12.28
103 select convert(varchar, getdate(), 103) 28/12/2009
105 select convert(varchar, getdate(), 105) 28-12-2009
107 select convert(varchar, getdate(), 107) Dec 28, 2009
110 select convert(varchar, getdate(), 110) 12-28-2009
111 select convert(varchar, getdate(), 111) 2009/12/28
Other variations are also available.
Keep in mind you need to do any calculations before you convert to string.
Currently rated 5.0 by 1 people
- Currently 5/5 Stars.
- 1
- 2
- 3
- 4
- 5