Senin, 13 Februari 2017

Re: [MS_AccessPros] Problem when changing Tab Order - controls disappear

 

Sig-


The code strips out all the Autocorrupt data, the PrtDevMap that can also get easily corrupted, and the hidden controls that get added in Access 2010 and later to support layouts that aren't supported by 2007.  I originally built the app to do Autocorrupt cleanup, and then I added the 2010 stuff when people were discovering that opening a 2007 .accdb and editing one form or report made the database no longer able to open in 2007.

John Viescas, Author
Effective SQL
SQL Queries for Mere Mortals 
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications 
(Paris, France)




On Feb 13, 2017, at 3:26 PM, Sigurd Andersen sigurd@solbakkn.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:



Pointing me to "Name Auto Corrupt" was a big help.

Your "little utility" is rather elegant - though I'm still not clear precisely what happens on imports & exports, when the "rename" box is checked or not. 

At least you got a chuckle out of our exchange.

Sig


On 2/12/2017 6:05 AM, John Viescas JohnV@msn.com [MS_Access_Professionals] wrote:

That's hilarious!  Well, at least you learned about not using Name AutoCorrupt.  😃  And maybe my little utility helped you clean up any pending disasters...


John Viescas, Author
Effective SQL
SQL Queries for Mere Mortals 
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications 
(Paris, France)




On Feb 11, 2017, at 11:38 PM, Sigurd Andersen sigurd@solbakkn.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:



John,

Well, I think I figured out the issue. For better looks, I have a gray rectangle on the tab in question as background. Evidently when I click on OK for the tab order, this rectangle moves in front of the controls that thereby "disappear behind the curtain." 

Thanks for your help this time (and in the distant past, when I was more active in DB development).

Sigurd


On 2/10/2017 1:21 PM, John Viescas JohnV@msn.com [MS_Access_Professionals] wrote:

Sigurd-


If my code didn't fix your forms, I don't know what else to tell you other than to try rebuilding the problem form and its subforms from scratch.

John Viescas, Author
Effective SQL
SQL Queries for Mere Mortals 
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications 
(Paris, France)




On Feb 10, 2017, at 6:45 PM, Sigurd Andersen sigurd@solbakkn.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:



John,

Got your routine, brought it into a copy of the DB, ran it for all forms in the DB, then imported all the forms. Had "Rename" checked on both export and import.

So I don't mess things up - I'm not sure what to do now with the forms with original names, and those with one or two preceding "zzOLD_" in their names. 

I tried using the DB without renaming or deleting anything (and thereby using the set of forms without "zzOLD") - they function fine, but I have the same problem with Tab Order.

