Formatting question

H

Harddrive747

I now have a formatting issue that I would like help with.

I have an Access database that will have a list of activities and I will
have those activities queried and put into a web page. The information will
have date, time and other information. So I will be pulling both of these
information out of the database.

1. I would like to know how to format the time so that it says something
like 7 p.m. instead of 19:00:00 or 7:00:00 PM, or even to have it say 7:30 PM.

2. I would like to be able to insert the time into a text box as 7 and then
radio button that say PM and AM. Then when it goes into the database it is
formatted correct and the database will accept it.

3. How do a format the date? I would like it to read 11-dec-04 instead of
12/11/2004?

4. When I use a drop down box from a query for an input form, how can I get
it to display nothing in the box until I select one of the choices?

That's it for now.

Look forward to any and all responses.
Terry
 
H

Harddrive747

Thomas, thanks for the page. However, I'm still not 100% sure how to work it
with webbot.

If I could see a line of code with webbot to help me understand how to write
the line would be terrific. Otherwise, I just need to test with what I find
on the page that you have given me.

Thanks.
Terry
 
T

Thomas A. Rowe

You are going to have to learn to hand code, if you want to do anything that is outside the what the
FP components can do or provide for. I don't use the FP database components.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
 
Top