Hi,every one.
I am a newbie to access vba.

Now I got a problem.I generated a webpage from a table of access to display the records in the table.

The problem is that everytime I open the web page ,it starts at the first
record.There is a date data in every record.For example,the first record is Oct,1st.I wanna to see the current date record on the first sight I open the web page.For example,today is Oct,10th.I wanna to see the Oct,10th record when I open the web page.

I don't know whether vba is availalbe in a web page.

Anyway,I will be appreciated if anyone can give me any suggestion.

Thanks in advance.

Instead of posting the table, post a query with the data from the table you want to see, then sort the query on the date field descending, then set the Top Values property to 1. This will return only those records with the most current date each time.

Alternatively, in your asp code, you can capture today's date (Date()) and then in your ASP query do "SELECT * FROM tblMyTable WHERE [DateField] = " & TodaysDate

HTH

mmcdonal

Actually, the query above will return only the most current record. If there is more than one record with the latest date, then you may want to sort on another field as well to get the one you want.

The second alternative will give you all the records with TodaysDate.


mmcdonal