Search results

Pete, when I say that the database will have twice as many tables/forms/reports next year, it means that I am constantly finding new information to add to the database. When I started back in January the only domains that I considered were financial ones. I read lots about financial systems...

Plog, this is like building an entire city for people who have lived in the desert all of their lives. The first thing that I usually do is paste two pictures into a form, and then I add text for the form to read aloud. A family member tells me what the form will say.

Thanks Doc_Man, the forms will allow my family members to enter the data that they will need to save money and protect their health. I am sure of that because I have stored information from some of the best minds in the world and several government agencies in the database already. I am...

Hi June7.

Thanks Doc_Man. I admit that my applications have Thanks, Doc_Man. I admit that my databases cannot hold a candle to the ones that professional developers create, which is why I ask questions here and did so on UA until one day it was gone. When I was obtaining my first PhD, I knew...

Also Pat, I read a lot and so I get a constant stream of ideas from books and magazines such as Mosby's Manual of Diagnostic and Laboratory Tests, Dave Ramsey's Complete Guide to Money, Harvard Business Review, MIT Sloan, and Kiplinger Personal Finance. I also get information about food recalls...

Thanks Pat, your model is similar to mine. My database is designed to store both financial and health data. I suspect some family members will not want anyone else to see their data. But they may want an adult child or spouse to see certain information, so they will need the ability to delete...

Pete, in my world, this is a very small database. Wait until I get to year two. 450 tables is nothing for me to have in an Accdb file. This is just the start of an application that could have thousands of tables when it is done. Normalization to DKNF is something that I won't worry about...

Gasman, I am in the process of adding "Is Sensitive" fields to some of the tables. Users will check boxes to set those values to True. I want a tool that will run through all of the tables and delete all records where "Is Sensitive" is true. Doing this in 50 forms won't be hard for me, but...

I have been working on a database since January. I am about ready to send it to members of my family, but first I want to remove confidential data that I used to test the application. Of the 450 tables, perhaps only 50 of them have any sensitive information that I would remove. The...

Gasman, I create backups based on the amount of work that I do in between backups. Usually, after I create 20 or so new forms/reports, I back up the database. I figure that I can recreate that many objects if my PC goes belly up. Now that my memory has gotten bad, perhaps I should do backups...

Thanks, Pete. I understand some of what you are doing. But I need to study my Access books to better understand DLookups. I have been using .Visible statements for almost a decade. I used them first in my Sunset Crater graphic. I created it circa 2010 to show the competitive advantages...

Duane, are you sure? I remember attending the launch soon after I retired.

Gasman, my PC is locked down tighter than Fort Knox. I can't open zip files or PDFs. I would love to look under the hood of Pete's application. At least this one is connected to the internet. The one in the basement has never seen the internet. It's a lonely device for sure.

Thanks Duane, I forgot to reply to your post. I haven't touched PBI in more than a decade, maybe two. I am building my finance and health application for use by non-techies, most of whom do not use Excel or PowerPoint. The food recall map is one of about 500 forms currently in the database.

Pete, your solution is outstanding. I need to find someone whose PC isn't locked down the way that mine is, so I can look under the hood. My PC won't let me open a zip file. In the meantime, tell me how the line forms. Does it start with the first capitol and then display the others in a...

Yes, arnelgp. I purchase USB drives by the case. I have some that I bought decades ago. I usually back up database files every week. Thanks for reminding me that it is Friday.

Thanks arnelgp. I will try using that today. Can I get rid of the With and formatting? I have 50 states on the map. I may want to move all of the labels and checkboxes off the map if there are no recalls in a state. And with so many recalls being announced, I suspect the government will...

Thanks, Jack. I learned something new from your post #18. I read recently that the entire .Move statement is not necessary, but I haven't tried it yet. I use two objects so they can be controlled separately. I have one button on the form that hides the labels and another one that hides the...

Sorry about that Mark. My tables often have lots of fields, but some have more than 200 fields. If I fully normalized my databases, I would hit the limit of objects allowed by MS. I have one application now that has more than 4,000 forms, 4,000 reports, and almost that number of tables...