Recent content by marknufc

Thank you very much

How do I configure a form so it can only add records. I don't want users to see what is currently stored in the table, just add records to it.

Originally it was now its text

100% sure, that was my first check. I've found DB that has a working user audit log. I've taken the code from it and I'm trying to modify it to fit my DB. I keep getting error after error, I'm close to giving up on it. I'm a forensic student so coding isn't really my thing, Databases is a unit...

Done that, its gone back to not liking [LecturerLoginID]

I now get a compile error, Me.txtpassword = Nz(DLookup("LecturerPassword", "user_tbl", "[LecturerLoginID] = '" & Me.txtuser & "'"), "") then With Forms!frmStoredLogins .txtLecturerLoginID = Me.txtuser .txtDateTimeLogin = Now End With it doesnt like the "Then"

[LecturerLoginID] is txt Me.txtuser is the text field on a log in form to enter a username

My DB doesn't like this line of code, why? If Me.txtpassword = Nz(DLookup("LecturerPassword", "user_tbl", "[LecturerLoginID] = " & Chr(34) & Me.txtuser & Chr(34)), "") it has a problem with the [LecturerLoginID], I'm not a coder so I apologise if this is a simple problem.

Hi, I want to be able to track users log-ins on my DB, basically when a user enters their username and password I want the the time they log in and their username recorded in table. I tried doing it from the the Helpdesk database found here...

Hi, I am building a DB for my college, it is needed to replace a spreadsheet they have in place. The spreadsheet is used to monitor and track Students grades. Each unit a student passes gives that student a certain number of points, the number of points depends on the grade (e.g. a student...

Entity relationship diagram

Is there anywhere I can get I guide or walkthrough?

just the logins

^^^^^^^^^^^^^^^^^^^

btw i have a very basic understanding of access