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
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, AuthorEffective SQLSQL Queries for Mere MortalsMicrosoft Access 2010 Inside OutMicrosoft Access 2007 Inside OutMicrosoft Access 2003 Inside OutBuilding 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:
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, AuthorEffective SQLSQL Queries for Mere MortalsMicrosoft Access 2010 Inside OutMicrosoft Access 2007 Inside OutMicrosoft Access 2003 Inside OutBuilding 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:
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, AuthorEffective SQLSQL Queries for Mere MortalsMicrosoft Access 2010 Inside OutMicrosoft Access 2007 Inside OutMicrosoft Access 2003 Inside OutBuilding 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
Posted by: Sigurd Andersen <sigurd@solbakkn.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (7) |
Tidak ada komentar:
Posting Komentar