Search results

Dear all, I have a database for authorising absences from a sixth form college. The student fills in a form and then the housemaster either authorises or declines. When a form has been authorised it no longer needs to be seen so I want to filter these out on the form load. So can anyone...

Dear all, In my project I have this line of code- strRole = Nz(DLookup("[Role]", "tblStaff", "[UserID] ='" & UserName & "'"), "") It works fine until someone has an ' in their name...can anyone tell me what to do about this? Thanks Aubrey

Hi all, I have created a database that keeps track of students whereabouts during half term, end of term holidays etc. There are five house in the college but I am only making it for one house at the moment...subsequently there are students who whouldnt be allowed to access the system. I...

Hi All, I have a button on a form that should, when pressed, save the form and print it out. However at the moment it prints out all forms. I was wondering if anyone could tell me the code to print out the current form only? Thanks in advance James Aubrey

Hey all, Is there any way of stopping the user accessing the code in my database? I've turned off all of the 'Display status bar' 'Display database window' etc so that they can't access the tables directly but the properties menu is brought up using the alt+enter shortcut so the events can...

Hi All, For my A-Level Computing Project I have created a database that holds details on students in a boarding college and details of where they are at half terms/end of terms etc. For the security of this database i need to lookup the user ID from a table and then give the user specific...