Forum home » Delegate support and help forum » Microsoft Access Training and help » The + symbol has dissapeared on my table in Access, how do I get

The + symbol has dissapeared on my table in Access, how do I get

ResolvedVersion 2007

Wed 30 May 2012, 10:49 Delegate Katrina said...

Katrina has attended:
Access Introduction course
Access Intermediate course

The + symbol has dissapeared on my table in Access, how do I get

We are working from a database that someone has set up. In the table on the Form, we click on the cross on a table, which brings up a table within that table. But, the plus symbol has dispersed, this happens occasionally, we randomly click about the table and it reappears, except today. Dose anyone know how we can get this plus symbol back (+)?

Wed 30 May 2012, 12:20 Trainer Anthony said...

RE: The + symbol has dissapeared on my table in Access, how do I

Hi Katrina, thanks for your query. The + symbol indicates a subdatasheet, usually as a result of a table relationship having been put in place. If you click on Insert and then Subdatasheet you should be able to restore it.

Hope this helps,

Anthony

Fri 8 Jun 2012, 10:37 Edited on Fri 8 Jun 2012, 14:25 Delegate Katrina said...

RE: The + symbol has dissapeared on my table in Access, how do I

Hi Anthony,

Thanks so much, I tried this and it has worked! Exactly what we needed.

Thanks again

Wed 6 Jun 2012: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Access tip:

Open A Combo Box Automatically

This is helpful if users need to enter large amounts of data. There are two ways to open ComboBoxes when they get the focus by using the tab keys.

When the ComboBox gets focus:

Press Alt + Down Arrow on the keyboard

For it to happen automatically, needs a bit of coding:

1. Add a combo box and a text box control to the form
2. Set the combo box's On Got Focus property to the following event procedure:

Private Sub ComboBoxName _GotFocus()

Me!ComboBoxName.Dropdown

End Sub

3. Open your form in Form View and use the TAB key to make sure it works.

View all Access hints and tips

The + symbol has dissapeared on my table in Access, how do I get

The + symbol has dissapeared on my table in Access, how do I get

RE: The + symbol has dissapeared on my table in Access, how do I

RE: The + symbol has dissapeared on my table in Access, how do I

Access articles

Access tip:

Open A Combo Box Automatically