Search results for query: *

Hey All, I have a query : select [empid] from TABLE_A where [empid] NOT IN (select [empid] from TABLE_B); I get NO results even though there are differing values between the 2 tables. I tried reversing the query, e.g.-- select [empid] from TABLE_B where [empid] NOT IN (select [empid] from...

Good Afternoon All, Is there any way in MS Access 2000 to display a message to the user when they have accessed a record that is currently "locked" ? As of now, I have record locking for a form set to "Edited Record" only, and when a user loads a record into a form that...

Good Evening All, I've searched Microsoft's Technet as well as this site and can't find anything that *exactly* addresses the issue, so please bear with me. Is there any way you can use a SQL query in the expression builder that references fields in the table as well as fields/controls in the...

Good Afternoon, I have a simple form with a primary key field "Employee ID" and other fields that need to be filled in. What I'd like to do is create an unbound text box at the bottom of the form, and simply print the results of a query in that text box as the "Employee ID&quot...

Good Afternoon All, Okay--- I gave Admin a password in the database. But I still have users who can launch MS Access and the database comes up WITHOUT prompting them for a password. I suspect that their default "system.mdw" file is coming into play. When I take away...

Good Afternoon Everyone, I'm Paul, I'm new to this service, and it looks like a tremendous resource ! Thanks in advance for your help. Here's my situation : ------------------------------- I have an MS Access 2000 DB, and I've followed all of the standard "Secure An Access DB&quot...