Show a Table?

[Bob]

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

 

[Ken Snell [MVP]]

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.

 

[Bob]

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

 

[Bob]

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

 

[John Vinson]

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]

 

[Bob]

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

 

[iam]

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.

 

[Bob]

Sorry cant find Sub Form?..TIA Bob

 

[John Vinson]

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]

 

[Bob]

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]

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]

 

[Bob]

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

 

[John Vinson]

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]