Recent content by chiara

Thanks for all your help, I fixed it. Couldn't have done it without all of your advice.

Problem with storing the dates as dates is that the entry may only be a partial date, such as a year without a month or day. In order to adapt to this I included "unknown" for the month, and 0 day and 0000 year. 0/0/1989 is not a valid date. But, you say I can convert the separate data entry...

Just to clean house I did what you recommended Kodo. Also, I made a new query in which to run the calculation, rather than running it in a text box on the form. This way I only reference 5 tables and 1 query (instead of 2). This is working fine, except I still can't enter new records, and I'm...

Does it matter that the function I'm using is only referenced in the text box on my form? It's not present in any query, it's merely using the results of an expression (which exists in a query) for it's calculation. Does that make a difference? Edit: Good advice Kodo, I think I may do that.

I know what's wrong with my query, but I don't know how to fix it. Attached is a screen shot of the relationships in my query. You'll notice I reference 5 tables, and 2 queries. The two Queries contain expressions for combining fields in the tables with date of birth and date of death info...

I love you, I love you, I love you ALL!!! It's working like a charm and I could just kiss every one of you. :D THANKS!! The Demo ended up making the difference for me, that was great. THANKS AGAIN! My heroes.

First off, thanks for all the input, looks like you guys are having fun. I'm with the guy above me. As nice as the CalcAge function is, I kinda don't know what to do with it. I've tried using it as an event procedure on my data entry form, but that didn't seem to work. I'm thinking maybe I'm...

My apologies if this has been posted somewhere in this plethora of information, but in my search I couldn't find it! I've built a dbase (with Access 2000) for a cemetary in order to log information about the persons buried there. The folks at the cemetary are currently inputing old info (from...