Search results

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

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

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

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

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

In the BeforeUpdaate event on a form, I have a message box that prompts the user to confirm that they want to save the record. If vbYesNo = yes, the record saves properly but after the record is saved the form moves to the first record. How can this be coded so that the form stays on the...

I'd really appreciate some help. I am just learning VBA on my own. I have a form with 3 checkboxes: ActiveStatus, Newsletter, and AnnualReport. I have placed code in the On Click event of the ActiveStatus control to prevent the user from CHECKING either the Newsletter or AnnualReport unless...

I am new to using VBA and also to using forums but have found this one to be extremely helpful. This is my first post. I have a form with (among other fields) four checkboxes. The form also contains a subform. The subform is used to count the checks from the checkboxes. When user checks the...