Search results

Family members will be able to add other diseases and items to the database. Every MVF in my database uses a lookup table to edit data and that includes all of the MVFs in the Diseases subdomains. Each lookup table has a form for editing the information. Family will be able to add new...

CJ, I expect that some but not all family members will copy blocks of text from the web into the database. This is why many of the textboxes are large enough for extra words and sometimes a second sentence. When I expect a lot of text to be pasted into a form, I use Long Text fields...

Everyone, I don't plan to be involved in maintaining the database once I send it out to my family members. It will be their job to add their personal financial and health data to the system. This is like most COTS were in the day. Think of MS Money, not Quicken. I consider all of that data...

Duane, I forgot to say that more than half of my family members don't use the Internet. It will be a real challenge for me to get them on my system. I know this for a fact and I accept the challenge.

Thanks, Duane. I have a Cost field in the med records table. I have cost fields throughout the database for everything that I can think of. I also have fields for sources of information for Mayo, Cleveland, CDC, FDA, and for each MSN article that a family member may use. The Health section...

Duane, how would you record expenses related to doctor visits if you also record medical test results for each member of your family? Here's part of the medical test result dashboard in my database. The dashboard uses conditional formatting to indicate if a person's test results are in or...

Yes. Duane. I send one or two emails almost every day to family members to describe features in the database. Some folks get it and some don't. I can tell that folks are paying attention because they send me URLs that I can use to populate tables in the database. The only data that a person...

When I added colonoscopy to the database back in February, I had made two or three trips to gastro doctors with a family member. I wanted to capture the preparation, medicines, effort, and costs in my database.

Folks, I should also say how I get ideas for my finance and health database. I find one or two ideas every day on MSN. These ideas are commonly in slide decks with information about a specific topic, such as good foods to eat or foods to avoid. MSN articles commonly have ten to sometimes 25...

Dave, I would say that that is true. The database already has several navigation forms. I call one the Master, but it is several months old. I have run out of space to put more buttons on it. I am waiting for large monitor support. One navigation form is for Finance, and one is for Health...

Hi Duane, I have so many tables because my database does many, many things. It has two major domains: personal finance and health. Finance addresses income and expenditures. The expense domains include utilities, insurance, groceries, home repairs, etc. The grocery domain considers...

Thank Dave, I don't have a different table for each family member. I am not sure why you think I do. And I do not have a different table for each grocery store, food recall, utility company, disease, medicine, and physician. There is a command button on one form for Walmart stores because most...

BlueSpruce, my data aren't normalized. When I ask folks if every table should be DKNF, no one ever ever says yes. Last week, my health database had 450 forms that were populated by more than 400 tables. This week, that database has 550 forms. On average, every table in the database has 20...

To connect with another thread, I should mention that nine of subdomains in the two domains above have MVFs. I will fix that in the next few days by adding MVFs to other subdomains🦖.

Doc_Man, I boycotted Louisiana crawfish for several years. After the oil spill in the Gulf, those crawfish were contaminated. They were black and they did not taste the same as they did before the spill. I was surprised that the government did not take them off the market. I suppose it was...

That's great BlueSpruce. I have only been compiling information about food recalls for a few months. Avoid Foods is one of 12 domains in my database. I have several subdomains in Avoid Foods. Some of the subdomains address foods to avoid if you have such diseases as diabetes, kidney...

Excellent BlueSpruce. My database has a field for storing URLs, so you can revisit a recall announcement if you miss something important. Also, know that the government updates recall information from time to time. One piece of information to look for is the expansion of the impacted...

George, I forgot to respond to one part of your question. I suppose a supermarket chain could fail to remove a contaminated product from one or more of its stores. I don't know for sure. When 500 mg Metformin was recalled the last time, I went to the pharmacy where I shop and I asked one of...

Also, understand that the USDA may not announce a recall immediately. I read recently that this happened after USDA staff was cut. If you are unaware of a recall, you could purchase the item and get sick or die. And you could have purchased a contaminated item weeks or months ago if it has...