Recent content by aabbbcc

how could display the value of input mask in that drop down box???'

Still not working sorry:( ___________________________ Option Compare Database Option Explicit Private bolSaved As Boolean _______________________________ Private Sub cmdUnlock_Click() Me.AllowEdits = True End Sub Private Sub Form_AfterUpdate() Me.AllowEdits = False End Sub Private Sub...

i have another issue that the drop down box not showing the value the input mask. how could display the value of input mask in that drop down box???'

any sample?? THANKS

but i have many customer order to search.. how could i write the VBA?? __________________________________________________________ Private Sub Form_Load() Dim MyResult As String MyResult = Replace("0000/00/00-00", "0000000000", "0000/00/00-00") End Sub...

I have an input mask for the customers order in my database. 9999/15/01-00 gets to be seen this way when being entered. It is stored as 99991501 without the dashes. On one of my forms, I have a search box. The users of the Database wanted to have the mask put on it as well. When I do that...

what i want is also showing the value of input mask.

Thanks... But could I do that without pop up function>?

_______________________________________________ Private Sub Form_BeforeUpdate(Cancel As Integer) Dim strResponse As String If Not bolSaved <-the system sends error of this code. If Me.Dirty Then Select Case MsgBox( _ Prompt:="記錄已更新" & _ vbCrLf & "是否確定儲存?", _ Buttons:=vbExclamation Or...

could I use them at the same time and what code could I use to avoid the conflict ?! Thanks

got it .. thanks how about 2, when i click the save button, and i save "Yes", it will pop up the messages box again to ask me save it or not. But No problem when i say No. 3, When i enter data to the entired new record and click save button. There is a message appearing that data cant be...

Hi, I want a form to do the following: 1, default new record when i open the form 2, message box asking save or not save when i click save button and before updated event. 3,default not allowing editing and after updated(even save or not save) ,and a button to unlock. the codes are as follows...

i want to add a code to ask people to save it or not after they update their form or subform.. I use the following code: __________________________________________________ ___ Private Sub Form_BeforeUpdate(Cancel As Integer) Dim strResponse As String If Me.Dirty Then Select Case MsgBox( _...

Where to set the screen solution then ?? Thanks a lot .

how about just zoom the the words and all items to the size that can be read more easily?