473,372 Members | 1,429 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,372 software developers and data experts.

Entering multiple preset values in a table that is different with each new record?

15 Byte
I have 2 tables, one called Reminders and the other one is named Preset Events. The tables are not joined. The Preset Events table mirrors the Reminderís table except it does not contain the Date field or the Personís ID associated with the event. The Preset Event table contains default values for a given event, i.e. for a wedding anniversary, I may want to be reminded yearly and given a notice 2 weeks before the event. The duration for this single event is to remind me for the next 10 years. Another example is after closing a transaction, I want to be reminded a week after the event to send a thank you note. Some events would be recurring for different persons (wedding anniversaries for example) whereas some reminders may be just a onetime occurrence.

With over 40 different events, the purpose of the Preset Events table is to maintain consistency and speed of entry. Currently, I can enter a Reminder in either of 2 ways; manually in the Reminders table using a form of course or by selecting a preset event from a combo box whose record source is the Preset Events table. After selecting a preset event from the combo box, the default values are then copied to the Reminderís table from the Preset Events table where I can then just enter the date to be reminded.

Is my method a good strategy, or is there a better way to accomplish this? Your thoughts would be greatly appreciated.
Expand|Select|Wrap|Line Numbers
  1. tblReminders
  2. ReminderID PK
  3. rPersonID
  4. rDate
  5. rEvent 
  6. rLength 
  7. rDuration 
  9. tblPresetEvents
  10. PresetID PK
  11. peEvent 
  12. peLength 
  13. peDuration 
Feb 19 '21 #1
5 1905
32,556 Expert Mod 16PB
I would say that sounds like a good approach. Another, or at least a way to extend that, might be to include data in your extra table so that certain types of events can be created for every year going forward - like birthdays. A wedding could be set up to trigger special anniversaries at 5 year intervalsas well as lesser anniversaries each year of course.

At the end of the day, how complex you make it depends on you, but certainly what you suggest is a good basic step to simplify data entry.
Feb 19 '21 #2
455 Expert Mod 256MB
As an alternative, just use a single table and run an annual update procedure to reset each of the dates for the following year.
I have used that approach for over 15 years to reset school calendar event dates for the next academic year
Feb 19 '21 #3
15 Byte

I have read many of your other posts in the past. They are always well thought out and you always give deeper insight that the original poster may or may not have considered. So thank you for sharing your thoughts.

I had grappled with joining the tables, but did not think it was a good idea when I had to enter a onetime reminder. Our thought process is similar. I have other fields to give me greater flexibility. Instead of creating new reminders for each person yearly, I set mine's up one time with my desired frequency and then I set the duration for a long time in the future. Like for a birthday, I would set the duration of the reminder to be 50 years or so, so that I don't have to think about it anymore. For anniversaries, I coded the reminder to include the age of the person's birthday or anniversary (10th Wedding Anniversary). When the last reminder arrives, a popup statement advises me so that I have the option of extending it or not.

Again, thank you very much..
Feb 20 '21 #4
15 Byte

I had not thought about setting it up that way. I appreciate you responding.
Feb 20 '21 #5
455 Expert Mod 256MB
Just for info, the annual update process can easily manage the type of repeat events you mention as well as more complex events such as those occurring:
1. On the first Monday in September or the third Friday in December etc
2. Every two weeks on Tuesdays but in term time only
3. On the second Wednesday after Easter (which of course varies every year)
and so on...
Feb 20 '21 #6

Sign in to post your reply or Sign up for a free account.

Similar topics

by: Joe User | last post by:
Hi all....I have a feeling this is going to be one of those twisted query questions, but here it goes anyways.... I want to generate a report that shows the chronology of events (represented by...
by: Hi5 | last post by:
Hi, I am designing a database for a client in which It has a client table including the followings: 1-Table Client 2-Table lookupcategory 3-Table Ctegory
by: mike | last post by:
Hi All I have a listbox which has a table as its row source. I want to be able to choose from this listbox (which has approximately 8 records) and have this value entered into another table (it...
by: ricky.agrawal | last post by:
I'm really not sure how to go about this in Access. What I've created is a table for each location. Those tables are identical in format but different in information. The tables are named after...
by: veaux | last post by:
I have a table that looks like below: Name, Address, Favorite Pet Bill Smith, 123 Smith St, Dogs Bill Smith, 123 Smith St, Cats The "Dogs" and "Cats" are actually in a lookup table, but have...
by: Marcelo | last post by:
Hi, I have the following need: I list a table from an access database but cannot interact with each record. At the html page I display all records, one field (field1) from and 3 buttons for each...
by: jessica892 | last post by:
I work at a college and have created a report that automatically retrieves the instructors name, class number, class name and the scores that instructor received on his evaluations. Right now the...
by: sjohnson1984 | last post by:
Hello all, I have a form which is generated using a database query - the recordset is filled with agent details, login time and the like, and there are as many rows in the table as records in the...
by: QntmPg | last post by:
Hi all, I have read through what I could find on previous questions regarding using the OpenArgs property, but I'm still not able to get my form to open correctly. I'm not sure exactly where the...
by: Catalyst159 | last post by:
I have a linked table called "dbo_tblNotes". dbo_tblNotes has the following fields: id (Data Type = Number, Indexed = No) note (Data Type = Memo) addDate (Data Type = Date/Time) uid (Data...
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.