Access Question

[Al Neri]

OK I'm writing a simple database that has an employees name and the date they started - I want the user to input any date - and it to calculate the amount of days (or divide it by 365 and have it output years) and output it to an excel file.

I wrote the query - it works, when I run the query - an input box comes up - asks for the date - i reformat the date depending on how it was given to me - and store a value for the days and years calculated.


How can I have this occur in a form?

i.e. the user puts the date into a text box - the form is reran and an excel sheet is generated?

all the "hard work" is done - i just need to know how to do the small nuances.

Thanks in advance,

Don R.

 

[JACKDRUID]

if i remember correctly

in criteria


FORM!"name of form"!"name of text box" to reference to the text box in access

edit: NM above

use event in the form text box would be better.

 

[KLin]

So you want to have a button that will output the form data to a excel spreadsheet? Do you want it to be based on the number of days between the hire date and today's date, or a date the user specifies?

 

[Al Neri]

a date the user specifies.