Sorry folks, Access World will not accept my posts

[Gasman]

I would be very interested to see who here (if any) actually use animations in their DBs.
Same applies to any audio.

 

[NauticalGent]

I would love to make a profit Doc, however, advertising revenues for the site are less than 1/10 of what they were prior to covid and hosting costs have gone up.

Does AWF even have a means to accept contributions anymore?

 

[Jon]

Does AWF even have a means to accept contributions anymore?

Not anymore, although I keep meaning to add a "Buy me a coffee" link.

 

[CJ_London]

I would be very interested to see who here (if any) actually use animations in their DBs

I use some controls that (appear to) rotate to show a different value and one that shakes if a duplicate value is entered (rather than a msgbox)

I also have forms that grow/shrink rather than than just appearing/disappearing

Just to provide a visual clue that something is happening and draw the users attention

Most effects are designed to work over a second or two

 

[The_Doc_Man]

My only purpose in starting this thread was to tell folks why I wasn't responding to them and that I wasn't being disrespectful.

I appreciate every comment that those two threads received. Thank you, thank you, thank you.

I am still interested in learning how folks add animation to their applications. I may start another thread on the subject one day when I hit the 100-post mark. It is a technique that I would like to add to my applications.

Know that if you post to my first two threads on AW, I won't be able to respond to you. I can read them, but that's all.

I believe that is incorrect. If you can find whatever it is that contains the link and remove it before hitting Post Reply, you should be able to post. You have posted in this forum, after all, and yet haven't hit the 100 post barrier.

 

[Gasman]

My only purpose in starting this thread was to tell folks why I wasn't responding to them and that I wasn't being disrespectful.

I appreciate every comment that those two threads received. Thank you, thank you, thank you.

I am still interested in learning how folks add animation to their applications. I may start another thread on the subject one day when I hit the 100-post mark. It is a technique that I would like to add to my applications.

Know that if you post to my first two threads on AW, I won't be able to respond to you. I can read them, but that's all.

Just post in the empty box at the bottom of the thread, and use your normal method that you used on UA.
Note that you could hit reply to this post and respond,as no links are contained in it.
Try it and see.

 

[DakotaRidge]

Not anymore, although I keep meaning to add a "Buy me a coffee" link.

Jon, what's your Starbucks account number?

 

[DakotaRidge]

Joan, yes I am signed up with the CDC, FDA, and USDA for food recalls. I also receive announcements from MSN.

I load the information into my database so I can broadcast it to my family members around the country. Most of them do not track recalls of foods and medicines. They rely on me.

I know who to inform about a recall based on the states where contaminated foods were shipped. This is why I added a map to my database. There are several forms in the database for recalls. In addition to maps, there are also ones just for adding detailed information and understanding the impact of eating contaminated food. The forms also track actions such as 'Saw the doctor' and 'Took OTC med.' This is information that a person can report to an insurance company or a government agency.

.

 

[GPGeorge]

Joan, yes I am signed up with the CDC, FDA, and USDA for food recalls. I also receive announcements from MSN.

I load the information into my database so I can broadcast it to my family members around the country. Most of them do not track recalls of foods and medicines. They rely on me.

I know who to inform about a recall based on the states where contaminated foods were shipped. This is why I added a map to my database. There are several forms in the database for recalls. In addition to maps, there are also ones just for adding detailed information and understanding the impact of eating contaminated food. The forms also track actions such as 'Saw the doctor' and 'Took OTC med.' This is information that a person can report to an insurance company or a government agency.

View attachment 120807View attachment 120808.

Hypothetical question:

USDA announces a recall of eggs due to salmonella contamination.

I don't see the announcement myself.

The next day I go shopping at the local chain supermarket where I buy eggs.

How likely am I to buy salmonella contaminated eggs? I.e. what are the odds that the chain supermarket either doesn't yet know about the USDA mandated egg recall, or continues to sell potentially contaminated eggs despite knowing about the recall?

 

[Isaac]

Not anymore, although I keep meaning to add a "Buy me a coffee" link.

