Search results for query: *

Thank you so much. It already works.

Hi pkailas I can't do: lstViewAll.ListSubItems.add It doesn't have that property. I can see lstViewAll.ListItems but not lstViewAll.ListSubItems Any idea how I should re-write them ? Thanks so much for your help.

It still does the same thing, pushing down values of the first column to next row. This is how it looks like if the Do Loop runs 4 times. I'm really frustrated over this. It should be something simple :-(( Thanks. 4545A 4545B 4678C 4758A 123...

What I'd like to achieve is having values written to the 2 column listView (should be on the same row). The codes below don't work out right. Everytime something added to SubItem, the value in the first column is pushed down to the next row. Any help is greatly appreciated...

Hi all, I tried to use .setfocus with my textbox_keydown but it doesn't work. Any idea why ? Private Sub txtJurCode_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer) If KeyCode = vbKeyReturn Or KeyCode = vbKeyTab Then If txtJurCode.Text = "" Then MsgBox...

I tried the code and I got the column header show up but not the subitems. They are all blank :-(

I have a listView with 1 column. Please help me the way to add item in listView. The reason I'm trying to use listView instead of listbox b/c in VBA listbox does not have sort property. Thanks so much for your help.

I tried listView like you suggested but I really have problem adding item to the listView. Suppose I have only 1 column in listView and I'd like to add a list of item just like what I did in listbox. Could you show me how. Thanks for your help.

Hi, This is what I currently have: For i = 0 to lstBox1.ListCount -1 lstBox2.AddItem lstBox1.Text next i lstBox2 is a multiple column listbox. How do I remove all the items in lstBox1 to column(1) of lstBox2 ? Thanks a bunch for your help.

Hi, Do listbox limit the ammount of item we can add ? What's the max number ? Thanks.

Hello all, Please help me the code to allow users enter only number in the textbox. I know it's a keydown event but I can't find the ASCII code to do this. Thanks in advance.

Hello all, Could you please show me how to set focus on a specific row and column ? (in my case I need to set focus on the second column of the last row) Thank you so much.

Hi, How do I open a form with new record from another form ? Thanks.

Thank you all. I got it! :-)

Thanks for your help. Could you please give me the code to cancell the operation ? I've had a hard time finding it. Thank you so much.

Hi, When users add new record and the record already exist in the table, how do I cancel the AddNewRecord action and make the form navigate to the existed record ? Thanks. Dim db As DAO.Database Dim rs As DAO.Recordset Dim strSQL As String strSQL = "SELECT * FROM myTable WHERE ID = &quot...

Hi, Is there anyway to disable AddNewRecord button on the record navigator tool bar ? Thanks.

Hi, I have a form for users to enter data and save it to table. Before saving, it should check if the record for the same ID & year already exist. If it is then just edit record. I got problem with this part. The msg I got is : "Could not update; currently locked by another session on...

Hi, I have a look up field on my form. Everytime the value of my look up field is changed, I'd like to write that value to a hidden textbox which tied to my table. I tried: txtHidden = txtLookup on the onChanged event or afterUpdate event of the lookup field but it did not write anything to my...

I got that problem solved already. It has nothing to do with this delete command. Thanks. I do have another question for this though. If I put the delete button on a form that have no control tied to the table then it is fine. Is there anyway I can put this button on the form that have...