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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.