-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
mm/dd/yyyy
-
B
Access VBA "Runtime error 3188 - Could not update; currently locked by another session on this machine" when updating memo field
Hi, I'm getting the above error when amending a record on a text box on a form that links to a Memo field. I mention this because this error has just started occurring on one record, and the text in the memo field exceeds 2k characters - looking at other internet searches, other people have had...- BigRods
- Thread
- error field form memo mm/dd/yyyy
- Replies: 4
- Forum: Microsoft Access
-
P
Date Format Change on a Userform
How can i cahnge the date format on a userform? i have a calander pop up when the command button is pressed, when the date is selected it goes into the text box in the mm/dd/yyyy format. i want to change it to a dd/mm/yyyy or a DD MMM YY format. nothing has worked that i tried.- patteb
- Thread
- change date format mm/dd/yyyy userform
- Replies: 2
- Forum: Excel Questions
-
B
Date value in VBA appears as mm/dd/yyyy instead of the actual format which is mm-dd-yyyy
Hi, I can't get my my date to display in the format that I want it to as a string variable in vba. Public Sub Todaydate() Today = Sheets("Date").Range("B1").Value MsgBox Today End Sub The msgbox displays 3/21/2017 The value in B1 shows as 3-21-2017 I want the variable "Today" to...- bellg
- Thread
- date format m/d/yyyy mm/dd/yyyy string
- Replies: 3
- Forum: Excel Questions
