How to fix expand button between column 2 and 3, not at leftmost c

N

Novis

Would you please teach me a method to fix expand button, +, between-
RegisteredDomainNames column and Owners column in below Table B- and not at
leftmost column in the Table B if you would be so kind to me?

Software's Name: Microsoft Office Access 2003 (Access) .
Operating System's Name: Microsoft Windows XP Professional Version 2002
Service Pack 2 (WinXP).

The Access and WinXP contains below Table A and the Table B.

The Table A's quasi, partial appearance in Datasheet view:
-------------------------------------------------------------
Organizations : Table
-------------------------------------------------------------
| | ID# | Names | Types | Website
-------------------------------------------------------------
|+| 10 | Sample Corporation| Corporation | 20
--------------------------------------------------- ----------

The Table B's quasi, partial appearance in Datasheet view:
-------------------------------------------------------------
Websites : Table
-------------------------------------------------------------
| | ID# | RegisteredDomainNames | Owners
-------------------------------------------------------------
|+ | 20 | Sample.com | 10
-------------------------------------------------------------

The Table B's Desirable quasi, partial appearance in Datasheet view:
-------------------------------------------------------------
Websites : Table
-------------------------------------------------------------
| | ID# | RegisteredDomainNames | Owners
-------------------------------------------------------------
| | 20 | Sample.com |+|10
-------------------------------------------------------------

Reason of asking of the teaching:
1. I would like the button to exist between the RegisteredDomainNames and
Owners columns, not at the leftmost column.
2. I searched whole, this Access Database Office Disccussion Group, but
haven't found the method.
3. I googled the method, but haven't found the method.
4. I searched whole followings, but haven't found the method.
The followings:
1. Offline Help in the Access.
2. Access 2003 Help and How-to - Access- website.
Universal Resource Locator (URL) of the website:
http://office.microsoft.com/en-us/access/FX100646921033.aspx?CTT=96&Origin=CL100570041033

Thank you for your time and help for me!
 
J

John W. Vinson

Would you please teach me a method to fix expand button, +, between-
RegisteredDomainNames column and Owners column in below Table B- and not at
leftmost column in the Table B if you would be so kind to me?

You cannot.

Table datasheets have VERY limited flexibility. Subdatasheets (the feature
with the "+" button you're describing) are a rather new feature, and they work
the way you see; they are not programmable and don't allow the + to be moved.

I would strongly recommend NOT using table datasheets, with or without
subdatasheets, for interaction with your data, period. They won't let you do
what you're asking to do, and have many other problems.

Instead create a Form with a Subform; or, if you really really like the
datasheet view, create a Query joining the two tables and use a Datasheet view
form to display it.

John W. Vinson [MVP]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top