Show a Table?

--
After searching Google.groups.com and finding no answer, Bob Vance asked:

I have a made a command button to print a table how do I go about getting a
button to SHOW a table?

Thanks in advance.........Bob Vance

One typically does not "show" a table to a user of the database (tables
should be "reached" only by the developer and by forms and by queries).
Instead, one "shows" a query's results (in a form) that uses the table as
its data source.
--

Ken Snell
MS ACCESS MVP


"Bob" wrote in message ...


--
After searching Google.groups.com and finding no answer, Bob Vance asked:

I have a made a command button to print a table how do I go about getting
a button to SHOW a table?

Thanks in advance.........Bob Vance

Seems strange I can shortcut to print it but cant shortcut to see it.....TIA
Bob

"Ken Snell [MVP]" wrote in message
...
One typically does not "show" a table to a user of the database (tables
should be "reached" only by the developer and by forms and by queries).
Instead, one "shows" a query's results (in a form) that uses the table as
its data source.
--

Ken Snell
MS ACCESS MVP


"Bob" wrote in message ...


--
After searching Google.groups.com and finding no answer, Bob Vance asked:

I have a made a command button to print a table how do I go about getting
a button to SHOW a table?

Thanks in advance.........Bob Vance

On Thu, 30 Dec 2004 11:40:02 +1300, "Bob" wrote:

And I can put a shortcut to the table on my desktop but cant put one on my
main access screen TIA Bob

You are apparently misunderstanding the whole purpose of Tables.

Tables are repositories for storing data. That's ALL that they are.

They're not designed for presentation or editing of data; one should
use a Form to do that.

They're not designed for printing; one should use a Report for that
purpose.

They're not documents, like a Word document or a spreadsheet. An
Access screen typically does not have shortcuts on it; the Database
window has a Tables tab which lists the tables, if you need to open a
table for development purposes. But for routine interaction with the
data there is usually no good reason to open a Table datasheet AT ALL.

John W. Vinson[MVP]

I have a Charge ID, Description, Amount, eg:
ARC---Auckland Racing Club---$20
WRC----Wellington Racing Club---$50
VCBWD----Vet Care Bot & Worm Drench
Just would be easy if I could check my Charge ID if I wasnt sure what it
was..........TIA Bob

"John Vinson" wrote in message
...
On Thu, 30 Dec 2004 11:40:02 +1300, "Bob" wrote:

And I can put a shortcut to the table on my desktop but cant put one on my
main access screen TIA Bob

You are apparently misunderstanding the whole purpose of Tables.

Tables are repositories for storing data. That's ALL that they are.

They're not designed for presentation or editing of data; one should
use a Form to do that.

They're not designed for printing; one should use a Report for that
purpose.

They're not documents, like a Word document or a spreadsheet. An
Access screen typically does not have shortcuts on it; the Database
window has a Tables tab which lists the tables, if you need to open a
table for development purposes. But for routine interaction with the
data there is usually no good reason to open a Table datasheet AT ALL.

John W. Vinson[MVP]

Set the button to open a subform called seetable.

Design that subform to include the data fields you want to see.

Then set that subform to datasheet view mode.

That's about as close as you'll get to what you want to do.

Though I'm betting there are other ways to do lookups and display what
you want from that button.

A lookup based on the primary key perhaps?

You can always use a dropdown combo field to display data in a
spreadsheet style also.

Sorry cant find Sub Form?..TIA Bob

wrote in message
...
Set the button to open a subform called seetable.

Design that subform to include the data fields you want to see.

Then set that subform to datasheet view mode.

That's about as close as you'll get to what you want to do.

Though I'm betting there are other ways to do lookups and display what
you want from that button.

A lookup based on the primary key perhaps?

You can always use a dropdown combo field to display data in a
spreadsheet style also.

On Thu, 30 Dec 2004 12:59:04 +1300, "Bob" wrote:

I have a Charge ID, Description, Amount, eg:
ARC---Auckland Racing Club---$20
WRC----Wellington Racing Club---$50
VCBWD----Vet Care Bot & Worm Drench
Just would be easy if I could check my Charge ID if I wasnt sure what it
was..........TIA Bob

Create a Combo Box on your form, based on this table; use the Wizard,
and accept its offer to hide the ID. That way the computer will see
the Charge ID, you'll see the Description, and you'll both be happier!

John W. Vinson[MVP]

Ive created a form of my table and it looks like how I would like to see it
but cant open it like i have it in forms..Sorry couldnt find how to get
Combo Box from the wizard...Thanks Bob

"John Vinson" wrote in message
...
On Thu, 30 Dec 2004 12:59:04 +1300, "Bob" wrote:

I have a Charge ID, Description, Amount, eg:
ARC---Auckland Racing Club---$20
WRC----Wellington Racing Club---$50
VCBWD----Vet Care Bot & Worm Drench
Just would be easy if I could check my Charge ID if I wasnt sure what it
was..........TIA Bob

Create a Combo Box on your form, based on this table; use the Wizard,
and accept its offer to hide the ID. That way the computer will see
the Charge ID, you'll see the Description, and you'll both be happier!

John W. Vinson[MVP]

On Thu, 30 Dec 2004 14:49:56 +1300, "Bob" wrote:

Ive created a form of my table and it looks like how I would like to see it
but cant open it like i have it in forms..Sorry couldnt find how to get
Combo Box from the wizard...Thanks Bob

I do not understand. "can't open it like I have it in forms" means
nothing to me.

John W. Vinson[MVP]