How to Set Active Period in a Table

80 pts.
Tags:
Access Records
Microsoft Access
Microsoft Access 2003
There is a table of multiYears record. Transaction date should be between Active Period. If any time I want to change/edit previous year record, first, i have to set that year as Active period. I have to select active period through a Form by dropdown Combo box option. When I select any year, this should set as active and previously set as active should be automatically set as inactive. Type of ActiveDective field is YES/NO. Please help

Software/Hardware used:
P-4

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Abdul30dec
    There is a table of multiYears record. Transaction date should be between Active Period. If any time I want to change/edit previous year record, first, i have to set that year as Active period. I have to select active period through a Form by dropdown Combo box option. When I select any year, this should set as active and previously set as active should be automatically set as inactive. Type of ActiveDective field is YES/NO. Please help Software/Hardware used: MS Access 2003/P-4
    80 pointsBadges:
    report
  • Meandyou
    You already asked this question. But this time you have some additional info, which leads to lots of question on my part... Why do yo need to set ACTIVE to YES in order to update other data? Seems odd. Generally, these sorts of "switches" are in place to stop any updates, for example the year has been "closed" by accounting. If it is "closed" you wouldn't want to update it without LOTS of other processing. It appears that the only thing this ACTIVE switch does is get in your way. You are changing the ACTIVE switch based on activity, not on anything else. What will you do when you have 2 users accessing different data? You want each one of them to set his row to ACTIVE and set everything else to inactive. You will have lock contention problems. If you absolutely have to use this ACTIVE setting, then I would set it to ACTIVE at the beginning of my transaction, do my work, and set ACTIVE to inactive at the end of my transaction. Something to think about.
    5,220 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following