Search results

Yes, Pete. The operation is to remove specific records from the database. For example, one table stores credit card information, and the person may not want an adult child to know about a transaction. Similarly, a person may not want a spouse to know that he has kidney disease. He could give...

Mark, My approach now is to send the database to family members on USB drives when I am happy with it. I will continue development but I don't plan to send it out for several months or a year after that. I may ask family to send me their USB drives so I can copy the new database for them...

Now I understand what AWF wants to prevent with its rule. I am seeing all sorts of scam on this site. I may have to cut the cord.

Pete, you forced me to look up your full name in one of Colin's YouTube posts. I don't like using a person's code without crediting him or her in my database. Fortunately, I watched one of your recent presentations to Access Europe that Colin posted. Thanks again.

Thanks, Pete. I think this is exactly what I was looking for. I will add a few Is Sensitive fields, back up my application, and do a test. I would never have been able to create this code myself. This will help my family members share their version of the database with other family...

That's true Duane. Here's the text that I tried to post and it was blocked. I saved it to Word. I was responding to Pat. I made a few edits today. Thanks a million, Pat. I will use your comments to improve my applications. But some of what you are directing me to do is over my head...

BlueSpruce, I suspect AW counts the number of posts that a person submits to AW and if that number is not above a certain threshold, then the system blocks new posts to a thread. I can start new threads, and I can respond to other threads. I just can't go over 100 posts until I become a member...

Thanks, Pete. All I want to do with MVFs is show lists of attributes. I agree that a more analytical application may need other tools. This is why my Finance and Health database already has 450 tables and forms. The forms look like the above screenshot. The forms are related to other forms...

That's not how I use MVFs. All of mine use a visible, not a hidden, table. I call them lookup tables because the MVFs use them. Other tables, forms, and reports can also use them. Again, the big advantage, IMHO, is how the attributes look in forms and reports. I usually set the formatting...

BlueSpruce, I don't do anything special with MVFs. I store information in lookup tables that are managed using their forms. Like with everything else in my databases, the goal is to create reports and to make verbal suggestions to users (TTS). MVFs do the first well because they display...

Duane, I am not sure what that means. Gasman, I wouldn't accept an Oops from my phone company. Take it back.

Sorry, Gasman. I read the post, but I don't remember the user's name. His post told me that the problem could be a common one. I did reply to the person. For my two conversations, I spent several minutes drafting a reply to someone, and when AW blocked me. It posted a message, but what...

Thanks, Doc_Man. We were 40 posts into a very informative conversation when I got locked out. Others were able to continue posting, but I was the one who started the conversation. I couldn't tell anyone that I was still alive and kicking. I could have passed on and people could have...

I have created two conversations on AW since I joined this community. The site has locked me out of both because it blocks anyone after he/she has posted a few times to the same thread. Another user discovered the same problem. I appreciate your comments and information very much. I am...

And Pat, what is the basic principle about not having lots of forms in a database? I am curious to know why I shouldn't have 4 or 5 thousand forms and reports. They are used to store and display data differently. My database has about 4000 tables. The forms do different kinds of...

Pat, my database will handle new grocery stores just fine. I store the names in a lookup table and forms use dropdown fields to assign them to each transaction. Having the names in lookup tables, I can use them in simple fields or I can use them in MVFs. They are always up to date. The...

Thanks Pat, you taught me something that I didn't know about compact. I rarely run compact and compare because I don't do operations that change the data very often. This could be a benefit of making my forms so verbose. I need to look for the autonumbers to change in hundreds of tables...

Yes and thanks AccessBlaster. I have only developed about four Access databases in my entire life. Unlike most other Access users, I don't code and I structure tables (normalize) in my head. I know very little about financial and medical sciences. I didn't go to college and study either of...

Thanks arnelgp. That could come in handy with a different group of users. I am sure none of my family will ever use two databases. Thanks for sharing.

Pete, just because there are several forms and reports for grocery purchases, that does not mean that there are multiple tables for grocery stores. This is a situation where I created a form for the Walmart to the west of my house, the King Soopers to the north, and the Safeway to the south...