Search results

Thank! That work to a point. But you are right a query is better.

It has been a while since I have been on this forum. I would like to know if there is a way to have a message pop up on a form when a date is about to expire. I have a database that deals with goals for youth. The goals have an estimate expire date (never pass a year) Our problem is we have 500...

Thanks alot Pat! This did work. I was in the right direction, I just did not have the relationships right. So I follow your direction and saw my mistake. Regret I did not seek advise earlier. This is a great site. Vaughn

Thanks! I will try this.

This problems seems real complicated to me. I have been working on it work several weeks. There is definitely something I don't understand. I have a database that is set up for a youth program. The primary field is SSN. The data base has demographic and it tracks up to 3 goals and...

I will try that. I checked again, the primary key was set for SSNs and the index was set for Yes, no duplicates on SSNs and I still can type in duplicates. Last week, I could not do this. It must be glich.

Thanks! But the Primary key is set. For some reason the (Yes, No duplicates) is not working. Is there something else that could be wrong? Thanks for any help you can provide

I have been working with this database for about 6 months. I set the Index on the primary key to a value of Yes(no dupicates) I use SSN# as identifer. This has work fine. I could not enter the same SSN# without an error. My computer was hit with a power surge and the power supply was...

Thanks, that make sense.

About a month ago, I asked how to convert birthdate to numbers. And the advice I got was great. But lucky for me, it has bitten by in the a. I have to go by the original age at the time the youth registered for program. Is there a way to convert dates to a number with out updating birthdate...

Is it possible to convert a Word form into an Access Form. I want to enter data then print the form to sign. Am I asking to much. Thanks for any help.

Thank you. I have figured out the problem.

This may sound easy to some of the expert advice on this forum but I am lost. As you probably heard before for those who see my postings. I have a database that tracks youths. What I am trying to do is have a enter parameter in a form that will give the values for which youth has completed a...

Once again I need help. Our Tech support upgraded my access from 2000 to 2002. I think that is right. Now when I create a query from two difference tables I get an error saying "Type mix match expression" Does any one know what this means. I have two tables linked by ssn# One table has...

Thanks to all of you for your help. Your suggestions were very useful. However, raskew your formula worked best for what I was after. This is a great forum!

Thanks! I think it is going to work.

The format is: 1/01/2002

It has been a while since I used this forums but it is a good one. My question is: I want to run a monthly report using a query where I don't have to go to the query each month a change the dates to get the current month. Is there a way to do this. I also want to set up a switchboard that...