How to create an interface to display table records

[rocket-cat]

Hi. I am very new to Access. I have a simple thing that I am trying to do,
but for some reason am not able to put the pieces together to figure it out.

Here's my situation: I have a table that has a bunch of data in it. You can
think of this data as a bunch of orders. Each record in the table has a
bunch of informative info in it that tells about the order. For instance,
the "cashier" who took the order, whether the order is active or inactive,
and the date of the order. I've also built a form that allows for easy entry
of data into this table.

Here's what I am wanting to do: I want to create some sort of interface to
retrieve information out of this table and display on the screen. I know
this sounds simple, but what I'd like to see is a web page, or other type of
entry point, that allows a user to select a cashier's name and see all of the
records (with all of the accompanying information) that the "cashier" has
taken. I'd also like them to be able to search for all the orders for a
certain date, or also search for all "active" orders and display it on the
screen. Again, I know this is super basic stuff but I am having troubles
with the "front side" of this.

 

[Brian]

Hi. I am very new to Access. I have a simple thing that I am trying to do,
but for some reason am not able to put the pieces together to figure it out.

Here's my situation: I have a table that has a bunch of data in it. You can
think of this data as a bunch of orders. Each record in the table has a
bunch of informative info in it that tells about the order. For instance,
the "cashier" who took the order, whether the order is active or inactive,
and the date of the order. I've also built a form that allows for easy entry
of data into this table.

Here's what I am wanting to do: I want to create some sort of interface to
retrieve information out of this table and display on the screen. I know
this sounds simple, but what I'd like to see is a web page, or other type of
entry point, that allows a user to select a cashier's name and see all of the
records (with all of the accompanying information) that the "cashier" has
taken. I'd also like them to be able to search for all the orders for a
certain date, or also search for all "active" orders and display it on the
screen. Again, I know this is super basic stuff but I am having troubles
with the "front side" of this.

I don't understand why you say "a web page, or other type of entry point".
Do you want to put it on the web? If so, then a web page is your only
option, and you are in the wrong newsgroup. If not, then do NOT consider a
web page. When it comes to data forms, the web is still light years behind
technologies such as Access and Visual Basic.

If you've created a form for data entry to your table, then far and away the
simplest way of presenting the data in the table is to use this form! You
can display it as a datasheet or continuous form to show a list, and you can
use the built-in filtering features of Access e.g. filter-by-form to
"search" for data in the way you describe.

 

[INCONNU]

I am french .... !!
Envoyé avec Microsoft Entourage 2004 pour Mac - Version d'évaluation.

 

[JohnR]

Does Anybody care ????