Search results

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...

Hi, I have a textbox and this textbox is for me to key in number and i want to limit the textbox must be in 9 digit. No less, No more. if key in less or more, i would like to prompt a message to notify. How should i write the code? Thank in advance ^^

Hi John, I try your method, but it is not functioning. I have a command button in my form. This button command is actually form a message and this message contains a infos which are from textbox and combo box, I had placed the code into the "OnLostFocus". However if i didn't made any selection...

Hi John, I have another question need you to assist. bolow is my code. Do you think it's ok for checking. or do you have better idea to improve it because the msgbox prompt continuously If IsNull(ClassType) Then MsgBox "Please make a selection from the Clsss Type", vbOKOnly...

Hi John, Really thank for you help. I will try it now. You are a good Access Guru^^. May i know how can be like you? Is there any free resource to study Access VBA.

Hi John, Thank you. It's work. Today you solve alot of problem to me. Ha Ha ^^, i did learn a lot. Another question ^^ if the i want to prompt message if the user didn't make any selection for a combo box. What is the code look like I appreciate for your assist. HAVE A NICE DAY!