display all records data access page

[Total Beginner]

Ok, first off, I am totally new to Access, so my question might seem way too
basic, but after searching through 100s of webpages (ok, maybe a bit
exaggerated) and the online help function, I still couldn't find an answer to
my challenge:

First, the question and then a little background on what I have already done:

Question: I need to be able to see all records in the data access page (just
like in the datasheet view when using access database) when published
online. Currently, I can only see one record at a time, which is bad because
I need to be able to quickly scan through 1000s of records. Even then, just
like in access database, I need to filter it down to 100s of records and see
them simultaneously, not just one record at a time.

Ideal world: This is how it should look - Have a spreadsheet (or datasheet
view) view of all the data using about 1/3 of the webpage with scroll buttons
(basically, it looks exactly like when you insert a spreadsheet object in the
access data page). The other 2/3 of the page should be the individual fields
of one record I select (from the spreadsheet above). The info of each record
should show if I click on a different record in the spreadsheet above. And I
need to be able to edit that in the fields below. That's all.

Here is what I have already done.
* I have set up a database that has over 3000 records now.
* I want to make this database available dynamically on the internet (I have
set up a data access page for online viewing.) so that people can update the
information anytime, anywhere.

This seems like the most basic thing Access database should be able to do -
I just can't seem to figure out how to do it. Any help would be much
appreciated!!!!!!!

 

[TC]

I'd like to help you, but I don't know DAPs. However, this is not the
best group for your question. This group, as its name implies, is for
questions on how to design the table structures in an mdb. Maybe try
browsing the other microsoft.public.access.* newsgroup names, to find a
more appropriate one?

HTH,
TC

 

[TC]

PS. What you could do, is to re-post your question as a /reply/ to this
one, and state in the "Newsgroups:" line, the names of the other
group(s) where you want it to go. That way, everyone in this group &
the other ones, will see everyone else's replies. Otherwise you may end
up with two threads (one here, another elsewhere) which do not
communicate.

HTH,
TC

 

[TC]

One more PS! (geez, this is getting my posting count up!)

Use a better Subject line. People use the subject line to decide
whether to open and read a post. With your current subject line, a
significant number of people will not even open & read it.

Cheers,
TC

 

[Total Beginner]

Thanks so much for all your posts!!

In case anyone reads this thread and is wondering about part of the solution
to my problem, it is very simple. In the design view in the data access page
right click your mouse and click on "group level properties", then you select
in the data page size row how many records you want to show on one page (in
my case "all). That's it!!!!

Now the only thing left for me to figure out is how to put the database
online with a search button.

Hope this helps to whoever stumbled across the same problem.

 

[Sylvain Lafontaine]

http://msdn.microsoft.com/library/d...c2k2/html/odc_customfilteringandsearching.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k2/html/ODC_acc10_DSCOM.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/programdap.asp

Newsgroup about DAP: m.p.a.dataaccess.pages. On Google:

http://groups.google.ca/group/microsoft.public.access.dataaccess.pages