Search results for query: *

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...

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-)

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)...

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(-:

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...

Jeez, I used to know that! I think I've forgotten it several times, in fact. Thanks very much, karatekid! sheepish ATAIntern:-Q

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...