Need a small program perhaps a query

[Bikini Browser]

Folks:

I am not a programmer so I need some help here... I need a small program
written that tells me how many days old my daughter is since she was born.
She was born September 26th, 2000. I am keeping a journal for her to read
when she grows up including photos and I want her to know how many days old
she is, each day I enter a journal entry.

I am willing to pay a donation to any one willing to help complete this
program.

The programmer will have to consider leap years. In fact, I would like the
program to allow me to enter any birth date I want and tell me how many days
it was since that date. This way I can use it for other members of my
family as well.

Can anyone help me?

Thanks in advance...

Dale

 

[Rick Brandt]

Folks:

I am not a programmer so I need some help here... I need a small
program written that tells me how many days old my daughter is since
she was born. She was born September 26th, 2000. I am keeping a
journal for her to read when she grows up including photos and I want
her to know how many days old she is, each day I enter a journal
entry.
I am willing to pay a donation to any one willing to help complete
this program.

The programmer will have to consider leap years. In fact, I would
like the program to allow me to enter any birth date I want and tell
me how many days it was since that date. This way I can use it for
other members of my family as well.

Can anyone help me?

Thanks in advance...

Dale

=DateDiff("d", [Your Date], Date())

 

[Guest]

Hi

Cteate a form with 2 fields (one of them could be your daughters date of
birth)
If it's not a date of birth then just make it an unbound box and set the
format to short date (for easy entering)

Use this as the control source for the second box

=DateDiff("d",[1stBoxName],Date())

Change 1stboxname to what you called the 1st box

I am willing to pay a donation to any one willing to help complete this
program.

You don't need to pay anything just wish your daughter a very happy christmas


--
Buon Natale, Happy Chritmas.

Wayne
Manchester, England.
Scusate,ma il mio Inglese fa schiffo
Percio se non ci siamo capiti, mi mandate un
messagio e provero di spiegarmi meglio.

 

[Bikini Browser]

Please help me... As I said I am not programmer so please forgive my silly
questions...

What type of Fields do I need? What do they look like? What buttons to I
select to create these fields? A combo box? A control Box? Bound object
frame? What?

How do I tell the first field that it should be a date? Or what kind of
field should the first box be?

How do I create a "unbound box" and how do I set the format to short date?


How do I use this as the control source for the second box?

Where do I enter this into: =DateDiff("d",[1stBoxName],Date()) ?

Could you do this for me and email the database to me? You can rename the
file to sinceyouwereborn.m_b because my email may not accept MDB Files.

Thanks in advance...

Dale

Hi

Cteate a form with 2 fields (one of them could be your daughters date of
birth)
If it's not a date of birth then just make it an unbound box and set the
format to short date (for easy entering)

Use this as the control source for the second box

=DateDiff("d",[1stBoxName],Date())

Change 1stboxname to what you called the 1st box

I am willing to pay a donation to any one willing to help complete this
program.

You don't need to pay anything just wish your daughter a very happy
christmas


--
Buon Natale, Happy Chritmas.

Wayne
Manchester, England.
Scusate,ma il mio Inglese fa schiffo
Percio se non ci siamo capiti, mi mandate un
messagio e provero di spiegarmi meglio.

Folks:

I am not a programmer so I need some help here... I need a small
program
written that tells me how many days old my daughter is since she was
born.
She was born September 26th, 2000. I am keeping a journal for her to
read
when she grows up including photos and I want her to know how many days
old
she is, each day I enter a journal entry.

I am willing to pay a donation to any one willing to help complete this
program.

The programmer will have to consider leap years. In fact, I would like
the
program to allow me to enter any birth date I want and tell me how many
days
it was since that date. This way I can use it for other members of my
family as well.

Can anyone help me?

Thanks in advance...

Dale

 

[John Vinson]

Please help me... As I said I am not programmer so please forgive my silly
questions...

What type of Fields do I need? What do they look like? What buttons to I
select to create these fields? A combo box? A control Box? Bound object
frame? What?

Create a Form. Use the Toolbar to put two Textboxes on the Form.

How do I tell the first field that it should be a date? Or what kind of
field should the first box be?

If you have a Table in your database, and it has a birthdate field in
it, set the first textbox's Control Source property to the name of the
birthdate field. If you just want a calculation for any date the user
chooses to type in, just leave the Control Source property blank -
that's what is meant by "unbound".

How do I create a "unbound box" and how do I set the format to short date?

Type the words

Short Date

in the Format property of the textbox.

How do I use this as the control source for the second box?

Where do I enter this into: =DateDiff("d",[1stBoxName],Date()) ?

To answer both questions in one go: type this (using the actual name
of the first textbox in place of 1stBoxName) into the Control Source
property of the second textbox.

Could you do this for me and email the database to me? You can rename the
file to sinceyouwereborn.m_b because my email may not accept MDB Files.

Try it yourself. It's NOT as hard as you're making it; no
"programming" is involved!

John W. Vinson[MVP]

 

[Bikini Browser]

John:

I finished the program you suggested and followed your steps. It all worked
fine, however, the program does not count the day you were born. It only
counts the days AFTER you you were born.

Knowing this, you just have to add a "1" to the number provided. Can you
tell me how to fix this problem?

Also, does code consider leap years?

Merry Christmas!

Dale

Please help me... As I said I am not programmer so please forgive my silly
questions...

What type of Fields do I need? What do they look like? What buttons to I
select to create these fields? A combo box? A control Box? Bound object
frame? What?

Create a Form. Use the Toolbar to put two Textboxes on the Form.

How do I tell the first field that it should be a date? Or what kind of
field should the first box be?

If you have a Table in your database, and it has a birthdate field in
it, set the first textbox's Control Source property to the name of the
birthdate field. If you just want a calculation for any date the user
chooses to type in, just leave the Control Source property blank -
that's what is meant by "unbound".

How do I create a "unbound box" and how do I set the format to short date?

Type the words

Short Date

in the Format property of the textbox.

How do I use this as the control source for the second box?

Where do I enter this into: =DateDiff("d",[1stBoxName],Date()) ?

To answer both questions in one go: type this (using the actual name
of the first textbox in place of 1stBoxName) into the Control Source
property of the second textbox.

Could you do this for me and email the database to me? You can rename the
file to sinceyouwereborn.m_b because my email may not accept MDB Files.

Try it yourself. It's NOT as hard as you're making it; no
"programming" is involved!

John W. Vinson[MVP]

 

[John Vinson]

John:

I finished the program you suggested and followed your steps. It all worked
fine, however, the program does not count the day you were born. It only
counts the days AFTER you you were born.

Knowing this, you just have to add a "1" to the number provided. Can you
tell me how to fix this problem?

Ummm... nothing fancy, no tricks! To add 1, just add 1:

=DateDiff("d",[1stBoxName],Date()) + 1

Also, does code consider leap years?

Yes. DateDiff() works correctly for any dates from 1/1/100 through
12/31/9999.

John W. Vinson[MVP]

 

[Bikini Browser]

Thank you John...

One last thing...

How do you make the form come up when you open the database? Considering
this is the ONLY purpose for this database, I was hoping I could make the
form come up so a novice does not have to look for it.

Any suggestions?

Dale

John:

I finished the program you suggested and followed your steps. It all
worked
fine, however, the program does not count the day you were born. It only
counts the days AFTER you you were born.

Knowing this, you just have to add a "1" to the number provided. Can you
tell me how to fix this problem?

Ummm... nothing fancy, no tricks! To add 1, just add 1:

=DateDiff("d",[1stBoxName],Date()) + 1

Also, does code consider leap years?

Yes. DateDiff() works correctly for any dates from 1/1/100 through
12/31/9999.

John W. Vinson[MVP]

 

[John Vinson]

Thank you John...

One last thing...

How do you make the form come up when you open the database? Considering
this is the ONLY purpose for this database, I was hoping I could make the
form come up so a novice does not have to look for it.

Any suggestions?

Open the database; on the menu select Tools... Startup.

Select the Form from the startup form dropdown.

One niggling question: DateDiff DOES calculate the number of days
correctly, and doesn't need the +1 you mentioned, unless you want a
child to be listed as already a day old on the day that she is born -
do you???

John W. Vinson[MVP]