slynn
Last Activity: Oct 1 '08, 04:18 PM
Joined: Sep 3 '08
Location:
-
Works perfectly. Thanks!... -
Testing for exclusive access
I have a database thats is used by about 20 people. I want the first person in that database to run a series of Macros. Is there an easy way to tell if they are the only one in the database?
Thanks. -
Ok, figured it out... It appears that Access does not allow functions in the criteria. So I switched it around a bit and put the function in the select area and had the fuction return a "Y" or a "N" and then in the criteria put ia "Y" or "N" to only return the records that I wanted.
Here is the query:
...Code:SELECT tblpermit.permitlevel, tblpermit.permitusername FROM tblpermit
Leave a comment:
-
Nothing...Just blank. No records....Leave a comment:
-
Custom functions in the criteria of a query
I am trying to build a query which will uses a custom function as criteria. I have searched the forums and found nothing, so either it can't be done or I am just missing something simple.
The function code returns the information I want, but it doesn't come back to the query properly.
my query (which returns no records)
...Code:SELECT tblpermit.permitlevel, tblpermit.permitusername FROM tblpermit
No activity results to display
Leave a comment: