Search results

Ok, i found a login screen on the forum that i have decided to use, that uses the login details from the network. I want it to check the user name from a list of names, if the name does not appear i want the database to log them in under Read-Only Is this even possible I am using Access 2003...

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 :)

Thanks for that Guy and Gal (I dnt know why the link didnt work, cos i can see the image that it should show *shrugs*)

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

Sweet, that was awesome Cheers Guys

Boss!! That did the trick perfectly Thank You Mate!!

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 &...

No, sorry, i got the code off someone else and i want it to go into PDF instead of HTML Anyone know how to do this?

Thats not quite what im after 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...

Hi, is it possible to get this to print to PDF first then send via email?

Hi, i would also like to know how to do this, but what you have given does not help, what am i meant to do with this code?

Cheers mate, that worked brilliantly Woo. My database is starting to come together now :D

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? :)

Cheers That worked brilliantly thanks Regards

Thanks, and how exactly do i do this (its been a while since i used Access!!)

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...

Alright, cheers Hopefully this will work properly now Thanks Again

Ok, so if i change it so that my database looks like this: Field1 Field2 001 001 R1 120 010 R8 010 R2 098 098 R22 098 R11 006 006 R6 It should (after sorting) look like this: Field1 Field2 001 001 R1...

Thanks for that, im just trying that now Sorry for being short aswell, long day at workl!!!!