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!

Register Log in
  • Congratulations Rhinorhino 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: *

  • Users: ATAIntern
  • Content: Threads
  • Order by date
  1. ATAIntern

    If form filter yields no records....

    Hi, all! I have a form set up to display only certain records in a table, using a filter, to wit: Me.Filter = "DeptCode = '" & Forms!SelectProject!cboDept & "' AND StatusID = 'A'" Me.FilterOn = True Now, I'd like to have an escape clause to display a MsgBox...
  2. ATAIntern

    Close one form from another?

    Hi, all! I've been wrestling with this for a bit, with the error messages changing every time I change the code, but nothing's quite working. I've got three forms open. When I hit a button on Form3, I want it to close itself and Form2 (while first setting a control on Form1)...
  3. ATAIntern

    Login Query

    Hi, all... I'm trying to code something to execute whenever the database starts up; specifically, I want to capture the user's login in a variable, then use that variable to query a table (to find a different ID), store the result of that query in another variable, and use THAT variable to...
  4. ATAIntern

    Validation Rule Expression for Upper Case?

    Hi, all! My first post and, I hope, a very simple question: What should the ValidationRule expression be for a table field (text) that I want to limit to all-uppercase letters (well, it can include a combo of letters and numbers, but the letters should be all-uppercase)? Loving the forum and...

Part and Inventory Search

Back
Top