Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. kkondrat1

    active form

    Private Sub Command66_Click() Dim stDocName As String Dim stLinkCriteria As String DoCmd.OpenForm "LoanNumber" Forms("LoanNumber")("TextSearch").SetFocus DoCmd.Close acForm, "LoanInfo", acSaveNo 'stLinkCriteria Exit Sub
  2. kkondrat1

    active form

    No, that doesn't work, that is what I currently have. the code does work by means of setting focus to the textbox, but when I open the form it does not set focus to the textbox until I click on the form. Its as if the form is not ACTIVE or something, I have to activate the form somehow for the...
  3. kkondrat1

    active form

    I have a button on Form1, when I click the botton I want to close Form1. Next, I want Form2 to open, Form2 consists of 1 textbox. Here is the key: I want the curser blinking on the textbox. Yes, I have tried OnFocus, and it works fine but only after I make the form ACTIVE (The the textbox has...
  4. kkondrat1

    sql/session variables

    Yes, The problem is the sql statement, yes I know, but what I don't know is how to get the session variable = the recordsetID(departmentID) The session variable = "a number" the department ID = "a number" I know my syntax is wrong with the quotes and parenthesis, my problem...

Part and Inventory Search

Back
Top