Search results

Thanks Mark. The older you get the more stressful any surgery is. Even out-patient surgery is debilitating. But, the pain was never terrible. I just needed a lot of naps these past few days. My brother, who has a ton of vacation time accrued, came to spend a week with me in case I had...

Which is exactly why Israel tries very hard to not injure innocent civilians. It is the truly evil members of Hamas who have made the residents of Gaza prisoners so complain about Hamas and stop blaming Israel. Israel can't solve this problem except by destroying Hamas. The Palestinians can...

I don't use the method you used to link to the workbook. I'm pretty sure that is why you are having this problem. I usually have a dialog that allows the user to pick a specific file and then use TransferSpreadsheet to link to it. If you move the file later, the link will no longer work. If...

It isn't the number of items in a table that causes work, it is the number of tables, especially tables that do the same exact thing. It makes absolutely no difference to the logic of an application if you have a table with two items or two million. The number of rows in a table has ZERO...

What you NEED is to normalize your schema so you don't have THOUSANDS of forms that do the same thing. And the best way to handle a TOC is just that. The high level is finance, human medicine, pet medicine, etc. Whatever sections you have. And then each of those drills down. The entire TOC...

Then you actually know very little about COVID. But we've covered that in other threads so we won't go into it here. You have crippled yourself because you allowed the lame-stream media to terrify you. Remember the mantra for the media - "if it bleeds, it leads". They live and die by this...

That is also a huge mistake. Macros are significantly harder to create and logically confusing compared to code. Code (at least VBA) mimics English and the logic you use when thinking about how to do a task. You just don't know that because you have handicapped yourself to use only macros...

And do you expect them to import new objects and manually modify table descriptions when new fields are necessary? ALL useful applications are living/breathing things and will require maintenance even once fully functional. By insisting on keeping all functionality in a single database, you...

A larger monitor is not the solution. It is not necessary to see every option for every group on a single screen as you showed with the picture on #16. It is that picture that makes your app look worse than it is. It is like you are trying to put an entire table of contents on a single form...

Some research should take priority. I'm not saying that you should immediately go back and remove all your unnecessary lookup tables. You can leave them alone until such time as you have to do maintenance on a form that uses one of them. Then convert only that single table. But start...

What planet do you live on? I can't think of a single food recall that has ever affected me personally and I've been cooking for the family for 60+ years.

If you decide to add "help" that is accessible by ? buttons, Create the help in a table so if you need to describe blood pleasure in more than one place, you only need ONE help entry for it. You can create text abbreviations or you can use numbers that are hardcoded. Something must connect...

Not if you instead learn how to normalize your data so that each disease doesn't require its own table. Do you think a hospital application includes a table for each separate disease? Let me help you out - it doesn't!!!!!!!!!! Also during the time it will take you to research and hard...

And how many lookup tables do you have? And did you bother to look at the mini-app I provided a link to so that the maintenance of lookup tables can be managed simply without hundreds of tables and forms and queries to manage those tables.

It goes well beyond this. Adding new columns to an existing table is fairly common after the app has been distributed. Say you have 5 users, each with their own personal data. The data and the application objects are all in a single .accdb. Exactly what is your plan? Are the users going to...

This is what documentation and validation are all about. You can add little question marks next to fields that explain the rules and use when the user clicks on them EVERY form that does data entry needs validation at a minimum to ensure all required fields have been entered. You can do some...

My dissonance came about as I studied history and learned of the many evil things done in the name of God by the church hierarchy. It didn't result in a non belief in God but it sure resulted in a distaste for authority and disgust with the Papacy. I can't even go to mass they've gotten so...

Those people reside in Congress. It's Congress (State and Federal) that allows usurious interest rates and allows punitive bank fees. All the CC companies are headquartered in the two states that allow the usurious interest rates and even though YOUR state doesn't allow them, the CC HQ state...

I'd blame the rise in banking fees on tariffs;) Or maybe its because the Fed is thinking about lowering their payment to banks to NOT make actual loans. Not sure who thinks paying banks to NOT make loans is a good idea. That is how banks always made money in the past. Now, they make their...

Any reason why you did not try the code yourself?