Search results

Thanks again Dr. Hunt for your help over the years. I have never asked anyone in UA or AWF about splitting a database or normalizing a table. Those are topics that folks forced upon me. I have said many times that I am not splitting. If that means my databases cannot exceed 2Gb then...

Well guys, I have decided to leave the Access community. Splitting a database makes no sense to me. 2Gb is is not enough for me. Standard normalization is a pain. I focus on graphics and speech in my applications, and almost no one else in the community does that. For me, the report is key...

Duane, What can I say, I misstate things from time to time. I just sent my family an email showing them how they will be able to track their grocery purchases. I want them to be able to track purchases at all stores, and then view only purchases made at Walmart and other stores in their...

Okay, Pete, you got me. I have a lot to learn.

Yes, Duane. One of the things that I learned circa 1998 was that databases are never finished. The same goes for any technology. Look at Word, Excel, and all the others. What I should have written is "When I distribute my database." My database will never be finished. You nailed it.

Thanks, Pat. I just talked to my brother in Florida about all the stuff that is happening in the world. He mentioned multiple shootings, multiple hurricanes, widespread flooding and fires. Being a volcanic geologist, I mentioned the likely eruption in Alaska. As you know, I track cases of...

You are right Pete. There's very little value in a graphic like this. I rarely look at these things. Years ago, I used Visio. But I really didn't use it to the max either. There's too much to these technologies for me to understand. So I do what I can to build useful applications...

I could also use the Filter command. No need for a query. It's even cooler. I can teach it to family members in a few minutes. It's right there in the Property Sheet.

Some lookup tables can remain in the FE. It depends on whether or not the household needs to update them or not. If the information in a lookup table comes from the internet, then that table needs to be updated. WIth thousands of diseases and new ones being discovered all the time...

Pat, my tables are mostly all different. Tables for Grocery are not the same as tables for major diseases such as diabetes. Early in the spring I used Cost as the field name several times, but when I moved into Health, I changed that so now I use DoctorCost, MedicineCost, HospitalCost, and...

Pete, Number 1 does not apply at all. My brother lives in northern Florida, I have a sister in Miami, a son in Denver, a brother in Southern California and one in Massachusetts. They won't be using the same datasets. The database is probably the same as MS Money. Number 2 is about the same...

I don't think so. Consider the symptoms of diseases, for example. Some symptoms of diabetes are different from those for kidney failure, heart disease, and dementia. I don't want everyone to have to scroll through 200 items when only 15 are possible for their condition. So I have a list of...

Thanks, Pete. I had to reply to so many posts this morning that I forgot yours. Folks wanted to beat me up for many reasons, I always try to thank everyone. Unfortunately, they don't know what I accept and what I save for later. I actually don't reject anything. But I just don't have...

Sorry about that BlueSpruce. Thanks for all of your help. I very much appreciate everything you have written. As I have said repeatedly, this application is for a special group of people. They are not techies.

Thanks Pete. My use of lookups is very simple-minded. Most of my lookup tables work with MVFs. They are contextual, so the user usually only sees just a few attributes about a specific topic. As I wrote a few days ago, I follow Clayton Christiansen's advice about limiting the number of...

Sorry Pete, I don't touch Google. I would remove it from my phone, but it is the OS.

Pete, my forms are a mix of data, calculated values, graphics (maps), and speech. The aggregated values in the main forms use data in the subforms, There are boxes that use conditional formatting. For example, if a person's A1C test result is over 7 a box turns red. If the A1C is low then...

Sorry, Pete, I can only send this database to family members via the US mail or by hand delivery. It has sensitive information. Some of the data falls under HIPAA.

Colin, they probably are not because I use MBTI to define them.

Actually, the only advice that I have not taken so far is to split the database and use more code. I see no need to use more code because macros do everything that I need to do. The only code that is needed for the speech. I have had that for almost two decades. And no one so far has...