Solved

Extract form design from MSys... tables?

Posted on 2006-11-29
4
415 Views
Last Modified: 2013-12-03
Is there any code that will take a form and create a table representing the form design? I'm looking for a result like EITHER:

controlname controltype top left height width and all other relevant properties
textbox1       textbox       10  10  200    2000

OR

controlname propertyname propertyvalue
textbox1       controltype     textbox      
textbox1       top                10
textbox1       left                10
textbox1       height            200
textbox1       width             2000
0
Comment
Question by:ramrom
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 17

Author Comment

by:ramrom
ID: 18041035
I've started to write my own. Turns out that I want container relationships (e.g. tabcontrol is parent of page(s) are parents of control on corresponding tab page.) So a little more complex but doable.  Still open to someone's code.

New table format:
seq property value
    1 Form     Form1
    2 Control  TextBox1
    3 Type     109
    4 Top      10
    5  etc...
    6 Tab1    123
0
 
LVL 50

Accepted Solution

by:
Gustav Brock earned 250 total points
ID: 18046444
It's not that easy. As a start, read out what you will have to extract otherwise by saving the form as a text file:

SaveAsText acForm, Forms(0).Name, "c:\" & Forms(0).Name & ".txt"

It can be loaded into the database with the reverse command: LoadFromText ...

Study the textfile. It contains all info including a bitmap of any pictures (background).

/gustav
0
 
LVL 17

Author Comment

by:ramrom
ID: 18048017
SaveAsText. That does it! Where is this documented? I can't find it in Access Help!

http://www.thescripts.com/forum/thread190534.html says a bit more. Hidden members, eh? Why hidden?

0
 
LVL 50

Expert Comment

by:Gustav Brock
ID: 18052477
They are undocumented by MS but have been around since Access 97 so they are widely known among developers.
The purpose for these is probably to enable Access to save and load source code and objects in Visual Source Safe.

/gustav
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

695 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question