Recent content by nmodhi

Hello all, I'm trying to create two DCount expressions in one simply to check if two fields are equal to another set of two fields. For example: abc 123 abc 321 should be okay and return nothing. However, abc 123 abc 123 should inform the user a duplicate entry is being entered. On my...

This is quite difficult to explain but I'll try my best, here it goes.. I may have set up my tables incorrectly, but I can't seem to find a better way to construct the tables I currently have. In one of my tables I have two fields that are repetitive individually but cannot have the same...

I know it might seem awkward but it is the right thing. When the userID is returned, it returns the entire table. The return is displayed in the criteria which is perfect:)

I got it! It looks like this: IIf(LCase(DLookUp("[UserID]=WindowsloginID()","Employee","[Administrator]=True")),([Employee].[UserID]),WindowsloginID()) The windowsloginID function retrieves your unique windows login ID when you login in so that's used to query the user information. I have a...

Im pretty sure this looks okay but the query seems to query according to the loginID only. I am an admin, thus the query should not query anything..here's what I have IIf(LCase(DLookUp("[Administrator]=True","Employee")),Null,windowsloginID()) If the admin is checked as true from the...

Thanks for the tip gemma-the-husky & ghudson. I thought long and hard about using the Access security feature..even creating a switchboard to have an associated user name and password for each user, but why the mess when a user can simply click on the database and not have to go through the...

hello again vbaInet:) Currently the employee table is being queried. If the user is an admin, then the query is not necessary. Hope that makes more sense. I've never used the DLookup function, I tried using the IFF in place of the criteria. Something like what I said earlier.. IF admin is...

Hey guys, So I thought about this different method of making my access database secure within my workplace, I just can't implement it I really hope I can. I have a table of employees where one of the fields includes a check box whether or not the employee is an Administrator. The filed name...

I hope you can explain it to me, and if it's okay..I created two relationships using two tables and I played around with the subform link with the subsubform link..I made it have two links rather than one. Do let me know!

want to see??

nevermind vbaInet!!, I played around with my relationships and got it to work!! Every employee can now see their weekly timesheet and it's different from other employees. I can't explain why it's working though, I guess some accidents lead to success:)

I now understand the criteria aspect and if I type week 1 in the query, it querys the table for me. However how can I query it further to display a certain employee? I'm getting dreadfully confused, shouldn't we need to query according to employee and then according to weeknumber? Do I use this...

Okay I created the query, but im not sure what you meant by setting the criteria to pick the weeknumber or group the weeknumber field?

sorry vbaInet, I am confused. Do you mean create a large query with fields from all 3 tables? I'm not sure how to set the criteria to pick a certain field..do I set the criteria for all fields in the query?

This helps a whole lot, although Employees should be able to access different weekly timesheets, as in ..timesheets they have created in the past. I enabled Timesheet number and changed the autonumber to a number so a user could access the timesheet number. I guess you can say timesheet...