caykamanj1966
Technical User
I hope someone can help me with this.
I have embedded datasheet on a Form.
I have to access an external database everyday to export the records as an excel file and paste them into my datasheet. These 2 databases can't talk to each other, because that has not been approved and probably never will.
I have to review these records to make sure they are not going to impact our program in anyway. If I do find records that will impact, my team and I have to assess how much of an impact it will be. They usually have a planned start and stop date.
Those records in the external database follow a workflow and they go through several stages/statuses, so they start out as Draft, then Notify, then Submit and finally Approved. Well of course these status changes don't happen all in the same day. With being said, I usually download the first round of records when they are in the Notify state, say on a Monday. Then when I come in on Tuesday I have download files again, well some of those files I downloaded on Monday, I will have to download again, because now they have changeds their status to Notify or Submit. So I don't want to add these records to my Access database, unless the planned start and stop dates are different.
What I want to be able to do is have the database actually show me the duplicate records maybe in a datasheet format and then I want the database to look and see if the duplicate records have differnt planned start and stop dates and if they don't, it deletes the older record automatically. But if that can't be done, I will just look at the dates and if I see it being the same, I can delete what I need to delete manually. But it would be nice if all of this can be done automatically.
I do not know how to code something like this or if this can even be done.
Can someone please help me with this? If I need to give more information, please let me know.
Thanks in advance!
I have embedded datasheet on a Form.
I have to access an external database everyday to export the records as an excel file and paste them into my datasheet. These 2 databases can't talk to each other, because that has not been approved and probably never will.
I have to review these records to make sure they are not going to impact our program in anyway. If I do find records that will impact, my team and I have to assess how much of an impact it will be. They usually have a planned start and stop date.
Those records in the external database follow a workflow and they go through several stages/statuses, so they start out as Draft, then Notify, then Submit and finally Approved. Well of course these status changes don't happen all in the same day. With being said, I usually download the first round of records when they are in the Notify state, say on a Monday. Then when I come in on Tuesday I have download files again, well some of those files I downloaded on Monday, I will have to download again, because now they have changeds their status to Notify or Submit. So I don't want to add these records to my Access database, unless the planned start and stop dates are different.
What I want to be able to do is have the database actually show me the duplicate records maybe in a datasheet format and then I want the database to look and see if the duplicate records have differnt planned start and stop dates and if they don't, it deletes the older record automatically. But if that can't be done, I will just look at the dates and if I see it being the same, I can delete what I need to delete manually. But it would be nice if all of this can be done automatically.
I do not know how to code something like this or if this can even be done.
Can someone please help me with this? If I need to give more information, please let me know.
Thanks in advance!