Search results

Great - Thanks for the example. I did a quick run of it and saw it worked! I will try to incorporated it later today. I have to do some productive work for a little bit. I spend 3 hours plus so far on the silly age thing. I could have manually figured it out for the 101 persons, twice...

Re: Trying a new module now Bob - ok I am trying the code from post 10 - i think i installed it in the db. I was not sure how to "go to the immediate window and test, e.g.:" I think you mean to start a new query with just "ageinyears(#4/1/53#, date())" 55 i tried that and failed please...

Re: Still trying to calculate an age with DOB? I did this one "AgeYMD([Members].[DOB];Date())" without the quotes and still received a syntax error the message on the Run was = "The expression you entered contains an invalid syntax.: and then tried this one "AgeYMD(([Members].[DOB]);Date())"...

namliam - I did as you said "AgeYMD(Yourdatefield,Date())" without the quotes and still got a error "Compie error. in query expression 'AgeYMD([members].[DOB],Date()". Attached is a screen image of what I have. Please direct thank you.

So, neileg - you are saying I just open the expression builder and type "DateDiff(Members.DOB Date())" without the quotes and it the query will display the years old of a person?

So I put this "AgeYMD(DateSerial(1956,11,5), Date())" into the file box after clicking the "Expression Builder" and replace "DateSerial(1956,11,5)" with my field name, that is table.field, which is for me "Members.DOB". This was not all so obvious to me. Will I did and got the message...

Re: here is the routine i installed below is the routine Option Compare Database - Calculating a person's age in years, months and days To accurately calculate a person's age in years, months and days, and (optionally) return that age in words, use the following syntax...

My screen image thingy was too big. So, I reattached with it. I have a module added I think to do the code. I just do not know how to use it.

I installed one "function" for this yesterday. This is i.e. like VB. Can you gave me instructions on how to use it. Attached a screen print of the "function".

Slowly getting there I am trying this in my expression and getting a syntax error now; "AgeYMD [(Members.DOB) (Stays.Start Date)]" I added the function i think: Under the objects - Modules - I have AgeYMD. Can I get some more help - thanks. Russ

Ok i am getting closer... How do I store the above function in my DB and use it?

I do not have the module: 'AgeInYears' stored in your database? - if needed how would i add it ?

You are right the field with the simley is "members:dob" why it displayed has a simley is beyond me as usual. Thx Rus

I have a DOB on the database. Table = Members Field = DOB I seen this as a formula - “AgeCalcField: AgeInYears([DOBField], Date())” - Within my query I do this I click the field box and coded an expression as listed here and get a syntax error: “AgeCalcField: AgeInYears([Members:DOB]...

Thanks - I have it working with this in the criteria box "<Date()-90" Russ

Thanks I got it working with putting this in the criteria box <Date()-90

I am trying to create a simple querry in ms access to pull rows from a table with dates in the record where the date is are over 90 days behind the date of the current date. I tried = "<#Date()-90#" without success. Thank you for any input Russ @ scaninc.org

We like to create Outlook emails from Access is this possible? Thanks for any help. Russ @ ScanInc.org

Re: FIXed On copy of DB - Switchboard not working FIXed - I added my document folder as trusted location. The IT guy here did not know what the problem was either. There was no stop message or warning the switchboard just did not work, while if open in design mode the queries all worked. Who...

I have a MS-Access DB on a network drive. I am using MS-Access 2007. When I copy the file name.mdb to my local drive C: my documents. I can open the file within My Documents. The switchboard appears but nothing works?? The icons for reports, forms, queries and blink and do not take any...