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
|
|||
|
|||
How Can I Eliminate the "+" Sign When Displaying Table Data
I created two tables and used the "Relationships" view to create the
relationships. Now, when I just display the table data (double click the table name) on the One Table (One to Many), it has a plus sign in the left column that brings in the "Many" table data if I click the + sign.. I could not find a way to turn off that feature. Is there? -- Rich Locus Logicwurks, LLC |
#2
|
|||
|
|||
How Can I Eliminate the "+" Sign When Displaying Table Data
On Sun, 31 Jan 2010 17:02:01 -0800, Rich Locus
wrote: Yes there is, and it is a good idea to turn it off. Design the table, get properties, and set SubDatasheetName to "[none]". If you search for these keywords you'll probably find code that will loop over all tables and turn it off for all. -Tom. Microsoft Access MVP I created two tables and used the "Relationships" view to create the relationships. Now, when I just display the table data (double click the table name) on the One Table (One to Many), it has a plus sign in the left column that brings in the "Many" table data if I click the + sign.. I could not find a way to turn off that feature. Is there? |
#3
|
|||
|
|||
How Can I Eliminate the "+" Sign When Displaying Table Data
On Sun, 31 Jan 2010 18:14:27 -0700, Tom van Stiphout
wrote: On Sun, 31 Jan 2010 17:02:01 -0800, Rich Locus wrote: Yes there is, and it is a good idea to turn it off. Design the table, get properties, and set SubDatasheetName to "[none]". If you search for these keywords you'll probably find code that will loop over all tables and turn it off for all. Here's some (that I got from this group at some point I've forgotten, apologies to the author): Public Function TurnOffSubDataSh() As Integer Dim db As DAO.Database Dim tdf As DAO.TableDef Dim prp As DAO.Property Const conPropName = "SubdatasheetName" Const conPropValue = "[None]" TurnOffSubDataSh = 0 Set db = DBEngine(0)(0) For Each tdf In db.TableDefs If (tdf.Attributes And dbSystemObject) = 0 Then If tdf.Connect = vbNullString And Asc(tdf.Name) 126 Then 'Not attached, or temp. If Not HasProperty(tdf, conPropName) Then Set prp = tdf.CreateProperty(conPropName, dbText, _ conPropValue) tdf.Properties.Append prp TurnOffSubDataSh = TurnOffSubDataSh + 1 Else If tdf.Properties(conPropName) conPropValue Then tdf.Properties(conPropName) = conPropValue TurnOffSubDataSh = TurnOffSubDataSh + 1 End If End If End If End If Next Set prp = Nothing Set tdf = Nothing Set db = Nothing End Function -- John W. Vinson [MVP] |
#4
|
|||
|
|||
How Can I Eliminate the "+" Sign When Displaying Table Data
"Tom van Stiphout" wrote in message
... On Sun, 31 Jan 2010 17:02:01 -0800, Rich Locus wrote: Yes there is, and it is a good idea to turn it off. Design the table, get properties, and set SubDatasheetName to "[none]". If you search for these keywords you'll probably find code that will loop over all tables and turn it off for all. You also need to turn off name auto-correct, else the dreaded [Auto] will return Keith. www.keithwilby.co.uk |
#5
|
|||
|
|||
How Can I Eliminate the "+" Sign When Displaying Table Data
"John W. Vinson" wrote in message
... Here's some (that I got from this group at some point I've forgotten, apologies to the author): I think it was Allen Browne. |
#6
|
|||
|
|||
How Can I Eliminate the "+" Sign When Displaying Table Data
Rich
Other's have pointed to how you can turn off that 'feature'. Please also be aware that Access tables are intended to store data, not display it. You and your users don't need to (and probably shouldn't) work directly in the tables. Use Access Forms instead. Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "Rich Locus" wrote in message ... I created two tables and used the "Relationships" view to create the relationships. Now, when I just display the table data (double click the table name) on the One Table (One to Many), it has a plus sign in the left column that brings in the "Many" table data if I click the + sign.. I could not find a way to turn off that feature. Is there? -- Rich Locus Logicwurks, LLC |
Thread Tools | |
Display Modes | |
|
|