If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
MS Access metadata repository generation query, matrix generationquery, table-generation query, array-generation query.
Hi:
In 2002 I asked the microsoft.public.access.tablesdbdesign group a question about how to "automatically build tables from field defintions rows in another table". I never received an answer that fit my needs, but the topic has come up again in my work. Other terms that might describe what I'm looking for a metadata repository query, matrix generation query, table- generation query, array-generation query. Consider the following tab-delimited layout of an MS Access Query in Datasheet view. Class_Name Attribute_Name Attribute_Type Attribute_Length Value_Name Dog Gender Char 10 Female Dog Breed Char 30 Beagle House Bathroom Number NA 3 House Bedrooms Number NA 3 Person Last Name Char 20 Smith Person First Name Char 20 Joe Person Birth Year Number NA 1951 How can I use the non-programming features of MS Access 2000, 2003, or 2007 to automatically generate a Datasheet view that would provide form or query data entry functionality that would look like the following Tab-delimited layout for Class=Person (Attributes: First Name, Last Name, Birth Year) First Name Last Name Birth Year Joe Smith 1951 Note that I want to be able to add "values" to the cells of the class/ attribute matrix for data entry purposes. Roy (Yes, I want to build a table-definition metadata tool on top of MS Access's ISAM database engine, as well as on top of a SQL DBMS.) |
#2
|
|||
|
|||
MS Access metadata repository generation query, matrix generation query, table-generation query, array-generation query.
On Sat, 20 Dec 2008 08:32:26 -0800 (PST), Roy Roebuck
wrote: How can I use the non-programming features of MS Access 2000, 2003, or 2007 to automatically generate a Datasheet view that would provide form or query data entry functionality that would look like the following Tab-delimited layout for Class=Person (Attributes: First Name, Last Name, Birth Year) If you insist on doing it without any programming, I don't believe it's possible. You'll need to actually generate a SQL string and I don't think that can be done without programming. Is an answer using the appropriate tool - VBA programming - unacceptable? -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|