Recent content by randika100100

  1. R

    How to move the cursor to the end of a text box in a Keydown event

    is my question too stupid? :(
  2. R

    How to move the cursor to the end of a text box in a Keydown event

    can some one please help me with this? Im totally stuck here :(
  3. R

    How to move the cursor to the end of a text box in a Keydown event

    Thanks for the reply. I have tried this way before and it didn't work either :(
  4. R

    How to move the cursor to the end of a text box in a Keydown event

    Hi All! I have a live search in my form and searchtxt is the text box that users insert values to search.But in the process textbox looses focus and to get the focus and to set the cursor to the end of the already entered text I put It worked properly. But now I want to be able to...
  5. R

    Cant open recordset from a query

    Thank you very much :D . You saved me. I dont know if i can ever pay you back ( as im pretty new to VBA :o ) . But thanks a lot.
  6. R

    Cant open recordset from a query

    Thanks again for replying. I have put a msgbox rst.RecordCount just after Set rst = qdf.OpenRecordset(dbOpenDynaset) and it returns 1 then I checked rst in the locals window and had a look at the fields and found details of the first record.In addition record count shows as one in local...
  7. R

    Cant open recordset from a query

    Thank you very much for your response. Sorry it was my fault that I haven't put set db part here. This is the code. I get only one record in the recordset after running this.But the query has more than one records . any help would be greatly appreciated.
  8. R

    Cant open recordset from a query

    Hi all! I'm trying to open a recordset from a query using following code. It doesn't work. There are no errors and it doesnt fill the recordset either.I might have done something stupid and I apologize for asking this sort of stupid questions.Can someone plz help me. Thanks in advance
  9. R

    SelStart doesn't work properly in TextBox_KeyDown event

    I have a subform in datasheet view and a text box to put values to search and the results are displayed in the datasheet.I have code in Text_Change Event so whenever user press a button inside the text box, it will setup the sql and requery the datasheet to provide a live search. But in the...
  10. R

    Capture keypress without triggering Key_Press event of a text box

    @ boblarson Thank you very much for the reply. It was my fault that I haven't described my matter properly. I have a subform in datasheet view and a text box to put values to search and the results are displayed in the datasheet.I have code in Text_Change Event so whenever user press a button...
  11. R

    Capture keypress without triggering Key_Press event of a text box

    Hi all! Im pretty new to the forum and to VBA. This is my first post. I have a problem that I have been trying to solve for 2 days and yet couldn't . I want to detect if the space bar has pressed. But I want to do this in the Key_Change event. In other words I want to know how to detect the...
See more
Back
Top Bottom