Recent content by lakshmi

Need to create a report which will take the current date and add 35 days to it and then run a query that selects all records whose expiration dates fall within 35 days of the date you calculated. Does this make sense????? Do I need VBA to create this report or can I just use a function...

Thank you for answering my previous question, but I guess I did not phrase it correctly. What I would like is to have a question before anybody can delete/modify the information in a field, e.g. the last name field. Is this possible? Thank you for any feedback!

Is it possible to modify a form that if a user is going to delete a record, it can questions it? If so, how? Thank you.

I have this form with a couple of subforms. The link is the OCA number, and then there is the Nbr for each item of the subforms. I am encountering two problems. The first problem is that I go to a record (with an OCA number), and would like to add an item to my Arrest subform. I enter the...

I have this report which includes names, sex, race, ArrestDate, and a check box for release. Each inmate's name must display for as many times as necessary, however, there should only be one Release check box per name. If the inmate is released, we check the box. I want to count the number of...

We have our human resource database on the server. We recently upgraded to A2000. Since we have set the permissions to the HR staff to have full access, the Communications dept to have read access, and the rest of the staff to no access, the HR staff gets this error message when they try to...

I have tried uninstalling/reinstalling Access 2000 without successs. The report/query wizard do not work. I do not know what the problem is, and we are going crazy because it is so much easier to use the wizard than to create it from scratch. Any suggestions???? Thank you.