Search results

Hi, i want to add security into my database, but i dont want to use the built-in workgroup security. Is it possible to create a login screen that will allow different access rights depending on the username? If so can sum1 please help me with the code? Cheers Guys :)

Hi, I have the above security settings in place for the account shown, this user should only be able to Read the Database, how is it possible that they are able to edit the database? Any security suggestions will be appreciated Regards

Hi, i am using queries to run searches on a table I am using this code: [Forms]![frmDescr]![txtDescr] I want to be able to enter part of what i am searching for (eg Generic) and it bring up everything with "Generic" in it, instead it will only find things if the complete contents of the cell...

Private Sub cmdEmail_Click() On Error GoTo Err_cmdEmail_Click Dim strDocName As String Dim strEmail As String Dim strMailSubject As String Dim strMsg As String strDocName = Me.lstRpt strEmail = Me.txtSelected & vbNullString strMailSubject = Me.txtMailSubject &...

I want to create a report that will generate from a specific date then have as the second criteria i want the date to change to what ever the current date is Is this even possible or am i just wishing???? Anyone able to help? :)

Ok, I have a table that has new data added into it through forms, and i want the data to be sorted when a new record is added. The person that the database is for is new to Access and therefore is not 100% competant at it. I wanted to add a button onto the forms that would run a macro that...

Hi, I have a database of about 2300 entries and new ones are continually being added. However they are not always in numberical sequence, (eg. 604, 605, 606 etc.) sometimes they will be new revisions on an old number, (eg. 345R3, 604R1 etc) I have noticed that in Access 2000, when you attempt...

How do you set up a login screen (not the standard Database Password) within MS Access 2000 (So that a username and password must be input before opening the database)