Solved

Extract form design from MSys... tables?

Posted on 2006-11-29
4
409 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

910 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

23 Experts available now in Live!

Get 1:1 Help Now