How to link 2 dates, if I enter one date the other appears? 1

[Husameddin]

I want to create a maintenance record for buses (for example). for some buses the maintenance is once every month and some is once every fortnight. What I want is, when I enter the last date that the bus was serviced, the next maintenance date appears automatically.

Please help me

 

[RobBroekhuis]

Tell us more about how you're implementing this. Why would you want to use VBA to do this, instead of worksheet formulas? What determines the frequency of maintenance?
Rob

 

[Husameddin]

Thank you for your reply
I am new to access and I thought that the vba codes is the only solution for this
I will explain more
I want to create a form of bus maintenance record, and this record must indicate clearly the date of the last and next service inspection, I have table of the maintenance schedules and I know for example that bus A must be serviced once every month, so I want when I put the date of the last service (which I know) the date of next service come up.
the user doesn’t know when the bus must be serviced what he has to do is entering the date of the last maintenance which he knows and the form will tell him when the next service must be.
If there is anther way to do this without using vba codes can you tell me please. I am using ms office xp

example: bus A

date of last service date of next service
1/2/2003 1/3/2003

Thank you for trying to help

 

[RobBroekhuis]

Ah - you're working in Access. I'm afraid I won't be of much help (I was assuming Excel). Someone else will be sure to help you!
Rob

 

[SkipVought]

Seems to me that you should have a table - Maintenance Frequence - for each bus. That ought to solve the dilema, no? Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[xlbo]

I very much doubt you'd need VBA for this. Skip's suggestion for a Bus Maintanence Schedule is definitley the way to go. How it would be used very much depends on how you want to show the results - whether it is one bus at a time or an exception report for all buses that are due a service.....whetherit is in a table or done via a query or shown in a form / report..... all these possibilities would require different setups to work.... Rgds
Geoff
"Some cause happiness wherever they go; others whenever they go."
-Oscar Wilde