Recent content by vbnt

Thanks alot again

Thanks for reply RuralGuy How I do that plz? How about the code I posted, is the method correct from A to Z? Thank you

Hi all Can any one check if this code correct please? Thank you Private Sub CmdAdd_Click() Dim db As DAO.Database Dim rst As DAO.Recordset Set db = CurrentDb Set rst = db.OpenRecordset("table1", dbOpenDynaset) If IsNull(ComboName) Then 'MsgBox "Please Select comboname", vbOKOnly + 64...

Many thanks for your reply Mile-O and NigelShaw. I will try and see Have a nice day vbnt

Hi all What is the simple code to stop mouse wheel to scroll records on the form? Any help will be appreciated Thank you vbnt

Thanks Well, that's ok. Many thanks gemma for reply. vbnt

Hi How I can make the column widths for list box or for sub form automatic (auto size)? Any help will be appreciated vbnt

How I can search by text box or by combo box or by both of them at the same time? Can any one attach a little example please? Many thanks in advance vbnt

Follow up 1- Just try to delete all records in the maindata table. Then open newcase form , you will see this error. The command or action recordsgotonew’ isn’t available now. 2. when I fill all text boxes and go to subform to fill I go error . Index or primary key cannot contain a Null value...

Follow up It is a great idea, but not working well, Just try it with out any record in the maindata table. Anyhow, thanks a lot for your efforts Regards, vbnt

still I am follow up, I hope some one can help me soon. Any help will be highly appreciated. Thank you

I hope so, anyhow , have a nice sleep. Thank you

Follow up You are right boblarson. But I created this code to generate number like auto number to make track my work the way I need. Using auto number makes a lot of problem , specially when I open the form to add new case, when I changed my mind and I close the form and reopen it again will...

Hi all Can any one correct my attached program to make it works with one command button only please? Using two buttons make conflict. Any help will be highly appreciated. Thank you vbnt

Hi CraigDolphin This is the right answer I am looking for , it is really great. That makes me so happy. Thank you so much, I really do appreciated. Have a nice weekend vbnt