Recent content by Alias

If you are able to capture the User Name from when the user authenticate to Windows will it assist you with your problem? By capturing their User Name from Windows, you can compare that to the list of user from the User table in your database. So only those that are in the User Table will be...

Jeremie, Thanks for the help. I really appreciate it. I do understand what you are suggesting and after reviewing it, I think it will work. After a little bit more of playing around, I ending up using a crosstab query. From my enrollment table, my rows for the crosstab were studentID, columns...

Why not just remove the FE from the network drive and put it somewhere else since they all have an FE on their C drive anyways? Then if they click on the mapped drive, they cannot find the FE to launch from the network. Also, why not link the FE to the BE thru UNC instead of a specific Drive...

OK, it appears that I do have the tables as you describe. For example, I have a tblStudent(SSN, Fname, Lname, etc), tblCourse(CourseID, CName, etc) and finally the tblEnrollment(EnrollID, SSN, CourseID, Date, Session, etc) The tblCourse contains 100s of courses each with a different CourseID...

Assuming I have the following in a course enrollment table. CourseEnrollment(SSN, CourseID) How do I select only the students (SSN) that have taken ALL three of these classes (CourseID = 123, 234, 345) Thanks for any input.

Thanks for the suggestions. I'll do some more research and see if I can find some answers. If anyone else have any other suggestions, please feel free to comment. Thanks!!!

I just upsized a Access2000 DB to SQL2000. However, I am getting an 3251 error. Can anyone tell me why and what I need to do to make this code work. Thank you so much. Dim db As Database Dim rA As Recordset Dim rF As Recordset Set db = CurrentDb Set rF =...