Clear out data (3 Viewers)

[MajP]

The OP clearly stated he is not a developer so I feel it's inappropriate to humiliate him, or any other AWF who is not an experienced developer.

I am not a doctor, lawyer, or financial expert either. But if I am visiting those sites, and a good chunk of the expert respondents think what I am proposing sounds insane, I am probably going to show some interest in what they have to say. If they say something like "in all my life I have never seen anything like that", I am probably going to listen up and not double down. It is OK to do things a little non-standard. It is different when you are doing something that no one else has ever done or would ever want to do.

 

[BlueSpruce]

...in the real world, you sometimes have to retire old values. You need to have them in the list to support existing records but you don't want existing or new records to be changed to the discontinued value SO, you need an additional column in the table to indicate which items are archived and the mini-app solves that problem. It also has simple security so you can limit the users who are authorized to add/change lookup values...

Some of my lookup tables have logically "Deleted" and "UserAdded" boolean columns. If a value has a Deleted checkmark, the value will still appear on the list, but an X will appear in the 2nd column of the dropdown list and users won't be able to select it. In certain comboboxes I allow users to dynamically add new values on the fly when users enter values not in list. However, a msgbox popup warns users to verify if any values already on the list should be used instead of adding the new value.

 

[LarryE]

The OP clearly stated he is not a developer so I feel it's inappropriate to humiliate him, or any other AWF member who is not an experienced developer.

Thousands of non-developers and beginning ACCESS users have come into this forum and taken the advice given to them. They wished to design their projects properly. This OP clearly stated he knows he is designing his project improperly; he wants to design it wrong, and several people have given advice as to how to do it correctly. He refuses to take the advice given and states he wants thousands of tables and forms and doesn't understand what is wrong with that. No one is humiliating him. He did that to himself. He does not want to use the product in the manner that it was designed to be used and refused help. I do not have any sympathy. And I still don't want him designing anything that matters if he is going to do it backwards.

 

[Gasman]

The OP clearly stated he is not a developer

Not anymore perhaps, but he used to continually boast of his main DB he created (that had even more objects) that dealt with I cannot remember what now, such is my memory, but involved million dollar projects.
This DB he mentions here started off as a finance DB like Quicken, and evolved to encompass medical data.

 

[Gasman]

Some of my lookup tables have logically "Deleted" and "UserAdded" boolean columns. If a value has a Deleted checkmark, the value will still appear on the list, but an X will appear in the 2nd column of the dropdown list and users won't be able to select it. In certain comboboxes I allow users to dynamically add new values on the fly when users enter values not in list. However, a msgbox popup warns users to verify if any values already on the list should be used instead of adding the new value.

View attachment 120701View attachment 120702View attachment 120703

TBH, I would be asking why you are supplying something that whilst can be selected, should not even be shown?

I remember seeing a program where one had to select a town in England, yet the combo showed towns in Scotlan and Wales.
If you selected one of those, then you got a similar message, yet a simple filter for the country would have prevented that.

When I mentioned it, I was told 'Well yes, in a perfect world, that would be nice'
One simple filter, 5 seconds to implement, 20 secs to test.