Calculations

[gianina]

Hi Everybody,

I created a database in which I would like to do a calculation.
My database is about "calibrations" and contains data about different tools. Included in the database are 2 fields called "Last Calibration" and "Next Calibrations". These are date fields.
What I would like to have is a button that shows the upcoming calibration date (next calibration) for tools which are about to be due. For example it would be awesome if by the push of that button a report would open and say "Tool C23 is due on 23-Feb-07".

Is something like that possible ???

Also, is there any way that Microsoft Access would do the calculation above and send the report via e-mail to a certain person (let's say -- 15 days before the tool is due for calibration) ???

Any input is appreciated.

Thanks very much.

 

[Remou]

Yes, it is. Here is the start of an idea:

[tt]strSQL="Select * From tblTools Where CalibrationDate=#" & Format(Date()+15,"yyyy-mm-dd") & "#"[/tt]

 

[gianina]

Hi Remou,

Thanks for your response.
I am not sure what to do with your code, I'm not very good with Access.
Can you explain please ?

Thanks.

 

[Remou]

A good place to go from here is some reading. For example, in this: Process Email Reminder, >= Form Date?
thread702-1242091
You will find that misscrf is doing something similar to you. There have also been several more recent posts on selecting people by date.

The Access fora:
Microsoft: Access Forms Forum: forum702
Microsoft: Access Modules (VBA Coding) Forum: forum705
Microsoft: Access Queries and JET SQL Forum: forum701
Microsoft: Access Reports Forum: forum703
Microsoft: Access Tables and Relationships Forum: forum700
Microsoft: Access Other topics Forum: forum181

 

[gianina]

Hi Remou,

I read the topic created by misscrf but honestly I don't know what to do ?

Help....

 

[Remou]

I can help a little, but you will need to help yourself more. First, create a query from the table that has the dates in it, then post the SQL back here.

In the meantime, read everything you can get your hands on. If you spend five or six hours a day reading about VBA and checking out the forums, you will learn a great deal.