Search results

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.

I have been developing an application in MS Access 2000 but have run into a problem that is way beyond my knowledge. The problem is that objects selected from the tool box will no longer work when I place them on a form. For example, if I try to place a combo box on a form, it just sits there...

Re updating combo box Thank you so much Ilkhoutx. I actually found an earlier thread where you explained this. I set both the first form and the combo boxes on it to be requeried when the 2nd form is closed. Works great. Appreciate your help and that of others on the forum. Seasider

I have a form called "projects" on which I have a combo box that lists staff names. User can choose the staff person involved with the project from the list. That part works fine. Users need to be able to add/delete staff names and want to do that by opening a second form called "frmStaff"...

I have a mailing list in which there can more than one person from the same household. I need to be able to test for more than one record with the same address and then combine the names but with only one address on labels and/or form letters. For example, Address 1 John Jones Judy Jones...

I am truly baffled! Can anyone help me figure out how to combine the contents of several fields into another separate field or if there is a better way to achieve my goal that would be appreciated also. I am developing an application to keep track of projects. The users can pull up a form...