Solved

Extract form design from MSys... tables?

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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
MS ACCESS VBA FORMATTING 9 58
Access Query function 4 46
Access 2010 Changing String to Date with Leading Zero 11 25
Tabbed form question 5 15
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
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, when working with VBA, learn some techniques for writing readable and easily maintained code.

738 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