Recent content by Seasider

security Thanks, I discovered that. Thanks, Seasider

I have created a new workgroup and set up users and groups, assigned permissions, etc. Everything works well except that the only users for whom a password is required is the Administrator. All other users are prompted for their username but not a password. They are able to open the DB and...

error handling solved Thanks so much for your help. I had already discovered that the message displayed even when I didn't want it. Appreciate your help. Seasider

error handling solved I found help for this problem in a book "VB and VBA In A Nutshell". I am posting the code in case it helps anyone else. I placed the following code in the "onClick" event of the command button that opens the form. Private Sub cmdOpenFunding_Click() On Error GoTo...

security Thanks for response. Yes, I have actually solved this problem already. You are correct - I had not given any users the right to open/run the main switchboard form. Thanks for suggestion. Seasider

error handling Thanks for your reply. I am using VBA - I have not used any macros in the application. I'm quite new at Access and VBA. Seasider

I've read many threads but have not been able to find anything that covers my current problem. I've developed an application and set security for groups and users. The security is finally working well but one problem remains that I do not know how to solve. When a user tries to open a form...

I have gone through the whole process of setting up users and groups as well as assigning permissions for a database I need to install on a client's network. I created the security on a standalone computer and am trying to test it. I read countless threads on this forum and also downloaded the...

I have finally sorted out this one myself. Had to use nested queries with multiple calculated expressions for current, past years and so on. Appreciate any help I get from this forum. Seasider

annual report problem update I am still trying to sort this problem. This is the part of my query criteria that is not working. PastYr: IIf(DatePart("yyyy",[dohcompleted]=Now()-1),"y","n") The above calculated field is meant to filter dohcompleted for any record that has a year that is one...

fiscal year Thanks Mailman for the response. Your proposed solution would not work for me because the year completed will change each year. I need it to calculate the something like Now()-1 (meaning the previous year). I will look for threads with fiscal year. Appreciate your help. Seasider

I have spent countless hours trying to figure out a way to create a query that will enable me to print an annual report but have not been able to figure out how to set up the criteria. I have a form on which users can enter data about projects. I want to produce an annual report to show what...

unable to delete records from form By the way, I AM able to delete records directly at table level. It is only when using the form that I am not able to delete them. In the properties Allow Deletions is set to "yes". Seasider

I am very puzzled and have tried every possible way I can think of to troubleshoot this problem but have failed. I have a table that contains contact information. The data is entered through a form called frmContacts. The primary key field is ContactID and it is an autonumber type field. The...

toolbox problem Thank you for your reply. Yes, that is exactly what was wrong. I should have remembered to check that early on. Appreciate your help.