Recent content by Rugby83

  1. R

    Date formatting (General Date to Short Date)

    Thanks for the response. Unfortunately, I've already tried that, and when the infromation is displayed online, it reverts back to the long format. I guess, like you said, I'll have to resolve my problem on the web end.
  2. R

    Date formatting (General Date to Short Date)

    I am creating an online post, similar to a guestbook. When a user submits an entry, I am storing the date and time in a column titled "Timestamp", which is formatted 8/4/2005 9:16:58 ("General Date"). I am running the table through a query which is then posted on the web. What I would like to...
  3. R

    Auto Delete Records?

    Thanks so much. It works great, plus I learned a lot.
  4. R

    Auto Delete Records?

    Sounds great. How do I create a delete query? I already have a query that returns the entries that are more than 7 days old. Also, how do I make the query run automatically every time the database is accessed? Unfortunately I don't know a lot about the coding side of Access at all. Thanks so...
  5. R

    Auto Delete Records?

    I am creating a web database where users submit entries using an online form. When they submit the entry, I am saving the entry date and time in a column called Timestamp. What I need to figure out is if there is a way to create some sort of expiration date, based on the Timestamp, that will...
  6. R

    E-mail Notification of Post to Table

    I don't know much about macros, so I don't even know if this is the right place to post this... I have an online (FrontPage) form that I have configured to post entries into a database table. What I need is for a standard e-mail (i.e., "There is new data in the database") to be sent to a...
  7. R

    E-mail Notification

    E-mail Notification for Post to Table I have an online (FrontPage) form that I have configured to post entries into a database table. What I need is for a standard e-mail (i.e., "There is new data in the database") to be sent to a predetermined e-mail address whenever a new entry is added to...
Back
Top Bottom