You should

 

[Isaac]

Hypothetical question:

USDA announces a recall of eggs due to salmonella contamination.

I don't see the announcement myself.

The next day I go shopping at the local chain supermarket where I buy eggs.

How likely am I to buy salmonella contaminated eggs? I.e. what are the odds that the chain supermarket either doesn't yet know about the USDA mandated egg recall, or continues to sell potentially contaminated eggs despite knowing about the recall?

I've no idea where this came from or what conversation it entails, just answering your question blind:

If it's the very next day, you might stand a significant chance, but as time goes on, it seems that, at least in the USA, and under current conditions of corporate recall compliance, you'd be pretty unlikely to buy the tainted eggs.

Now what did I unwittingly get myself into?

 

[GPGeorge]

I've no idea where this came from or what conversation it entails, just answering your question blind:

If it's the very next day, you might stand a significant chance, but as time goes on, it seems that, at least in the USA, and under current conditions of corporate recall compliance, you'd be pretty unlikely to buy the tainted eggs.

Now what did I unwittingly get myself into?

Post #114 right before I posted it in Post #115

 

[Isaac]

Ahh. Maybe I see what you are getting at. Companies I think seem pretty darn compliant with recalls - the lawsuits are too expensive for them to ignore it.
Even when it's something incredibly stupid, "I banged my head on the car and I got a painful bump on my head" - bam recall the car, there was no warning for that specific act.

 

[GPGeorge]

Post #114 right before I posted it in Post #115

I've no idea where this came from or what conversation it entails, just answering your question blind:

If it's the very next day, you might stand a significant chance, but as time goes on, it seems that, at least in the USA, and under current conditions of corporate recall compliance, you'd be pretty unlikely to buy the tainted eggs.

Now what did I unwittingly get myself into?

I suggest that the likelihood a consumer would have food recall information prior to a chain supermarket having that information is probably not all that great.

However, that might depend on how far out in the hinterlands the store is located and whether the store manager is concerned about food safety and also has access to that kind of information, oh say, through a corporate communication of some kind.

My point is that tracking recalls in a home-grown Access database might or might not prove to be a great addition to my daily routines.

 

[DakotaRidge]

Hypothetical question:

USDA announces a recall of eggs due to salmonella contamination.

I don't see the announcement myself.

The next day I go shopping at the local chain supermarket where I buy eggs.

How likely am I to buy salmonella contaminated eggs? I.e. what are the odds that the chain supermarket either doesn't yet know about the USDA mandated egg recall, or continues to sell potentially contaminated eggs despite knowing about the recall?

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 a long shelf life. Yesterday, a friend in California sent me information about black plastic kitchen utensils that disperse microplastics when used.

My take is to track food and medicine recalls as best you can. Sign up with the CDC, USDA, and MSN to get information. You may miss ones here and there, but at least you are making an effort to protect yourself.

Do the same for recalls of meds. I track Metformin recalls myself. In the past few years, 500 mg Metformin has been recalled twice to my knowledge. When my doctor cut my dosage from 1000 mg to 500, I told him no. I told him to keep prescribing 1000 mg, and I will split them in half. That is what I have been doing for the past three years. I refuse to take 500 mg Metformin pills. I probably save a few dollars this way, but I don't trust the manufacture of 500 mg pills.

The other thing is that few food recalls are nationwide. When you track recalls, look for the state(s) where the product was recalled. If your state is not on the list, you may want to ignore the recall. But don't ignore states where you have family members.

Some announcements do not tell you which states received a product. That makes it difficult to track distribution.

Also, check for the plant ID and the stores that received the recalled product. My database does all of this, but the announcement has to be complete. Some agencies give only some of the story. The database tells family what information to look for in announcements.

Folks may need to check two or three sources if a recall is Class 1. Class 1 is the highest level recall. If a recall is Class 1, pay more attention to it.

The database also helps you understand the symptoms to look for and how long they may last. Some events can last a few days, and you can get back to work soon.

The database also suggests what to do if you eat contaminated food. That can save your life or a big hospital bill if you live by yourself.

