Show a Table?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bob - 29 Dec 2004 21:44 GMT

Signature

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

Reply to this Message

Ken Snell [MVP] - 29 Dec 2004 22:03 GMT

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.

Signature

Ken Snell
<MS ACCESS MVP>

Reply to this Message

Bob - 29 Dec 2004 22:06 GMT

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

> 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.

Reply to this Message

Bob - 29 Dec 2004 22:40 GMT

And I can put a shortcut to the table on my desktop but cant put one on my

> Seems strange I can shortcut to print it but cant shortcut to see
> it.....TIA Bob
[quoted text clipped - 3 lines]
>> Instead, one "shows" a query's results (in a form) that uses the table as
>> its data source.

Reply to this Message

John Vinson - 29 Dec 2004 23:22 GMT

>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]

Reply to this Message

Bob - 29 Dec 2004 23:59 GMT

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

>>And I can put a shortcut to the table on my desktop but cant put one on my
>>main access screen TIA Bob
[quoted text clipped - 16 lines]
>
> John W. Vinson[MVP]

Reply to this Message

John Vinson - 30 Dec 2004 01:11 GMT

>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]

Reply to this Message

Bob - 30 Dec 2004 01:49 GMT

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 have a Charge ID, Description, Amount, eg:
>>ARC---Auckland Racing Club---$20
[quoted text clipped - 8 lines]
>
> John W. Vinson[MVP]

Reply to this Message

John Vinson - 30 Dec 2004 02:27 GMT

>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]

Reply to this Message

Bob - 30 Dec 2004 04:50 GMT

Im sorry I don't know enough about access but It dose not show them in lines
of order underneath each other like in a table..Hope that helps..bob

>>Ive created a form of my table and it looks like how I would like to see
>>it
[quoted text clipped - 5 lines]
>
> John W. Vinson[MVP]

Reply to this Message

John Vinson - 30 Dec 2004 19:49 GMT

>Im sorry I don't know enough about access but It dose not show them in lines
>of order underneath each other like in a table..Hope that helps..bob

A Form allows three different views:

- Datasheet, which looks like a table datasheet or an Excel
spreadsheet
- Single, which shows one record at a time; you can use the navigation
buttons at the bottom left to move from one record to another
- Continuous, which gives you the best of both - you can use
textboxes, combo boxes, other controls arrange however you like, and
it will show multiple records one above the other

Open the Form in design view; view its properties; and select
whichever you prefer in the Default View property.

John W. Vinson[MVP]

Reply to this Message

iam@notarealisp.com - 30 Dec 2004 00:30 GMT

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.

Reply to this Message

Bob - 30 Dec 2004 01:03 GMT

Sorry cant find Sub Form?..TIA Bob

> Set the button to open a subform called seetable.
>
[quoted text clipped - 11 lines]
> You can always use a dropdown combo field to display data in a
> spreadsheet style also.

Reply to this Message