Recent content by qiqinuinaifen128

When the user select the date, the text box will appear the date like "12/12/2009", the correct entry should be include timing like "12/12/2009 07:00:00AM". Can i check weather the char is more than 13 if not prompt an msgbox to notified the user

Thank you so much for your help. It's really what i need. Amazing^^ Do you know that whether excel 2007 userform can set the textbox to richtext format?

Actually i have another similar question I have a dat/time field in the table. In the userform, i have a textbox which let the user to select data in this textbox and key in the time. But sometime the user after select the date and forget to key in the timing Do you know how to prevent this...

I'm a very beginner access learner ^^, don't know much about code. Thank you for provide me another solution.

Thank you for your response. Actually the message i want to displays in a TextBox is combined data which is from other textboxs that user need to key in. I don't want to use MsgBox because i have to copy the message to the phone and sent this message out. The purpose i want to bold the data is...

Thank you for your reply. Actually i am a very beginner. It seem like very complicated to me. May be your are right. It is not worth for wasting time in this. Anyways thanks alot for your advice.

Hi, I'm using access 2007. I have a question regarding textbox. I am using a textbox to display a message. May i know is the textbox can be multiple-formatting? For example: Some words are bold, some words are underline?

I got the answer^^ Below is the code Me.txtdisplaytheday = WeekdayName(Weekday(Me.txt_date))

[Resolve] DataType - Date/Time Hi, I have a field and the i had set the field's data type to Date/Time. Inside my form, user can choose the date in a textbox. I hope to automatic display the day(monday, tuesday...) on another textbox when the user select a date in the calender. May i how...

Sorry i am a beginner. May i know how to use the input mask?

Thank you John. I have almost half done my assigment. Hope you can give me help for this part. In my form, there are many textbox and combobox in my access form database. and all this details will key in manually and after key in all the data in to textbox and made all the selection. There is...

HI John, Good to hear again I don't know where should i place the code. I hope that once i made an selection, it will automatically display it. Do you have any idea?

Thank you for your reply. It is abit complicated to me...hee hee But tell you a good news. I try to create again.. It's a lot me to create a combo more than 144 selections. Do you know how to write a code for, once i make an selection in a 2 columns combo box. Then another textbox will...

Hi John, Yes, it's work. I want to create a two columns Combo and i have 114 selections. Do you know what is the maximum selection for the combobox. Because when i try to create this, it prompts me this message "subscript out of range" Do you have any suggestion to me? Thanks

Hi John, I use the code below. But the compiler error If Me.txtstudent_contact.Value < 100000000 Or Me.txtstudent_contact.Value > 999999999 MsgBox "A Nine Digit Number is required by this Filed" Me.txtstudent_contact.SetFocus End If txtstudent_contact is my textbox name. When i...