And finally, the database can tell you if you are more sensitive to an illness than other people. It uses your age and race for this purpose. Many recall announcements say that young kids and senior citizens are more sensitive. Sometimes a Black or Asian person is more sensitive.

Yes, this can be a lot of work. Create a health database and get into a family to share the work. You are better at Access than I ever will be.

Oh yeah, check your cupboards occasionally for recalled products. That old bottle of wine could have floaters.

HTH.

Here's a screenshot that shows my Recall Map with two of my friends. The purple states are where my family members live. My friends say Hello and Stay Safe! I posted another screenshot above.

 

[DakotaRidge]

Hypothetical question:

USDA announces a recall of eggs due to salmonella contamination.

I don't see the announcement myself.

The next day I go shopping at the local chain supermarket where I buy eggs.

How likely am I to buy salmonella contaminated eggs? I.e. what are the odds that the chain supermarket either doesn't yet know about the USDA mandated egg recall, or continues to sell potentially contaminated eggs despite knowing about the recall?

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 the clerks about it. He had no knowledge of the recall. I did not ask the pharmacist.

I have never asked one of the people in the vegetable area about recalls. So, I have no idea how grocery stores track and respond to recalls. The fact that contaminated food causes illness and death from time to time suggests that contaminated food does get past the system.

As I suggested above, you need to know the symptoms of contaminated food so you can correctly respond to an illness. You need to know when to reach for an OTC, call your physician, or check into the ER.

 

[DakotaRidge]

News nowadays travels real fast on the internet and TV. I keep the Bloomberg and CNBC channels tuned throughout the day and have heard several recalls on them because they have an immediate impact on those companies stock values.

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 area. The impact area can expand from a few states to several. Some recalls are nationwide.

Sometimes a product comes into the US from other countries. This was the case with a recent fish recall.

I don't have enough information yet to say which products, stores, or producers to watch more closely, but that is my goal. I am still building the forms and reports in my database.

Let me know what analyses I can implement. I want to address things like "Store XX has more recalled veggies or eggs than most stores in the area." Similarly, "Most recalls of BxBxBx occur in the summer months." Another is. "Most recalls involving salmonella are Class 1."

Some weeks, I see two announcements. I haven't used Bloomberg or CNBC.

 

[The_Doc_Man]

However, if man keeps playing with fire by engineering viruses, it could wipeout civilization.

Well, YOUR name just went on the Chinese Communist Party's list.

 

[The_Doc_Man]

I've been on that list for a long time. They've been screwing us for a long time and I have been boycotting anything made in China since the 1970's. I have never trusted them. I don't even eat chinese food.

If it weren't that our favorite Chinese restaurant is run by Filipinos, I might boycott them too. However, at the grocery, we only buy domestically caught shrimp, crawfish, and crab meat. At the moment, local crawfish are $20 a pound whereas Chinese imported crawfish are $8 a pound. But we still don't buy Chinese goods if we can help it.

 

[DakotaRidge]

I avoid consuming products that have shown a repeated pattern of contamination. I also avoid products produced in Mexico, China, and other foreign countries. In some countries they use human manure fertilizer and that exposes you to bacteria your body has not been exposed to before, aka Montezuma's Revenge. Sometimes contaminated water is used for irrigation which incubates E.Coli. The FDA and Customs don't seem to properly scrutinise imported products. Walmart is notorious for selling contaminated products, so I don't buy everything there. I buy meats and vegetables only at Publix Supermarkets because they thoroughly inspect perishables. I also inspect before buying perishables. I have even seen Publix remove products that are about to expire, or when refrigeration fails to maintain proper temperature. I have never seen rodents, roaches, or flying bugs inside Publix. They always keep their stores clean and proper ambient temperature. All of that doesn't guarantee I will never consume a contaminated product, but it certainly minimises the chances. Another alternative is to grow your own food, but then you have to frequently care for it, a fulltime job.

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 failure, and cancer. There is also a Recalls subdomain in the Medicines domain. I add a new subdomain every few days.