Solved

Extract form design from MSys... tables?

Posted on 2006-11-29
4
406 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
  • 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 49

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 49

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

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

762 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now