Not Obeying Tab Stops

[hlewton]

Maybe that switch is on and I don't know it. In any case I eventually got it to work.

I like your offer but I must say my database has served me well for at least the last 25 years. I am assuming I have to figure out how to use my WinZip program and zip this file. However, I do have concerns about placing it in such a public space. Let me think about this for a moment.

 

[hlewton]

As the others have said - adding a tab control will not stop the form from working.

Once the wizard activates - STOP CHANGING THE SETTING!!!!!!!!!!!!!!!!!!!!!!!!!!!!! You are toggling it off and on and totally confusing yourself. Once it is on, it STAYS on.

OK, let me ask this, is there any indication that the switch is on? How am I to know whether it is on or off?

 

[LarryE]

I have never turned it off. I don't even know where the setting is. I just looked through all the settings I could find and I don't see any option that turns the wizards on and off. There may have been one in old versions but I don't see on in O365. The default when you install Access is probably "on".

What version of Access are you using? Please post a picture of the button you are pressing. Make sure there is enough context so that I can find it in my version of Access.

Form Design>>Controls Dropdown arrow:

ON (Icon highlighted):

OFF (Icon Not Highlighted):

 

[hlewton]

LarryE posted exactly what I would have. I am using whatever is the very latest version of Microsoft 365. Please see the attachment.

 

[hlewton]

OK I just ran a quick test and you guys are correct, once that Use Control Wizard's switch is activated, it stays activated even after closing Access and then reopening it. Also, even after opening an entirely different database. I really was confusing it.

 

[Mike Krailo]

hlewton, I would take Larry up on his offer, you might be pleasantly surprised how much better a properly designed system functions. Especially when it comes to reporting capabilities.

And Pat, thanks for posting your version. I didn't know there was a newer version out. I'm on 2307 still.

 

[hlewton]

hlewton, I would take Larry up on his offer, you might be pleasantly surprised how much better a properly designed system functions. Especially when it comes to reporting capabilities.

And Pat, thanks for posting your version. I didn't know there was a newer version out. I'm on 2307 still.
View attachment 109598

I have been over this type of situation before. As far as I know, everything I use is automatically updated but I do believe I can force an update. I may try that now.

I believe Larry would see that I was such an amateur.

 

[LarryE]

hlewton, I would take Larry up on his offer, you might be pleasantly surprised how much better a properly designed system functions. Especially when it comes to reporting capabilities.

And Pat, thanks for posting your version. I didn't know there was a newer version out. I'm on 2307 still.
View attachment 109598

He has Mike. I have the file. He was using it like a word-processor to just keep different lists of the same information. No Primary or Foreign keys or RI obviously. I'll make it right for him.

 

[LarryE]

I have been over this type of situation before. As far as I know, everything I use is automatically updated but I do believe I can force an update. I may try that now.

I believe Larry would see that I was such an amateur.

By the way Harold, what are "Unsaved Movies"? You have a table called that.

 

[hlewton]

I have been over this type of situation before. As far as I know, everything I use is automatically updated but I do believe I can force an update. I may try that now.

I believe Larry would see that I was such an amateur.

I have no idea why my Microsoft 365 had not automatically updated but I just did it manually. The Use Control Wizards is still in the same place.

 

[hlewton]

By the way Harold, what are "Unsaved Movies"? You have a table called that.

They are Movies I have watched and choose not to save for any future viewing. As you may have seen already and guessed, I created this database when DVDs were not heard of and VHS tapes were the current thing. That is why the second field on all the input forms lists Tape Number as its name. In using tapes I usually got 3 movies per tape depending on the length of the movie. If I remember correctly, when entering DVD is that field I managed use that input to create a query to distinguish between tapes and DVDs.

 

[LarryE]

They are Movies I have watched and choose not to save for any future viewing. As you may have seen already and guessed, I created this database when DVDs were not heard of and VHS tapes were the current thing. That is why the second field on all the input forms lists Tape Number as its name. In using tapes I usually got 3 movies per tape depending on the length of the movie. If I remember correctly, when entering DVD is that field I managed use that input to create a query to distinguish between tapes and DVDs.

OK. Do you have a reason to keep that information?

 

[hlewton]

Yes, so I don't have to watch them again. Between it and those I have saved, I have a very complete list of movies I have watched over the last 25 years or so. That is actually what started this whole thing about me revisiting my database design. I had forgotten how to design that control button that opens all the Unsaved movies. I was about to order a movie from Netflix before they go out of business and I wanted an easy way to check if I had already seen it or not. It serves me the same way that the Open All Search button does because I know that search lists only those movies I have saved in one manner or another. I had the Unsaved Movie Table but had no way to quickly search it, except manually opening it. The Unsaved Movies was an after thought and I never imagined it growing to the size it is at now. So, yes I do use that and the new search of that table.

 

[LarryE]

Yes, so I don't have to watch them again. Between it and those I have saved, I have a very complete list of movies I have watched over the last 25 years or so. That is actually what started this whole thing about me revisiting my database design. I had forgotten how to design that control button that opens all the Unsaved movies. I was about to order a movie from Netflix before they go out of business and I wanted an easy way to check if I had already seen it or not. It serves me the same way that the Open All Search button does because I know that search lists only those movies I have saved in one manner or another. I had the Unsaved Movie Table but had no way to quickly search it, except manually opening it. The Unsaved Movies was an after thought and I never imagined it growing to the size it is at now. So, yes I do use that and the new search of that table.

OK

 

[hlewton]

Once the wizard activates - STOP CHANGING THE SETTING!!!!!!!!!!!!!!!!!!!!!!!!!!!!! You are toggling it off and on and totally confusing yourself. Once it is on, it STAYS on.

I have come to find out that Microsoft did, although very subtlety, show us when the User Control Wizard is active or ON and when it is not active or OFF. If you look at the attachment in post #28, take note it is inactive or off and then compare that to the attachment in post #36, you will see a black box outlining the User Control Wizard switch, indicating that it is active or on. So subtle it is very easy to miss.

 

[hlewton]

Thank you LarryE for everything. I really do appreciate it.

 

[hlewton]

A while back, when trying to make a change in my Access database, which this thread is about, I discovered that if someone outside of me made any change to the program and then emailed me that change I had to:
1. I first had to open the file
2. Close it and reopen it again
3. Then open the Properties of the database as seen in the attachment
4. Then click the box that the Red arrow is point to in order for the database to work as the macros or VBA code was trying to tell it to.

I could not access that Unblock option on the first opening of a modified file which was emailed to me.
Once that block was checked, I could then access the Enable Macros option withing the database program itself to get everything working as it should.

My question, and this is very constant after a program modification, is why do I have to open the modified database twice in order to be presented with that Unblock option? I can see what it says about the file coming from another computer but have no idea why I have to open it twice.

 

[Mike Krailo]

I never open files from my downloads folder. Normally you just move the file to a folder where you have setup Trusted Locations. This way you won't need to have that problem anymore.

 

[hlewton]

I never open files from my downloads folder. Normally you just move the file to a folder where you have setup Trusted Locations. This way you won't need to have that problem anymore.

Thank you for that answer. I usually try it from my documents folder because it never comes to me in the Downloads folder since they are sent by email. The reason I try it first in the Documents folder is in case there is a problem, the file of the same name in my Access folder remains unaffected.

I still wonder why I have to open it twice to get it to work.

 

[Mike Krailo]

But you won't have to if you setup the Trusted Folder area for your applications. It's that simple. I never have to do what you say your doing.