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 Chriss Miller 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. 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?

    Yep, that's got it. Thanks, Gord! I'll be ba-ack...many more things puzzling me, going to try to get as far as I can on my own first. ATAInterns-)
  3. 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)...
  4. ATAIntern

    Login Query

    Thanks for the reply, Rick! Here's where I am: yesterday, I got quite a bit of it figured out, through performing the first lookup and storing the result in a variable. Now I think I need to mess around with a filter.... I'm going to give it a shot today; wish me luck! ATAIntern(-:
  5. 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...
  6. ATAIntern

    Validation Rule Expression for Upper Case?

    Jeez, I used to know that! I think I've forgotten it several times, in fact. Thanks very much, karatekid! sheepish ATAIntern:-Q
  7. 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