Recent content by lakshmi_pili

Thank you for your response. I tried the code, and have run into a few problems. First it displayed it on every record with the exception of those which did not have a registration date (at the beginning they did not add a date when the database was created) so I figure I change the "<" sign...

I have a form with a registration date. What I would like to do, but do not know if it is possible or do not know how to do it, is that it should look at the registration date, and if it is 30 days or 60 days for that matter, a notification should pop up for that particular record telling the...

Thank you so much!!!!! It worked like a charm!

I have a table with the LName, FName, Rank, Date_Employed. I need to create a query that will calculate the number of years that the person has been working up to the current day. Is this possible, and if so, how can I do this? Thank you for your help!

I am sorry for being dense, but it is not working. I made those three boxes "unbounded" on the form, and then added "Me.[Weight in Grams]=Me.Weigh_in_Oz * (28.3495))" to the after update, but it keeps giving me this error message when I press enter or tab to go the next field: Microsoft can't...

Thank you for your response. Lets see if I understand correctly what you are telling me. The three boxes where they enter the data should be unbounded, but I should create a "build event" for those unbound boxes that will do the convertion, and make sure that it is under the "after update", so...

Hi, I have this form which contains a table with fields that they can enter in ounces, another field for pounds, and another for kilograms. I also have another field which is calles convt_grams. What I would like to do is allow the user to enter in ounces, lbs, or Kg, and the database to...

I got this report which is group by Police Officer, with an arrest date, incident, LastName, First Name, and Violation. The way it works now is that the officer may display a total count of 9 because there were nine Violations - which may include two violations for the same person. The problem...

Thank you, but the problem I have is that it works under Access 97, but not on Access 2000. Any other suggestions?

I have this report which runs based on a query. Under the criteria for the DATE field, I have put a >=[SDate] and <=[EDate]. My report works okay, but what I would like to do is print that date range. I cannot figure it out. Can anyone suggest anything? Thank you!