Recent content by wonghei7

Oh, thank you so much Rob. It works! Thanks again. Elis

each record to have its own textbox. thx!

checked, it's a textbox.

I did. After I typed the . after my textbox, i only get to choose .count, .item, .lbound and .ubound. I also tried text1.item.text=" " but then i get another error saying "argument not optional". really at a lost now.

Hi Rob, thanks for the reply. I just tried and I can an error saying "member or data member not found". It highlights .Text=

Hi. I'm trying to write the sql results to a textbox for display. My codes are as follows to retrieve the value via sql. However, i'm having trouble writing the results to the textbox. Can anyone help? Private Sub Form_Load() Dim cn As ADODB.Connection Dim rs As ADODB.Recordset Set cn =...

I created a command button to clear a form by defining all the text boxes to " " and setting all the radio buttons to the default buttons. However, after doing this, the error handling of another command button on the same form no longer works and I have to exit and re-enter the form...

Thanks so much, CajunCenturion, you're a life saver. Got it to work.

Hi. I'm trying to create a user login screen by verifying the user ids and passwords maintained in a database connected via ADO. But when I run the program, the run time error 91 pops up. I still couldn't figure out what's wrong. My codes are below: Option Explicit Private Sub...