Easy E
Badges: 0
#1
Report Thread starter 13 years ago
#1
Is there any way to write code in VBA which will take a particular date in this format: "02/01/2006", and return which week day this date is and save it to an Access field or a Text Box in a form?
For example this one is a Monday, so the code would return the text string "Monday" to the field or Text Box.

I would very much appreciate any responses as this question is quite urgent.
0
reply
Guy01
Badges: 1
Rep:
?
#2
Report 13 years ago
#2
Private Sub Command1_Click()
Label1.Caption = Format$(Text1, "dddd")
End Sub
Attached files
0
reply
Guy01
Badges: 1
Rep:
?
#3
Report 13 years ago
#3
you can use "ddd" instead of "dddd" if you want the day to be displayed like Mon, Tue, Wed, etc.
0
reply
__WiZaRD__
Badges: 2
Rep:
?
#4
Report 13 years ago
#4
hey there, i found what you are looking for: heres the link

It tells you how to find the weekday from the date, basically what you asked for, i think.
0
reply
Easy E
Badges: 0
#5
Report Thread starter 13 years ago
#5
Sugoi!

Domo Arragatto Guy01 and _WiZaRd_, you have both been extremely helpful. But you have not been useful, coursework.info...IF that is your real name!! Yevon be with you Guy Zero One and underscore WiZaRD underscore....well actually Yevon is an evil religion. Ummm...Satan be...no...err...:eek:
0
reply
X

Quick Reply

Attached files
Write a reply...
Reply
new posts
Back
to top
Latest
My Feed

See more of what you like on
The Student Room

You can personalise what you see on TSR. Tell us a little about yourself to get started.

Personalise

University open days

  • SOAS University of London
    Development Studies, Interdisciplinary Studies, Anthropology and Sociology, Languages, Cultures and Linguistics, Arts, Economics, Law, History, Religions and Philosophies, Politics and International Studies, Finance and Management, East Asian Languages & Cultures Postgraduate
    Sat, 25 Jan '20
  • University of Huddersfield
    Undergraduate Open Day Undergraduate
    Sat, 25 Jan '20
  • The University of Law
    Solicitor Series: Assessing Trainee Skills – LPC, GDL and MA Law - Guildford campus Postgraduate
    Wed, 29 Jan '20

How many uni open days have you been to/did you go to?

0 (104)
29.46%
1 (56)
15.86%
2 (50)
14.16%
3 (56)
15.86%
4 (26)
7.37%
5 (23)
6.52%
6 (9)
2.55%
7+ (29)
8.22%

Watched Threads

View All