Re: Displaying table contents on a from

"Deepak Reddy" <deepak.p.reddy@xxxxxxxxx> wrote

Can anyone help me with displaying the table
contents on a form,

I don't know exactly what you are asking, Deepak. I'd wager there'll be
someone who can help. "The table" implies some particular table... and, as
this is not a followup discussion, I wouldn't know "what table." If you
simply mean "displaying a table's contents on a form" (not implying a
particular table, but just asking a general question), that's exactly what
forms are intended to do.

Assuming you are using Access 2003 or earlier (the UI was changed for Access
2007 and I don't use that version), for the simplest case, with the table
displayed in Table View (you will be looking at the data in the Table, not
the design of the Table): On the standard toolbar at the top of the screen,
you'll see an icon (on my toolbar it is the last toolbar on the right end)
that you could interpret to be a picture of a form with a bolt of lightning.
If you hover your cursor over that icon, it will show a tooltip that says
"New Object: AutoForm". Click it, and, voilá, a form appears, showing just
one record.

The form created has a navigation bar at the bottom, so you can move between
records.

If you would rather see multiple records: Instead of the above, go to the
Forms tab of the database window, choose the second option from the top
"Create form by using the Wizard". In the dialog that opens, choose the
table you want to display, click Next, then if you want just some of the
fields, click the field in the left column to highlight, click the ">"
button, to move it, until you have selected all you want (if you want them
all, just click the ">>" button). Click "next" and in the next dialog box,
choose "Tabular" and click "next". In the next dialog box, choose a
style/background. Click "next", enter the name you'd like for the form, then
choose either the option to modify the form or to view or modify data.

On the other hand, if this is your knowledge level, you should not be
relying on newsgroups to get "tutorials"... Visit the site
http://office.microsoft.com and follow the links to training -- there is
good, and free, training material available. Or visit
http://sp.ntpcug.org/accesssig/default.aspx, and click the link to Crystal
Long's tutorials in the list of MVP sites on the page.

For rank novices (for which classification, not knowing how to display a
table in a form would qualify you), I have often recommended the Microsoft
Press book "Microsoft Access XXXX Step by Step" (where XXXX is the version
number of Access you are using). To go deeper into Access, the Microsoft
Press book "Access XXXX Inside-Out" by John Viescas (or for Access 2007, by
Viescas and Jeff Conrad) is a good one (again I use XXXX to represent the
version number).

If you are not at that elementary level, I apologize for wasting your time,
but would still think you need to clarify what you want.

and also to create a graph for the fields on
a tabbed form

I suspect you'll have to clarify what you want for anyone to be able to
answer. My Access database applications so rarely use graphs that I'm sure
someone else will need to answer this question when you do clarify it.

Larry Linson
Microsoft Office Access MVP



.

Loading