Do I need perhaps to fix all subforms in one pass, then all forms in another pass? (I've named the former starting "fsb" and the latter starting "frm")?

Or perhaps you have some other suggestion?

Thanks again,
Sigurd

On 2/10/2017 11:52 AM, John Viescas JohnV@msn.com [MS_Access_Professionals] wrote:

Sigurd-


You can leave Track on - it supports some features in the Nav pane.

Yes, you use the Debug window, but I have a better idea.  Go to the Files \ 0_Utilities and Add-Ins section on our forum.  Download my FixBroken.zip.   Pull the form from the .accdb file into your database and open it, then tell it to export all forms.  When it does that, it creates a "clean" version of all your forms with the garbage introduced by Name AutoCorrupt stripped out.  Rename your problem forms, delete the .txt files for all your forms except your "broken" ones, and then use my form to re-import the forms.  See if that fixes it.

Of course, you're free to do this with all of your forms if you want and if you like what my utility does.  You could even go so far as to use my utility to export everything, create a new clean database with AutoCorrupt turned off, then use my utility again to import all the "fixed" stuff into a new database.  That may be the best way to go.


John Viescas, Author
Effective SQL
SQL Queries for Mere Mortals 
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications 
(Paris, France)




On Feb 10, 2017, at 5:18 PM, Sigurd Andersen sigurd@solbakkn.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:



John,

I only do DB work occasionally, but have decades of experience. I knew that something like "Name Autocorrect" existed, but couldn't recall the details & hadn't researched it - so - it was turned on. (turned it off AND turned off "tracking" of Autocorrect info - or should I leave the latter on for any reason?).

As to the Application.SaveAsText & Application.LoadFromText - not sure best way to use them. 

I found a StackOverflow link:
http://stackoverflow.com/questions/2088814/export-objects-in-msaccess-application-to-text-objects-and-import-into-a-new-md

that suggests

At the debug/immediate window type:

    Application.SaveAsText acForm,"MyForm","c:\form.txt"

You can load the file into a new MDB.

    Application.LoadFromText acForm,"MyForm","c:\from.txt"

It also has a pointer to code from 1999 to automate doing this for all database objects - I suppose I could use the section for Forms (if it's still valid for Access 2010)

http://www.datastrat.com/Code/DocDatabase.txt 

I'm guessing going the debug/immediate route, I'd need to do this for each subform and for the main form with the tabbed area.

I'd appreciate suggestions on how to proceed.

thanks much,
Sigurd


On 2/10/2017 5:30 AM, John Viescas JohnV@msn.com [MS_Access_Professionals] wrote:

Sigurd-


That tells me your form might be corrupted.  You could try using Application.SaveAsText followed by Application.LoadFromText.

By the way, do you have Name Autocorrect turned on?  That's often a source of corruption.  (Also fondly known as "Name AutoCorrupt".)

John Viescas, Author
Effective SQL
SQL Queries for Mere Mortals 
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications 
(Paris, France)




On Feb 10, 2017, at 2:00 AM, Sigurd Andersen sigurd@solbakkn.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:



John,

All the names that show up on the Tab Order list are controls on the tab in question, and all the controls on the tab are in the list.

I opened the DB on the remote server the company I'm working with uses, brought up the Tab Order list for the tab in question, clicked OK, and the same disappearing act happened.

Sigurd


On 2/9/2017 2:17 PM, John Viescas JohnV@msn.com [MS_Access_Professionals] wrote:

Sigurd-


It sounds like those controls aren't actually on the tab you're trying to modify.  When you pull up the Tab Order dialog, do you see any controls that you think are not on that tab?  That would be a clue that the controls aren't actually on the tab.

John Viescas, Author
Effective SQL
SQL Queries for Mere Mortals 
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications 
(Paris, France)




On Feb 9, 2017, at 7:13 PM, Sigurd Andersen sigurd@solbakkn.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:



John,

The controls seem to be moving somewhere - after clicking OK on the Tab Order list (whether or not I make any changes to it), the controls for single data items (but not labels or subform) no longer show, but I do see the little upper-left-corner box indicating that they're still somewhere. I tried changing the Back Style of the Tab Control to Transparent, but the controls disappeared the same way as before.

If the controls were in the Detail but appearing on top of the tab, wouldn't they show up on EVERY tab? This Tab Control has 10 tabs, no extraneous controls appearing on any of them.

This DB ends up residing on a remote server - I'll try changing the Tab Order using the remote copy of Access and see if it behaves the same or not.

Thanks
Sigurd


On 2/9/2017 4:31 AM, John Viescas JohnV@msn.com [MS_Access_Professionals] wrote:

Sigurd-


I'm running 14.0.7166.5000, and I don't see that problem on a tab control.  Perhaps the controls are getting moved to the Detail section behind the tab control?  After attempting the Tab Order tool and seeing the problem, go to the Properties window and use the drop-down at the top to see if the controls are still there but just moved.  Perhaps the controls aren't really on the tab but are in the Detail section and just appear on top of the tab.  Is the Back Style of the Tab control set to Normal or Transparent?  If Normal, it's possible for controls to hide behind the tab control.

John Viescas, Author
Effective SQL
SQL Queries for Mere Mortals 
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications 
(Paris, France)




On Feb 9, 2017, at 4:37 AM, Sigurd Andersen sigurd@solbakkn.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

I have a rather complex form that has a tabbed form with 10 tabs. I have 
a problem when I go to change the tab order for the controls on a tab. I 
select the tab on which I want to re-order the tab order of the 
controls. I select the tool Tab Order, and the expected list of controls 
shows up. I re-arrange the order of the controls in the list. When I 
click on OK, all the individual controls completely disappear. All 
that's left are labels and a subform. Even if I bring up the Tab Order 
tool, make NO re-arrangements and click OK, the same thing happens - all 
the individual controls disappear. Undo brings them back. But I have not 
yet found a way to adjust the tab order without controls disappearing.

I'm using Office 2010 ("version 14.0.7177.5000"). I've tried lots of 
Google searches, but to no avail. Hoping this community can help.
Thanks in advance

--
Sigurd Andersen
St. Johnsbury, VT 05819



------------------------------------
Posted by: Sigurd Andersen <sigurd@solbakkn.com>
------------------------------------


------------------------------------

Yahoo Groups Links

<*> To visit your group on the web, go to:
   http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
   Individual Email | Traditional

<*> To change settings online go to:
   http://groups.yahoo.com/group/MS_Access_Professionals/join
   (Yahoo! ID required)

<*> To change settings via email:
   MS_Access_Professionals-digest@yahoogroups.com 
   MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
   MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
   https://info.yahoo.com/legal/us/yahoo/utos/terms/



--   --  Sigurd Andersen  572 Libby Road  St. Johnsbury, VT 05819  




--   --  Sigurd Andersen  572 Libby Road  St. Johnsbury, VT 05819  




--   --  Sigurd Andersen  572 Libby Road  St. Johnsbury, VT 05819  




--   --  Sigurd Andersen  572 Libby Road  St. Johnsbury, VT 05819  




--   --  Sigurd Andersen  572 Libby Road  St. Johnsbury, VT 05819  




--   --  Sigurd Andersen  572 Libby Road  St. Johnsbury, VT 05819



__._,_.___
Posted by: John Viescas <johnv@msn.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (15)
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

.

__,_._,___
Diposting oleh di

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)