Recent content by henry_s

  1. H

    Insert 'Now()' into field OnClick

    This has really got me stumped, I'd appreciate any advice or alternative solutions. Thanks.
  2. H

    Insert 'Now()' into field OnClick

    Thanks for the reply, I thought it would be similar to that... now I've got the following code in the <HEAD> section <SCRIPT language=vbscript event=onclick for=SignIn> <!-- Me.Time_Logged_In = Now() --> </SCRIPT> ... but see screenshot... 'SignIn' is a command button, and Time_Logged_In is...
  3. H

    Insert 'Now()' into field OnClick

    Hi, I'm trying to insert the current time (using validation and the 'Now()' function) into a field on a data access page. I know as much as selecting a field and the event, so currently I have <SCRIPT language=vbscript event=onclick for=Time Out Logged> <!-- --> </SCRIPT> Could someone...
  4. H

    Find all records where provided date is 1 year ago

    Hi, I currently have a database with a field for a month, and another field for a year. These are not date fields, their Text + Number fields. The Month field contains the 3 letter abbreviation for the month (e.g. Jan, Feb, etc) I'm presuming I'm going to have to create a single field to...
  5. H

    Calendar inputting date into Date field

    Hi, I'm using Access 2000 with Calendar Control 9.0. I have setup the Calendar Control on a seperate form that pops-up from the original input form if a hyperlink is clicked. My problem is this: This works find for record #1, however if I then close the calendar pop up and move to a...
Back
Top Bottom