How to auto generate a table entry by date

[ems2000]

Hi, I have a WO table with a field last completed and a Fq field. I want to be able to automatically add an entry in the primary table WO, when the last completed date plus Fq, is achieved. IE Last completed date of 7/7/09 and a Fq of 10 would add a table entry on 7/17/09. I have tried many options such as duplicate record, but wanted this to work automatically.
Any ideas.
Gord

 

[pbaldy]

If you're saying that on 7/17/09 you want the entries like the example to be created, I'd probably create a utility mdb that just did that, then call it from Scheduled Tasks as appropriate. You'd use the DateAdd() function with your 2 fields to determine which records should be added.

 

[ems2000]

If you're saying that on 7/17/09 you want the entries like the example to be created, I'd probably create a utility mdb that just did that, then call it from Scheduled Tasks as appropriate. You'd use the DateAdd() function with your 2 fields to determine which records should be added.

Hi Paul,

Thanks for the info, however, you are talking about utility's beyond my level of expertise. Can you please tell guide me to an area where I can learn a little more about the MDB utility and schedule task manager as that would appear to resolve the concern.

Thanks, Gord

 

[pbaldy]

Well, that was probably a misleading way of saying it. I meant I would create a separate mdb that just did this one thing, then shut itself down. You can use an autoexec macro to start the process. Scheduled Tasks is a Windows function; Start/Programs/Accessories/System Tools.