How Can I Eliminate the "+" Sign When Displaying Table Data

  • Thread starter Thread starter Rich Locus
  • Start date Start date
R

Rich Locus

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?
 
On Sun, 31 Jan 2010 17:02:01 -0800, Rich Locus

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
 
On Sun, 31 Jan 2010 17:02:01 -0800, Rich Locus

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.
Click to expand...

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
 
Tom van Stiphout said:
On Sun, 31 Jan 2010 17:02:01 -0800, Rich Locus

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.
Click to expand...

You also need to turn off name auto-correct, else the dreaded [Auto] will
return :)

Keith.
www.keithwilby.co.uk
 
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.
 
Back
Top